Product ideas

859 Ideas

For parameters, show mapped table + field name instead of only field nameSUBMITTED

Especially important for semantic scripts where the "show translation" option was removed in a recent version, but also very useful for regular scripts.

Forum|Forum|7 years ago

lennaert.vd.brinkStarter

Allow TX interface actions when AX adapter Table information is openSUBMITTED

The AX adapter (and probably other data adapters in TX) have the amazing feature of right-clicking a table to see all the Field information and relations to other tables. This is an amazing resource and tremendously helps in correctly building the ETL for such a datasource. However, as long as the window is open, I am unable to do any action in TX. It would be really sweet if the pop-up functioned the same as when you CTRL+W a table to a new window so I can just have the window with information open while I edit the tables.

Forum|Forum|7 years ago

bas.bruilExplorer

Report for the security settingsSUBMITTED

Organisations increasingly want to know who has access to which data. Could a simple report be created for that? In my opinion, it should contain the access rights per user (read/write/etc), per level in the TX project (Databases, Cubes, Endpoints), so our customers can have an instant overview in stead of checking each level manually.

Forum|Forum|7 years ago

rory.smithTimeXtender Xpert

Add visual cue for changes to Stored ProceduresSUBMITTED

If you change a stored procedure, Discovery Hub knows a Deploy is required (the orb in the bottom left changes to red), however there is no visual queue on the Stored Procedure itself. It would be good if Stored Procedures are coloured red and given a * just like other objects in Discovery Hub.

Forum|Forum|7 years ago

andriContributor

Filter to show only objects that are considered for deploymentSUBMITTED

In a large project, you might do a differential deployment on a perspective. After resolving what needs to be deployed you get the dialog with the entire project tree and a few objects are marked for deployment. It would be useful to have a button to filter out all the objects that are not marked for deployment so you can have a good overview of the objects that you're about to deploy.

Forum|Forum|7 years ago

steven.koppenolParticipant

Ability to "label" save versionsSUBMITTED

We have some many saves that it's impossible to find the right one. It would be handy if we could "tag" or "label" revisions: * Noteworthy milestones * Releases * Etc. Additionally, in a future cleanup functionality, you would optionally keep revisions that have tags.

Forum|Forum|7 years ago

peter.jensenTimeXtender Xpert

Highlight used tables and columns in parameter panelSUBMITTED

Hi, when creating / editing an object (view, stored procedure, script, …) where you can use the parameter panel, it would be a big help that used parameters (tables, columns, ..) are highlighted in the panel. It would be even better that the objects in the panel can be sorted and filtered (just the same way as we have for tables / columns in the data source panel). BR, Peter

Forum|Forum|7 years ago

william.wynkoopExplorer

Source Row CountsSUBMITTED

We all know that Discovery Hub is extremely reliable at moving rows from one database to another. However, proving that to other folks can be a challenge. Also, scripts, validation rules, incremental loading, history rules, and primary keys can sometimes cause a destination and a source table to come "out of sync," which is sometimes intended, sometimes not. In either case, this desync makes it harder to validate that the load is working as intended. Adding an extra count option to the execution package - a count rows in the source table - would a small thing to add, but an extremely powerful validation tool. This capability would make all kinds of tasks, from basic development to upgrading the software, much easier to validate. Ideally, this count would take into account data selection rules and data source settings, so we'd be able to quickly compare what we expected to get vs. what we actually got. Thanks!

Forum|Forum|7 years ago

soeren.schubertVisitor

Import (tabular model) .bim files into semantic layerSUBMITTED

It would be very useful to be able to import existing defined tabular models (as .bim files) into the semantic layer in a way that features which are currently not yet supported could still be developed (in other tools) and integrated and deployed.

Forum|Forum|7 years ago

bas.bruilExplorer

Prerequisite check on setupSUBMITTED

When installing TX on a server without SQL Server installed, you need to install a couple of components to make it work. It would be nice if the msi file for the installation checks for these prerequisites and installs it automatically when needed. These posts describe what needs to be done: https://support.timextender.com/hc/en-us/articles/210437683-Error-Could-not-load-file-or-assembly-Microsoft-SqlServer-DTSRuntimeWrap-https://support.timextender.com/hc/en-us/articles/210437663-Error-Could-not-load-file-or-assembly-Microsoft-SqlServer-ConnectionInfo-https://support.timextender.com/hc/en-us/articles/213530403-Discovery-Hub-Prerequisites

Forum|Forum|7 years ago

peter.jensenTimeXtender Xpert

Guard deploy of other objects (not only tables)SUBMITTED

It would be great if you could guard deployment on all objects (not only tables) e.g. views, stored procedures, ...

Forum|Forum|7 years ago

neil.fitzpatrickVisitor

Duplicating sources/using existing sources as templateSUBMITTED

It would be nice for certain data sources that you need to connect to multiple times, if you could duplicate a source or use an existing source as a template. this would save time and frustration if all you need to change is a json path or an x-path or if you just need to change one small part of the URI to get the appropriate table.

Forum|Forum|7 years ago

rory.smithTimeXtender Xpert

Be able to execute tables inside a semantic modelSUBMITTED

It would be nice to be able to individually execute tables in a semantic model. I.e. process a table in the SSAS Tabular context. I have a small fact table that should be frequently reloaded that is coupled with a large fact tables that are reloaded nightly.

Forum|Forum|7 years ago

rory.smithTimeXtender Xpert

Make table queries respect data type overridesSUBMITTED

Currently, table queries do not respect data type overrides specified on the source. In the table query you can only convert'/cast to types known to the source system, whereas the data type override lets you cast/convert to Microsoft SQL Server types. Please make it so that data type overrides are also applied to the result of table queries.

Forum|Forum|7 years ago

bas.bruilExplorer

CDATA FTP providerSUBMITTED

Could you investigate the option to create additional functionality around the FTP component in CDATA? FTP sources are regularly used in BI solutions to import data as part of the total execution flow. It has no use as a datasource component the way it is now, but when adding it as part of an execution package, it can be of great use! This way, you don't have to create seperate SSIS packages for this and managing all execution in 1 tool is a great plus!

Forum|Forum|7 years ago

WimContributor

Repository CleanupSUBMITTED

Following a case we had with support, I'd like to see an official supported repository cleanup feature which would take care of cleaning tables at risk of orphan rows like dbo.InformationSchema, dbo.DataFields, execution logs etc... Currently we take a backup of the repo and run a script provided by the devs but having something that's officially supported would be great. Doug I count on your upvote ;-).

Forum|Forum|7 years ago

bas.hopstakenTimeXtender Xpert

Add indicator to fields that shows how much fields are mappedSUBMITTED

Add an indicator to fields that shows how much fields are mapped. E.g. I have a Creditor table that maps creditors of 8 sources. Every field in the table needs a mapping to all sources. I use Smart synchronize to do that. But sometimes when I have a typo in the field name, the field is not mapped. Now I need to open all mappings on the field to check if all fields are mapped. Or I need to check the Data movement window. It would be much easier if I see the number of mappings from each field. E.g. CreditorSK (bigint) (8)(when 8 fields are mapped)

Forum|Forum|7 years ago

Thomas LindCommunity Manager

Project Variables available when using snippetSUBMITTED

If you see in the image below i have a sql snippets. It would be nice if the project variables also was available.

Forum|Forum|7 years ago

bas.hopstakenTimeXtender Xpert

Add Pre- and Post scripts Semantic Layer Qlik EndpointSUBMITTED

Just installed the newest release 18.10.1 and noticed the Qlik tab is gone. All functionalities of the Qlik tab would be moved to the semantic tab I heard. But I am still missing a feature for Qlik Endpoints in the Semantic model. It is not possible to add Pro- or Post scripts to a Qlik Model in the semantic layer. Please move this function also to the Semantic tab.

Forum|Forum|7 years ago

lennaert.vd.brinkStarter

Filter Qlik tables with where ExistsSUBMITTED

I regularly have cases where I want my Qlik model to include only a subset of my data. Let's say I have a table dim_product containing all the product dimension information. I want to make an app about specifically products of a certain product group A. In TimeXtender I can use the filter option to only load the products where productgroup = A. Next step I want to load all sales transactions for that product group. In Qlik Sense script I would then write something like this: LOAD * FROM Transactions WHERE EXISTS(ProductID) And the transaction table will contain only transaction rows matching the product IDs where the product group equals A. Sadly TimeXtender lacks this feature, forcing me to either bring in the productgroup to the fact table as well or writing custom Qlik Script where I first load the entire table and then do a resident load.

Forum|Forum|7 years ago

WimContributor

Additional filters in Data Source window: schemaSUBMITTED

In the datasource window it would be handy to filter on selected schema's. We have a source with 18 (!) different schema's but currently we only need 2. So filtering on the schema would be handy.

Forum|Forum|7 years ago

WimContributor

When an error is thrown, put line numbers in view script window and jump to lineSUBMITTED

When debugging deployment errors (e.g. transformation view doesn't deploy because you made a type in a custom transform), display line numbers in the view script window and jump to the offending line. Now I have to copy the script in Notepad++ and go to the offending line manually. Makes debugging less cumbersome :).

Forum|Forum|7 years ago

mjoVisitor

Mark modified tables dirty when transfering to another environementSUBMITTED

In a multiple environment setup with for example DEV, TEST and PROD it would be optimal to have tables marked dirty when transfering to another environment to see all the changes compared to the original one. Furthermore it opens up the possible to only deploy and execute dirty tables. A comparison of the original project and the modified project should visualize the differences as dirty. Br. Michael

Forum|Forum|7 years ago

rory.smithTimeXtender Xpert

Be able to show types of fields in Custom Script windowsSUBMITTED

Whenever I write Custom transformations / inserts / stored procedures / etc. I miss being able to see the types of the fields I can drag in from the right. I find myself frequently going back to the main tree (where I can see the types by setting the option from View menu). Could setting Data Types in the View menu also make them available in other places?

Forum|Forum|7 years ago

WimContributor

Execute a single data sourceSUBMITTED

Sometimes it's handy to be able to execute an entire data source only, for example when adding a new source that is Excel or Text files and you have uploaded a new version of the excel file(s). A right click option on a data source to execute it would be handy. And an option to do this on an "additional connection" as well.

Forum|Forum|7 years ago

Filter by idea status

Filter by product