Product ideas

863 Ideas

Enable 3-state checkboxes on Data Source Explorer (ODX)SUBMITTED

Hi, in the new ODX Server (20.10) there is the new Data Source Explorer.It would be nice if I could search for missing (not enabled) options (e.g. show all tables without primary key).This can be done by having 3-state checkboxes instead of 2-state (where the 'not checked' currently means you don't want to make a selection for this option. I think it should be like this : - checked : search for objects with this option enabled - unchecked : search for objects with this option disabled (or not implemented - e.g. no primary key defined) - 3rd state : no selection on this option BR, Peter

Forum|Forum|3 years ago

rvgfoxProblem Solver

Export the results of query toolSUBMITTED

It would be useful to be able to export the results of query tool to excel or CSV files

Forum|Forum|3 years ago

anders.e.jonssonContributor

Other increments of time ahead than days when creating a date tableSUBMITTED

It would be useful if it was possible to add Years or months ahead when creating a date table. Years ahead is particularly useful when working with financial data. Days ahead will always produce a number of days into a superfluous year.

Forum|Forum|3 years ago

rvgfoxProblem Solver

Setup Concurrent execution threads in ODX Transfer TasksSUBMITTED

Now this setting it’s configured at data source level.It’s necessary that it be configurate at transfer task level.

Forum|Forum|3 years ago

rvgfoxProblem Solver

Adding a Notification for an Execution Package in html configurable formatSUBMITTED

To send the notifications it would be useful to use a html template with substitution variables.

Forum|Forum|3 years ago

rvgfoxProblem Solver

Folders and alias for tablesSUBMITTED

It would be very useful to assign aliases to the tables to see it in the tablet’s tree.Some time it’s names are very cryptic (MARA, KNA1, KNVV,…)It would be useful too, sort it in folders.

Forum|Forum|3 years ago

rory.smithTimeXtender Xpert

Make it clear whether a table set to "Automatic" extraction is actually incrementalSUBMITTED

ContextWhen starting on a new TimeXtender implementation, you are usually making a lot of transformations and changes to tables. If you are new to TimeXtender, or coming from a 20.10.x deployment, you may not realise that all tables pulled from ODX (in ADLS) to DWH instance will automatically be incremental. This means that after an initial Deploy & Execution any subsequent changes will not materialise unless you force a Full Reload of the table.In a running implementation, where you are changing less at the same time (usually) this is slightly less annoying. It is still needlessly confusing in my opinion. ChallengeNew users and users that are used to the “old way” may not realise that the Automatic setting for Data Extraction on a table means that they will be incremental. The fact that this is the case is only visible if you expand mappings and notice the I on the mapping icon. This can result in surprises: either nulls for new fields for existing data, or old values for modified transformations. This means that you really need to cover this in a training context before you start any deploy and execution actions, substantially frontloading complexity.If a table has multiple mappings, some of which may not be incremental, it becomes even more confusing. Current solution / work-aroundCurrently you either need to change the Data Extraction setting of tables to Full from the default Automatic, or do a “Review Tasks” followed by selecting the full load steps required (I am not certain whether always selecting all options for a table is always safe, you may need to specifically select the required steps). If you are doing a more complex change where you want to Deploy and Execute multiple objects, this becomes tedious Proposed solutionMake it explicit when Automatic makes a table incremental by giving a visual cue. There are probably three states:Full load (none of the mappings are incremental) Incremental (all of the mappings are incremental) Mixed (at least one of the mappings is incremental)I'm sure someone can come up with nice pixel-art to make clear icons.In addition it would be good if an optional warning can be added / extra options can be added when performing a Deploy & Execute after a change. Something like “This table has incremental mappings, not all records may reflect changes” and an extra checkbox in the Deploy & Execute menu “Perform full load”. This should be an option in the TimeXtender settings so that people who are used to walking uphill to school in a snowstorm can do things the hard way.

Forum|Forum|3 years ago

jan.de.boerExplorer

History - [SCD Is Tombstone] - Option Push data last active record into Tombstone recordSUBMITTED

Could another option be created for deletion in History tables. Either the option to push all the data from the lastest active record into the tomstone record or a field [SCD Last Active Record] that acts like an indicator that this record was the last active record before the deletion. This way the last active record is easily selectable. In some of our sources we don't have a reliable enough date we can use to match with dimensions to find the correct surrogate key. We therefore want to display the latest active record of a dimension.

Forum|Forum|3 years ago

bas.hopstakenTimeXtender Xpert

Add execution logs on semantic modelsSUBMITTED

Add execution logs on semantic models. This way we can see the Execution Overview Log and we can easily check how much time it takes to execute the model and the rowcount of the tables.

Forum|Forum|3 years ago

wynkoopContributor

"Twilight" modeSUBMITTED

Hi there, First of all, I'm getting rave reviews from our client about the new 19.6 interface! Well done! They had a couple of thoughts on the UI, which I'm turning into requests on their behalf. The first request they had is for a "twilight" mode. Right now, there's a dark mode and a light mode, but they're finding the light mode brighter than they'd like, and the dark mode darker than they'd prefer. Also, the window backgrounds are still pure white, even in the dark mode! This makes it not actually all that dark. They've suggested a color palette similar to the default palette in Power Bi for the modelling mode - cool grays, kinda like this: I think that would be a nice touch, and be much easier on the eyes than the current options, especially if you're sitting in front of Discovery Hub all day long.

Forum|Forum|3 years ago

jens.mikkelsenContributor

Clean up of old projects versionsSUBMITTED

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

Forum|Forum|3 years ago

andriContributor

Option to hide a measure in the semantic modelSUBMITTED

Currently, it is not possible to hide a measure in the semantic model (SSAS). It's especially useful when creating a custom measure that references another measure that you don't want to be visible .

Forum|Forum|3 years ago

sigurdur.jonssonStarter

Data profiling capabilitiesIMPLEMENTED

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

Forum|Forum|3 years ago

bpeekStarter

Add Power Bi Datasets to Symantic Models that can be managed in the Semantic LayerIMPLEMENTED

As we move away from SSAS models towards Power BI datasets it would be great to manage the latter in TX just like we do with Tabular/Multidimensional models.

Forum|Forum|3 years ago

peter.jensenTimeXtender Xpert

Logging during Cleansing Stored ProcedureSUBMITTED

It would be a great help to have logging of all steps of the cleansing stored procedure (start / end time). We have tables with a lot of lookups, but sometimes some of those lookups take a lot of time. This logging would help us to identify the slow lookups and do something about it.

Forum|Forum|3 years ago

d.stamVisitor

Include cData sources in documentationSUBMITTED

The datasource of data extracted with Cdata "ADO.NET Provider for Excel Services 2020 (20.0.7654.0)" connector is not included in the generated Project Documentation. Only the name of the datasource is included but not the actual filename.For Data Linage the data must be tracked to the actual source, the SharePoint Excel file.

Forum|Forum|4 years ago

benjamin.gnaedigVisitor

SAP Connector XTRACT IS DELTAQ (Theobald)SUBMITTED

Hello TimeXtender Team, we have a lot of queries regarding the connection with the Theobald IS DELTAQ functionality, this is a much needed feature on DiscoveryHub! Unfortunately the way through SSDT is often a rather daunting option.Is there already a plan to implement this or all Theobald IS functions in the DiscoveryHub? Regards

Forum|Forum|4 years ago

jnortonStarter

Configuration of Scheduler ServiceSUBMITTED

I have done multiple Discovery Hub Installations at a number of clients and there is always one particular item that the client gets hung up on. Configuring the Discovery Hub Scheduler Service. Currently one has to use the TXService account and log onto the Application/Discovery Hub Server using this account and connect Discovery Hub to the project repository, which allows Discovery Hub to create the encrypted connection file under the TXService account's user folder. Many Clients do not allow developer access to the TXService account and it is against best practices to use a service account for development. So often times the client configures the connection to the projectrepository using their developer account and the issue of the Discovery Hub Scheduler Service's failure to start is prevalent across lots of installations. My request is that Discovery hub eliminates the need to explicitly log into the TXService account on the box and connect to the repository using the tool. It would be great if a developer account could manage/configure this connection via the Discovery Hub tool, but utilizing any developer account. They would merely have a configuration tab for the Service account in which TimeXtender could then generate its encrypted connection file in the correct folder structure.

Forum|Forum|4 years ago

mrygStarter

Drag and drop sorting in Execution Package + more spaceSUBMITTED

Timextender rearrange include steps in Execution Package1) yes i know you can hold [Alt] and use Arrowkeys up and downbut really drag and drop should be possible Also make the "all Steps" "include Steps" and "Exclude Steps" 3 separate columns and the click options at the bottom - make it better1) post execution first2) during Execution middle3) after exe lastlike we use it ...

Forum|Forum|4 years ago

Steffen DavidsenStarter

Drag and drop sorting in Execution PackageSUBMITTED

It would be much easier to order the steps in the execution package, if we were able to drag and drop the objects around.

Forum|Forum|4 years ago

roland.peetersExplorer

Transfer (Multi-Environment) just one Project PerspectiveSUBMITTED

Is it possible in the Multi-Environment to transfer just one Project Perspective. This could be really usefull when you are developing with multiple persons one project. Not all Project Perspective are at the same time ready to transfer from development/test to a production server

Forum|Forum|4 years ago

emily.wynkoopContributor

Environment Specific Email NotificationsSUBMITTED

It would be really nice if we could make the email notification an execution package uses dependent on environment. Right now, if you want to vary say, the recipients of a success or failure message based on environment, you must create a separate version of each package for every environment you have. If this was combined with Ulfar's suggestion here, then the entire execution package concept would be hugely streamlined. As it is, it's not unusual to need at least one execution package per environment per business area, often leading to having to create and maintain dozens of mostly redundant execution packages. I think implementing these two solutions would be a huge "quality of life" improvement for the tool.

Forum|Forum|4 years ago

tarek.demiatiStarter

DAX Business Functions Library + ParametrizationsSUBMITTED

Just like we have Business Functions for the unfamous "Mind Destroying Expressions" (MDX) ;-) https://support.timextender.com/hc/en-us/articles/210439443-Business-Function-Library It will be pretty cool to offer the same library parametrization support for DAX that's available for MDX on the OLAP MD semantic model.

Forum|Forum|5 years ago

keith.williamsVisitor

Pass underlying table DW_SourceCode thru ViewIMPLEMENTED

I loaded some records from a view which obviously is built off of a table. When I looked at the records in the destination table, the DW_SourceCode field had the value 'View'. I was expecting the underlying DW_SourceCode field from the source table. Response from TX: The current behavior of custom views is to simply populate the destination table DW_SourceCode with the value "View." Unfortunately, you can't map any field onto DW_SourceCode in the destination table, but you can add it as an additional custom field. This feature would be nice for tracking and being able to query the underlying source dataset.

Forum|Forum|5 years ago

david.zebrowitzParticipant

Expand Post Execution Failure OptionsSUBMITTED

There currently is not any built-in functionality to execute a process on failure of an execution package. In fact, one of our clients has had to build an external process to watch the log table in the repository database to look for a failure and then execute other processes. I think a simple solution to this would be to allow for Running a Package upon Failure. That execution package could execute stored procs, outside SSIS packages, etc which would allow for various types of interaction, including sending short SMS Text Messages of a failure, creating a trouble ticket in an IT Management System, etc.

Forum|Forum|5 years ago

Filter by idea status

Filter by product