Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    863 Ideas

    andri
    Contributor
    andriContributor

    Business unit settings - table order and schema foldersSUBMITTED

    Since the business unit settings dialog is rather poor on options I would like suggest some additions. When using the BU as an ODX it would be good to have it automatically organized. By having the options to always sort tables alphabetically by default and group tables into folders by schema, that would give better visibility in large projects in my opinion.

    2
    Forum|Forum|5 years ago
    andri
    Contributor
    andriContributor

    Source identifier when merging multiple simple mode tablesSUBMITTED

    A source identifying field is needed in a setup where the ODX is in simple mode and there is a need to merge data from multiple tables into a single staging table. If there is no source identifying column in the tables we are forced to remove simple mode from these source tables to be able to add a custom field with a fixed value to distinguish between the data in the staging layer.

    8
    Forum|Forum|5 years ago
    andri
    Contributor
    andriContributor

    Use schema from data source only as a prefixSUBMITTED

    Today we have the option of an automatic prefix on the data source that concatenates the data source name with the schema name. Having the option to only prefix with the source schema name would be a nice option when building a clean ODX where you have a schema for each data source. That would allow tables with the same name in different schemas without also having the data source name in the prefix.

    2
    Forum|Forum|5 years ago
    andri
    Contributor
    andriContributor

    Surrogate keys - Input for default values where we can set DW_Id = -1SUBMITTED

    It would be very useful if you could add a default data row for a dimension table in a similar way you add custom data but without getting a custom data table and where you can set DW_Id = -1, which is common. The input ui could be in the same dialog as the custom data input or a separate dialog. The ways to do it now are either: 1. Creating a post-deploy script for each dimension table where you do SET IDENTITY INSERT ON and then an insert statement with all the values. 2. Adding a new custom field to use as a surrogate-key column, persisting dw_id from staging and inserting default values with custom data option.  Numer one is very un-DWA and boring to maintain and number two is somewhat going around things to get the desired resaults and having a custom table for each dimension table just to hold the default value is maybe unnecessary. Attached image is a quick mockup :) Best regards,Andri          default-values.png

    9
    Forum|Forum|5 years ago
    andri
    Contributor
    andriContributor

    Add option for a full load when adding incremental objects to the execution listIMPLEMENTED

    Having the option to do a full load on incremental tables when adding objects to the execution list would be handy.

    4
    Forum|Forum|5 years ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Project Variables - Show usageSUBMITTED

    Add function to see the usage for Project Variables.  When changing a Project Variable, it can be handy to see the impact for this change.  Just like the 'Show usage' option in Snippets and custom scripts. 

    0
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|5 years ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Mark semantic model red when needs to be deployedSUBMITTED

    When changing a table, depending tables are marked red and need to be deployed again. When changing a Semantic model, it is not marked red. Add same logic as staging/data warehouse tables on semantic model when it needs to be deployed again.      

    0
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|5 years ago
    Visitor
    magnus.jorstadVisitor

    ODX DW_TimeStampSUBMITTED

    The analyst should always be able to see the timestamp of when the data is extracted from the source system. This is especially important in validation processes, but also as metadata information during analysis.  Using Business Unit one could make use of the DW_TimeStamp field. This does not exist in ODX.  Technically, one may copy the SQLLite backlog file and extract ODX execution information into DWH. However this would require considerable effort as one would have to set up a task (e.g. batch script) to regularly copy the SQLLite backlog file, make another TX connection to it and merge the data in the DWH.   Adding a DW_TimeStamp on ODX tables would be ideal. Other solutions could be to make the ODX execution details more accessible, e.g. as a table in the ODX.  (Ticket  #21213)

    2
    Forum|Forum|5 years ago
    hugo.winkelhorst
    Participant
    hugo.winkelhorstParticipant

    data lineage for custom table insertSUBMITTED

    An option to manually "fix" the data lineage for custom table inserts as is in place for custom views would be very appreciated.

    2
    bas.hopstaken
    TimeXtender Xpert
    Forum|Forum|5 years ago
    Explorer
    william.wynkoopExplorer

    Compare two savesSUBMITTED

    Our client would really like to be able to see the differences between two saved versions of a project, similar to a differential deployment report.  There have been a number of other requests for functionality like this:  The ability to compare two projects Compare project versions in multiple environments Multiple environment transfer + version totes (request for version saves to show differences listed in the comments) This feature would go a long way towards providing transparency in the development process, which would in turn make multiple developer development easier to do.  I think that level of transparency would also help non-BI experts gain trust in the tool.   Best regards, Doug Wynkoop

    13
    Forum|Forum|5 years ago
    hugo.winkelhorst
    Participant
    hugo.winkelhorstParticipant

    object version historySUBMITTED

    being able to see the version history on object level, maybe right click => advanced. To be able to see who made what changes would be very helpful in projects with team development. 

    2
    Participant
    Forum|Forum|5 years ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Add environment name as parameter for mail notification subjectSUBMITTED

    Add a new subject parameter for mail notifications that includes the environment name. 

    1
    Forum|Forum|5 years ago
    Participant
    raf.lemmensParticipant

    synchronize all views in one goSUBMITTED

      So we have a lot of views in our MDW which serve as an interface between MDW and Semantic Layer.If we update a lot of dim_tables, we have to synchronize the views one by one which is not really an "automated" job. Please provide an option to synchronize all views with "one" click.

    0
    Participant
    Forum|Forum|5 years ago
    Starter
    p.laadStarter

    Enable CI/CD for TimextenderSUBMITTED

    Enable Continuous Integration and deployment by integrating with Azure DevOps. This can be done if we can deploy components in TX based on scripts or commands. We need a task for TX which can be added to build and release pipeline of Azure DevOpsThis feature is in addition to the below feature request for enabling deployment of single/multiple components to multiple environments.In addition to the below feature requesthttps://legacysupport.timextender.com/hc/en-us/community/posts/360014857198-Add-feature-to-deploy-single-or-multiple-component-between-environments-instead-of-deploying-the-whole-project

    0
    Starter
    Forum|Forum|5 years ago
    bas.hopstaken
    TimeXtender Xpert
    bas.hopstakenTimeXtender Xpert

    Deploy and execute to other environmentSUBMITTED

    When you transferred the project to another environment. You need to deploy it, after the deploy the tables are truncated. When you want to execute the newly deployed tables, you need to remember all tables that are newly deployed and execute them one by one. It would be great to have an option to deploy and execute the tables in the new environment (from the multiple environment transfer window).     

    2
    Starter
    Forum|Forum|5 years ago
    Starter
    bjarkimgStarter

    Takeing Tagging furtherSUBMITTED

    Can we get a visualization (on fields) for tags when active with perspective,  for example tagging custom fields for customers like this, see image.

    7
    Forum|Forum|5 years ago
    Starter
    Steffen DavidsenStarter

    Copy/Paste Measures in Semantic LayerSUBMITTED

    It would be useful, to be able to copy/paste a measure in the semantic layer. Since there is no option to hide an intermediate measure, we often duplicate parts of the measure calculations, but it is quite time-consuming to re-map all the parameters.

    1
    Forum|Forum|5 years ago
    Starter
    lars.rasmussenStarter

    Secured ViewSUBMITTED

    Hi Guys, I would be nice to give all members of the db_owner role access to all data in secured views. This way report designers can use the view even though they are members of db_owner. You could have a flag 'Give duo full access' for example. You could simply add OR IS_ROLEMEMBER('db_owver') = 1 at the end of the view definition. Regards, Lars

    1
    Forum|Forum|5 years ago
    Starter
    lars.rasmussenStarter

    Highlight Incremental tables during deploymentSUBMITTED

    Hi Guys, It would be extremely helpful if incremental tables are highlighted during deployment when a full load is triggered. As it is today we need to expand every incremental table to see if the Full Load checkbox is checked or not. This will minimise the risk of full loading an incremental table by mistake. Basically just highlight the table when TX decides to check the Full Load checkbox. Regards, Lars

    5
    Forum|Forum|5 years ago
    Starter
    lars.rasmussenStarter

    Error logging for additional data sourcesSUBMITTED

    Hi Guys, It would be extremely helpful if we could somehow see the exact reason for the error when "Continue with no/existing Data" is enabled on an additional data source. Is it caused by a Timeout, a non-existing field on an additional data source, truncation of text field etc. Currently we can only see the table was not loaded. Not why. Regards, Lars

    4
    Forum|Forum|5 years ago
    Starter
    david.kesselheimStarter

    Show highlighted tables originSUBMITTED

    Consider the following setup: PRODUCT-table in ODX PRODUCT-table in DSA PRODUCT-table in MDW When highlighting one of the tables it would be nice to see somewhere central (top bar or bottom bar) what table is actually highlighted when scrolling through fields.   It's easy to loose overview when scrolling through a long list of fields or tables and it would therefore be nice to see somewhere which table actually has the focus atm. This would also reduce the risk of errors in case one did an unwanted click somewhere by accident.  

    3
    Forum|Forum|5 years ago
    Visitor
    epeVisitor

    Excel Data Provider - multiple files in folderSUBMITTED

    Hi, I'm having a project from which I need to load multiple Excel files from a folder (stored in .xlsx format and not CSV).  Would be nice to have a data provider which allowed for appending all those workbooks in a specific folder, obviously given file structure is identical.

    2
    Forum|Forum|5 years ago
    Starter
    larsingvar.nilssonStarter

    New feature request: Warning on Execution PackagesSUBMITTED

    For execution packages there should be a WarningStep with possibility to get Mail, In many cases when you are having issues with connections to source data, you need to use ex continue with existing data. In those cases the success message contains info about the warning. But we should not be relying on external systems to filter and monitor success messages for Warnings, to get notification about these events. So I suggest a WarningStep. A step when the Execution package has been able to be completed, but it contains warnings.

    4
    Forum|Forum|5 years ago
    Starter
    sigurdur.jonssonStarter

    Grouping of data tables by schemaSUBMITTED

    Would love to be able to group the tables in the table lists (Data Warehouses and Business Units) by their schema, in an hierarchical fashion.

    4
    Forum|Forum|5 years ago
    Starter
    sigurdur.jonssonStarter

    Automatic NULL handlingSUBMITTED

    Would like to have automatic NULL handling available on either source or table level.  An automatic function (optional of course) that would cast NULL values to either blanks, 0, etc., depending on datatype.

    1
    Forum|Forum|5 years ago

    Filter by product

    • All products
    • TimeXtender Data Integration
    • TimeXtender Data Integration Portal
    • TimeXtender Data Enrichment
    • TimeXtender Orchestration & Data Quality
    • TimeXtender Classic
    • Data source providers
    • Exmon
    Terms and ConditionsAccessibility statement