Skip to main content

Featured Topics

Guide

Guide to ideation

Read me first if you got a need for a feature that is currently not offered or a feedback regarding the way things work, you can submit an idea. Creat

262 Ideas

D
david.kesselheimNew Participant

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
M
Forum|Forum|4 years ago
E
epeNew Participant

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
M
Forum|Forum|4 years ago
L
larsingvar.nilssonNew Participant

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
M
Forum|Forum|4 years ago
S
sigurdur.jonssonNew Participant

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
M
Forum|Forum|4 years ago
S
sigurdur.jonssonNew Participant

Data profiling capabilitiesPLANNED

It would be great to be able to run data profiling on tables from within Discovery Hub.

5
M
Forum|Forum|4 years ago
S
sigurdur.jonssonNew Participant

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
M
Forum|Forum|4 years ago
S
sigurdur.jonssonNew Participant

Deployment and enviroment transfersSubmitted

I would like to have differential check as the initial step in environment transfer, and from that step get a selection of objects I would like to transfer.  In my opinion one should not transfer objects still in development to the production environment, which one is forced to do in the current setup.   The production environment should be a clean production environment!

4
M
Forum|Forum|4 years ago
J
jarleNew Participant

Copy/Paste tables, fields etc.Submitted

It would be nice to be able to copy: - Tables between databases      - Exact same table, or just table structure (as clone works today)      - To other projects (but this could maybe be done by advanced import/export - Fields between tables in whole project. (Exact same field) - Dimensions, Cubes, OLAP Roles,Semantic models, Table inserts, custom scripts, views, project perspectives, Data sources, Databases... In cases where the field is based on other fields not existing, the easiest could be to just remove these things, or set to empty, but the best would be if they stay the same, but with "invalid" marking on.  

2
M
Forum|Forum|4 years ago
J
jarleNew Participant

Give results from custom table inserts when searchingSubmitted

The search function already gives results from all script actions, but not for custom table inserts, which is a kind of script action as well. It would also be nice if it works in normal table inserts and "Add related records", in case something is set as "Fixed Value" there. In my opinion, everything which is "hardcoded" in Discovery Hub should be possible to show in a search.

1
M
Forum|Forum|4 years ago
R
rrnNew Participant

What happens when?Submitted

It would be a great feature to the documentation to see what happens at what stages in the process to be better able to determine when to put pre- and post- scripts.

4
M
Forum|Forum|4 years ago
R
rrnNew Participant

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.

3
M
Forum|Forum|4 years ago
O
ole.wielundNew Participant

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|4 years ago
S
spaulsethNew Participant

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|4 years ago
M
mharangNew Participant

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.  

3
M
Forum|Forum|4 years ago
S
sten.lommeKnown Participant

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|4 years ago
S
sten.lommeKnown Participant

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|4 years ago
S
sten.lommeKnown Participant

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|4 years ago
S
sten.lommeKnown Participant

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|4 years ago
J
jens.mikkelsenKnown Participant

Clean up of old projects versionsNot Planned

A possibility to remove all but the latest version of a given project. => Gives faster opening of projects.

3
C
Forum|Forum|4 years ago
B
brianpNew Participant

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
J
Forum|Forum|4 years ago
S
sjsNew Participant

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.

2
J
Forum|Forum|4 years ago
S
sjsNew Participant

External metadata managementSubmitted

There are companies that manage their metadata such as table and field naming conventions in external systems. In AX, an example could be that the field DATAAREAID should be called Company in the MDW. I'm after a feature where we can link to or import a metadata mapping table that for a given data source can map the data source field names to whatever the metadata mapping table contains (e.g. DATAAREAID -> Company). The feature could be implemented in a three stage solution where the ODX contains the simple-loaded source data as named in the source system (DATAAREAID) whereas the DSA could then contain the mapped name (Company). Such mappings in DSA should of course also cater for table name mapping. (It could also be implemented in a two stage solution in the MDW).

2
J
Forum|Forum|4 years ago
K
kyle.clubbNew Participant

ODX params for Data SourceSubmitted

Need the ability to put params into the ODX data source settings. For example. to support incremental URL query strings that need changing values.

1
J
Forum|Forum|4 years ago
E
emily.wynkoopKnown Participant

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
J
Forum|Forum|4 years ago
E
emily.wynkoopKnown Participant

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
J
Forum|Forum|4 years ago

Filter by product

  • All products
  • TimeXtender Desktop
Terms & ConditionsCookie settingsAccessibility statement