Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    859 Ideas

    R
    Explorer
    rrnExplorer

    Unused field - ability flag a field as usedIMPLEMENTED

    When running the "Find unused fields" function, Tx may find and report "false positives" - that is fields that the developer is using in custom scripts. Removing these fields will yield errors when executing the project (this happens even if the tables and fields involved are all referenced in the script). It would be good to be able to manually flag a field as "in use" to allow the "Find unused fields" function to ignore them.

    4
    M
    Forum|Forum|5 years ago
    O
    Visitor
    ole.wielundVisitor

    Use parameters as a "where Clause" when running Execution packagesSUBMITTED

    The ability to load an execution package with parameters, would be a way to limit the number of business unit. For instance I use the NAV adapter, but need to build several BU in order to separate differenct companies pr country. Having the functionality to execute a package with a "where clause", in this case the dw_account field, would eliminate the overhead.

    2
    M
    Forum|Forum|5 years ago
    S
    Visitor
    spaulsethVisitor

    Sequential scheduling for execution packagesSUBMITTED

    When setting up executions packages it would by extremely useful to be able to schedule the execution of the package based on when other package executions finish, dependent or not to the previous package succeeding.Im suggesting a possibility to schedule execution packages with execution queues, being able to set when the queue is supposed to start. (Today it is only possible to do this using the "Run Package" selection when creating/editing execution packages, but it is dependent of the previous scheduled package to succede.)

    1
    M
    Forum|Forum|5 years ago
    M
    Visitor
    mharangVisitor

    Create hierarchies in a Semantic model tableIMPLEMENTED

    It would be very helpful to be able to create hierarchies in a semantic model table, then having hierarchies as a part of the cube definition. When deploying a tabular model to Azure we now have to define the hierarchies after each deployment, which is a bit cumbersome. One option: Right click table, 'Create hierarchy' along with 'Add measure' -> then a simple popup to define the levels.  

    5
    M
    Forum|Forum|5 years ago
    sten.lomme
    Participant
    sten.lommeParticipant

    Improve MS Dynamics BC/NAV Adapter Account ChangesSUBMITTED

    We are using the Navision adapter extensively with several accounts in Navision/BC. It seems that the Nav adapter uses the Nav Account Name to reference the objects in the Nav database. We are now looking to update and change the Account Name of some of these companies in Nav. We see that it creates issues with incremental tables, history tables and snapshot tables when a company changes name in Nav/BC. So a change of the company name in BC will update the value in the Company table and then rename all the table objects to reflect this change. This would add duplicate records in both incremental, history and snapshot tables. In BC they now have a unique company id field called "Id". So even if the company name changes, this id will be unchanged. A better setup of this adapter would be to use this id as the DW_Account on all objects in TX. Then it doesn't matter if the company name changes in Nav/BC. TX would use this id internally on all objects, but reference the table object with the value in the Company.Name field.

    2
    M
    Forum|Forum|5 years ago
    sten.lomme
    Participant
    sten.lommeParticipant

    Add possibility to enable and disable Additional Connections on Data SourcesSUBMITTED

    Hi, We are using the Google Analytics connector to pull large amounts of data from the Google Analytics API. We also use the Data Source feature with Additional Connections. This lets us pull data from several Google Analytic Views with a single implemented Data Source and Query Tables. We pull data from seven Additional Connections and it would be really good to be able to enable and disable some of these from time to time, in order to pull data from only one of the Connections. These data pulls uses GA data limits and runs for quite some time on large amounts of data.

    4
    M
    Forum|Forum|5 years ago
    sten.lomme
    Participant
    sten.lommeParticipant

    Add possibility to import/export parts of a project into a new projectSUBMITTED

    Your manual states that the import and export feature is useful "if you want to reuse parts of a project in another project." But this feature only allows for import and export of the whole projects, and not parts to be included in a new project. Selection templates partly solves this for Data Sources, but it does not solve the issue of moving objects from Stage/DSA into another project.

    2
    M
    Forum|Forum|5 years ago
    sten.lomme
    Participant
    sten.lommeParticipant

    Compression settings turned on by defaultSUBMITTED

    It should be possible to universally set compression settings to ON. So that all newly created objects are automatically compressed. Today we have to manually set this on all new objects.

    4
    M
    Forum|Forum|5 years ago
    B
    Visitor
    brianpVisitor

    Ability to execute dependent tablesSUBMITTED

    I would like the ability to select an object to execute (for example, in the data warehouse) and also have it execute all of the dependent tables. For example if I want to execute the "Sales" table in the data warehouse and it pulls data from the Sales Header and Sales Detail tables in the staging database then it would execute the source tables and then the Sales table.

    2
    JTreadwell
    Forum|Forum|5 years ago
    Søren Sørensen
    Contributor
    Søren SørensenContributor

    Single/Multiple Text File data typesIMPLEMENTED

    I'm working with a company that regularly receives large comma separated text files from external parties ... large as in 2-300 columns. It would be nice with a couple of features for specifying column data types: 1. Based on the first X rows (where X is user specified), Discovery Hub could make an initial data type suggestion, just like when we import data from a file in SSMS. 2. Multi-selection of fields (the usual Ctrl and Shift functionality) to update the data type for all fields in one go, also like importing text file data in SSMS.

    4
    JTreadwell
    Forum|Forum|5 years ago
    E
    Contributor
    emily.wynkoopContributor

    Better Automation for Manual Incremental LoadingIMPLEMENTED

    When you swap a table over to incremental loading manually, it would be really helpful if you got a quick popup dialog box with the following options:  1) Add source table DW_TimeStamp as an incremental field 2) Pick my own incremental field (taken to the incremental field selection pane) 3) Skip picking an incremental field for now With 1) as the default selection.  Business unit tables, of course, would only get options 2 and 3.  I think this would be a really nice little quality of life improvement that manually setting up incremental loading much faster and easier, and avoid the common problem of an error on deployment when no incremental field has been selected. 

    1
    JTreadwell
    Forum|Forum|5 years ago
    E
    Contributor
    emily.wynkoopContributor

    Execution Packages in the Solution ExplorerSUBMITTED

    The new visual layout of Discovery Hub is very handy!  One quality of life improvement that might help speed routine use of the tool would be to list the execution packages under the Execution Package node in the Solution Explorer, and allow them to be executed or dragged to the execution queue from there.  That would save having to open the execution package tab unless you wanted to actually make changes to the packages. 

    2
    JTreadwell
    Forum|Forum|5 years ago
    S
    Starter
    Søren C. T. RavnStarter

    Tabular scriptSUBMITTED

    We need scripting in the tabular model in the same fashion as it is possible in the OLAP model meaning that we can add scripts at different levels as well as pre and post scripts on the model it self.

    2
    JTreadwell
    Forum|Forum|5 years ago
    A
    Visitor
    andy.shadleVisitor

    Deploying a partial project - or parts of a given project (partial release)SUBMITTED

    We are in the position where we are working major changes against a given project.  The changes are expected to take some time to complete.  Meanwhile, smaller MOB projects force us to make changes.  We would need a solid methodology for deploying ONLY the portion of the project necessary to deploy the MOB projects.  We are a SOX company and separation of duties are a large issue here and we do NOT want to manually make the changes directly in production.  We also do not want to deploy untested objects into our production environment by deploying the entire project.  This is a serious issue for us, and we need a solution if we are going to continue to make use of TimeXtender as part of our BI solution. Thanks!

    4
    JTreadwell
    Forum|Forum|5 years ago
    W
    Contributor
    wynkoopContributor

    "Show Translation" in the Semantic LayerIMPLEMENTED

    It's not currently possible to see what code TimeXtender is committing to the various front-end endpoints.  The ability to see this code is extremely helpful when it comes to actually writing out code in the program itself.  Without this, it's either possible to parameterize your code, or make the code easy to understand.  You can't really do both.  The lack of "Show Translation" makes very useful features like fully qualified fields a really mixed bag.  It can be confusing to tell what you're doing in more complicated measures, because the code you see in a properly parameterized Script window is so different than what is actually sent to the front end system.  In order to create something understandable, the user may be forced to use less efficient, more verbose options, like adding the table name and the field name individually.  A user might also simply decided to skip the Tabular front end altogether and design the tabular model in Visual Studio, just to be able to see what they're actually doing. Clearly, this is an outcome we'd like to avoid!

    2
    JTreadwell
    Forum|Forum|5 years ago
    E
    Contributor
    emily.wynkoopContributor

    Context-Sensitive WindowsIMPLEMENTED

    The new multi-pane layout of Discovery Hub is great, but it has a bit of a problem in that the windows aren't context sensitive in some cases - what happens in one window happens in all windows.  An example of this is creating relations between tables.  Doing this with the same database open in two panes makes this process much easier and faster!  Except that creating a relation cause the UI to snap to the relations node of the table where the relation has been created.  It does this for all panes and windows that contain this table, even though you'd want it to only happen in the "destination" pane and nowhere else.  Honestly, as a more advanced user I find the "snapping" functionality to be frustrating.  But if it has to happen, making it happen in all windows and panes makes the new layout much less useful for tasks like creating relations..   Another example is opening tables in new windows.  If you have multiple panes open, and open tables in a new window, if you close any of the panes, all of the open windows close.  It would be very helpful to close only the windows that were opened from the pane that's being closed.  

    5
    JTreadwell
    Forum|Forum|5 years ago
    J
    Starter
    jnortonStarter

    DSA Data movementSUBMITTED

    I would like the ability to create data movement from one table to another all within a single layer (DSA).    ex.  ODX.dbo.TableA -> DSA.dbo.TableA -> DSA.dbo.TableB -> MDW.dbo.TableB   the only way to insert data from TableA to TableB is to create a seperate table insert, instead of using the much easier drag & drop mapping from one table (or column) to another table (or column).  this would allow developers more flexibility in their build strategy as well as taking advantage of TimeXtender functionality. such as, Incremental loads, add related records, etc.  i have this problem often where i need to create workarounds. 

    2
    JTreadwell
    Forum|Forum|5 years ago
    W
    Contributor
    wynkoopContributor

    Global Databases: Copy Database SettingsSUBMITTED

    It’s very common for a data source to have almost identical settings, except for one or two fields.  This makes setting up global databases frustrating, because all connection information needs to be added each time. Being able to copy settings between environments in a global database setup would be extremely helpful and make the window feel more automated. 

    3
    JTreadwell
    Forum|Forum|5 years ago
    D
    Participant
    david.zebrowitzParticipant

    Semantic Model Table PermissionsSUBMITTED

    We currently have the ability to create role based security on individual fields within Semantic Model Tables, but there isn't the ability to restrict access to an entire table in the model.

    2
    JTreadwell
    Forum|Forum|5 years ago
    W
    Contributor
    wynkoopContributor

    Set Default Lookup BehaviorIMPLEMENTED

    Currently, if you create a relation between two tables and then do a lookup between those tables, the default option is to not use an explicit join.  However, explicit joins are really useful for understanding a lookup at a glace.   If explicit joins are not the default behavior, it would be really helpful to be able to specify a default behavior for new lookup creation on the project level.  It's only one click to choose an explicit join, but over hundreds of lookups, it becomes a serious time waster. 

    19
    JTreadwell
    Forum|Forum|5 years ago
    J
    Contributor
    jens.mikkelsenContributor

    Table Insert - DW_SourceCodeIMPLEMENTED

    On table insert it would be nice to be able to fill out the system field 'DW_SourceCode' just as any other field on the table you are filling with data.   Regards Jens Jørn

    2
    JTreadwell
    Forum|Forum|5 years ago
    D
    Participant
    david.zebrowitzParticipant

    Automated Surrogate Key "Unknown Bucket" Transforms from History Enabled TableSUBMITTED

    Some features have been added recently to automatically add the joins necessary for handling SCD Type 2 lookups from a History Table. I'd like to suggest another enhancement which would save a ton of time and manual clicking when we're adding Surrogate Keys to fact tables. Dragging and dropping DW_ID from a history table to a fact table is easy.  But the process of adding the Fixed transformation for a -1 "Unknown Bucket" requires a lot of clicks, is error prone, and is something I despise doing. I'd like to suggest the following enhancement to the new dialog that appears when dragging a field from a history enabled table.  Note that this option should only be available if dragging DW_ID.   A simple checkbox to add the surrogate key "unknown bucket" transform fixed transformation and also add the Is Empty condition: There have been several times where developers have clicked on the wrong field for the condition, or forget to add the condition, so this would be a great help. Also, try adding the transform and the condition 25 times for 10 fact tables.  Your mousing hand will quickly agree with my suggestion.  I promise!    

    2
    JTreadwell
    Forum|Forum|5 years ago
    D
    Participant
    david.zebrowitzParticipant

    Multi-Environment Transfer + Version NotesSUBMITTED

    I had a request come from a customer today which seems like a good idea.  They have to maintain strict SOX controls, so knowing what version was deployed, by who, and when are important pieces of information their auditors need to know.Currently, when a project is transferred between environments, there isn't any notation in the project version notes.It would be very useful to simply add the information displayed after a successful transfer to the target environment's new version created by the transfer:  So, in this case version 69 was created in PROD.  It would be very nice if the information circled above was entered into version 69's notes.  Otherwise my SOX compliant customer will need to maintain manual logs of transfers.

    6
    JTreadwell
    Forum|Forum|5 years ago
    J
    Contributor
    Jacob.Ross.AndersenContributor

    Enable show system control fields retroactiveSUBMITTED

    Enabling the "Show System Control Fields" in project settings will not make system control fields visible for existing table in the project. The tooltip does indicate that it " will automatically be added to new tables...". However, I think it would be useful to add the option to show system control fields retroactively, so you don't have to enable them for each existing table object manually. Thanks  

    2
    JTreadwell
    Forum|Forum|5 years ago

    Information of failed transfer of data sources with relaxed error handlingIMPLEMENTED

    Errors when reading data sources with the new option of continue with empty/previous valid data is hidden after manual execution – the execution should of course continue but afterwards the developer should be notified that errors are present in the log.  

    7
    JTreadwell
    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