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

Filter by idea status

Filter by product

262 Ideas

S
supportKnown Participant

Add data selection rule & incremental selection rule directly on source field (right click menu)Submitted

Currently you need to add Data Selection rules on a source table by right clicking on the table and selecting "Add Data Selection Rule". It would be handy to have this option in the right click menu of the field so that you can add a rule directly there. Ie if you click on the field and select Add Data Selection Rule, the same right pane opens but immediately focused on the that field. Would again save a few clicks! Same with add incremental selection rule when applicable.

0
S
Forum|Forum|8 years ago
B
bas.hopstakenKnown Participant

Gant Chart / overview over all Exection PackagesSubmitted

A Gant Chart / overview of all executing packages including scheduled start time, overlap in concurrent running packages and execution times.This will help us to plan the executing packages because we have a total overview of all packages instead of clicking each package one by one and see the execution log details or the schedule. 

3
B
Forum|Forum|8 years ago
B
bas.hopstakenKnown Participant

Pre execution conditionsSubmitted

Add an option to set conditions before an executon task starts. For example. We want a condition that the task 'Execute DWH'  starts when all execution packages (multiple packages) from the DSA are successfully executed. 

0
B
Forum|Forum|8 years ago
S
supportKnown Participant

Automation: when using Additonal Adapters / Connections, include DW_SourceCode in primary keySubmitted

As title says, if you consolidate multiple sources, you need DW_SourceCode in the PK should the PK field of a table be the same in 2 databases. We see this in scenario's where companies want to consolidate multiple ERPs / sources but the ERP uses integers as PKs for companies / locations etc... This gives PK conflicts, which is solved by adding DW_SourceCode to the constraints. Navision is less impacted if the DW_Account is unique between two databases, but we have had a conflict there already so we add DW_SourceCode to the PK. So it would be great if the automation feature would take this into account and add the DW_SourceCode in the PK when Additional Sources are used.

1
S
Forum|Forum|8 years ago
J
janwillem.kuperNew Participant

Extra text in windows Create RelationImplemented

When you drag one field (Invoices.InvoiceID) on top of a second field (InvoiceLines.InvoiceID) you get the message "Do you want to create the relation?"   Is it possible to extend this text with which fields you want to connect? Do you want to create the relation on Invoice.InvoiceID and InvoiceLines.InvoiceID   This will give you an extra check that you dropped the first field on the right second field.  

0
J
Forum|Forum|8 years ago
B
bas.hopstakenKnown Participant

Make video about new featuresSubmitted

It would be great to make a video each release of a new version of TX DWA which explains all new features in the release. 

1
B
Forum|Forum|8 years ago
M
mvannordenNew Participant

Table Settings TemplatesSubmitted

Hi, It would be nice to be able to create your own table settings template. If you want to have many tables that need to keep history and load incrementally, it would save time if you could select the template with the settings you defined. Also, if many tables that rely on such a template need to get a different setting, you would have a central location to change the setting.

0
M
Forum|Forum|8 years ago
B
bas.hopstakenKnown Participant

Publish to Qlik Sense stream from TimeXtenderSubmitted

Add an option to publish a Qlik Model from TimeXtender to a specific stream in Qlik Sense.  

0
B
Forum|Forum|8 years ago
S
steven.koppenolKnown Participant

Improved usability for table icon hintsSubmitted

Many have suggested additional information to be immediately visible in the table icons. While the desire is understandable, it is also poor UX to try to put them all in a tiny icon. Instead of one merged icon before the table name showing a limited number of indicators, I would propose to show a series of icons or tags after the table name. In the preferences, the user can then choose which indicators to show. For example, I would want to see the following flag: * delete handling (no/soft/yes) * type 2 history fields (none/any) Reason is that this is part of the external contract for a table. Everybody using a table must be aware of whether they need to handle effective dates and tombstone flags.

1
D
Forum|Forum|8 years ago
B
bas.hopstakenKnown Participant

'Unqualify All' Button/Option Qlik ModelSubmitted

Add an option to unqualify all fields in Qlik Data Model.

0
B
Forum|Forum|8 years ago
A
andriKnown Participant

Easy and controlled way to sunset a replaced source..Submitted

..with the ability to run data from it again on demand. Consider the scenario where an ERP system is upgraded/replaced with a new one. Historical transaction data will not be migrated to the new system. Most but not all dimension data (customers, products, divisions etc.) are created in the new system. Data from the old ERP db will still be accessible. In TX we add a new source, new staging tables, and new cleansing rules. We map the new source to existing dimensions and facts. The old source is still mapped as well. Dimensions have history enabled and we do a surrogate key lookup in the facts. Source system is not a part of the PK. Many of the facts are incrementally loaded. We stop extracting data from the old system by guarding the source. The staging tables stores data from the last load (not securely though, it could easily be truncated in a future deployment if source settings change or a new TX release triggers a re-deployment?). We also should empty the old staging tables that are feeding a dimension since we need the new source to take over updating the dimension data. We don't want to remove the old source mappings of the dimensions in case we might need to run them again in the future (not all dimension data was created in the new system). Ability to disable/guard the data mapping of the old source might help? There are different ways to deal with this but there could be a better fully thought-out way to handle this scenario in TX (it's an imminent problem for a maturing data warehouse). Since all development for old and new is contained in the same project it requires a different approach than traditional ETL development where there is more separation and manual control. A white paper on a subject like this would be nice to have. How to use TX to handle different known data warehouse development dilemmas.

2
A
Forum|Forum|8 years ago
J
jake.entrekinNew Participant

Ability to convert a staging table to a Custom table?Submitted

TX version 17.1.5.64 SQL 2016 Standard.   We have a situation where a large table in AX (INVENTTRANSORIGIN) does not have a MODIFIEDDATETIME field available to execute incremental loads off of.  Our customer is experiencing performance degradation issues with the load due to the large volume of data it's having to reload daily. This table is also feeding a dimension, so we have history enabled.  We were going to attempt to execute target based incremental data loads, but you cannot apply that setting to a history table. One option would be to replace this table with a query table and have that do the incremental load logic from the source, but this is going to require a TON of rework as the table's surrogate key is referenced in dozens of other tables. Is there a way to either modify the staging table to be a custom table so that it's 'disconnected' from the source?  This would allow me to create a separate incremental query table and have that load our existing staging table via a custom table insert. Or is there a way to convert an existing staging table to a query table without having to start from scratch?  Thanks!  

2
J
Forum|Forum|8 years ago

Filter by product

  • All products
  • TimeXtender Desktop
Terms & ConditionsCookie settingsAccessibility statement