Skip to main content
To homepage To homepage

    Filter by idea status

    Filter by product

    859 Ideas

    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Generate end-to-end documentationSUBMITTED

    In 20.10.x you can generate documentation at the project scope which normally would encompass your entire implementation. In the TDI, this is no longer possible as documentation is generated separately for each instance.If your implementation is large, generating total documentation will not only take long (it can take quite some time to process the data into pdf) but require a lot of manual clicks.I would like to suggest a similar approach to end-to-end execution package creation: end-to-end documentation. I imagine right-clicking a Deliver instance and then generating a pdf that contains all Ingest + Prepare objects mapping into the Deliver instance + the Deliver instance itself.One of the reasons for requiring this is that customers are required to show documentation for their reporting for the CSRD regulation. Collating this manually from what could be a large number of instances is a lot of manual work that is error-prone.Additionally this same kind of approach should be possible for Perspectives (see:  ) and the documentation should also be available in the portal with a new user-access type to allow auditors to only see the documentation (see: )

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Notify contact persons of upcoming maintenanceSUBMITTED

    With the 6814.1 release a new item was announced:A banner on the Home page will now let you know about upcoming system maintenance.I have a question and a suggestion:question: which Home page is meant? The Portal or the Support homepage? suggestion: could the notification also be sent by e-mail to the contact person in the Portal? That way there is less chance of maintenance being missed and causing confusion.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Do not show active security tables from Deliver Instances in Prepare database cleanup toolSUBMITTED

    If you run the Database Cleanup Wizard you see all physical objects in the database that are not linked to active objects in the Prepare instance. Any “foreign” objects are also listed. This currently includes security tables generated in the database by Deliver instances with security applied.As these security tables are required and active parts of the implementation (just not belonging directly to the Prepare instance), they should not be listed here. This makes it much easier to avoid accidentally deleting physical tables that are still required.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    anders.e.jonsson
    Contributor
    anders.e.jonssonContributor

    Find version number of source instance after migrationSUBMITTED

    Hello,When migrating metadata from one instance to another. For example, from Prepare Dev to Prepare Test. Then it is a certain version of in the Dev instance that will be migrated. Is it possible to see retrospectively which version it was that you migrated from.You can write down the number of the version from the source instance in a version note at the same time as deploying for the first time in the instance you migrated to. But if you haven't done it. How do you find out which version it was?It would have been an advantage if that information was automatically included in the version notes of the destination instance.Another question in the same category. How to see the version notes without closing the instance and then right click on the instance and select Open Version..?You might want to be able to see the notes while working in an instance.BRAnders

    1
    Christian Hauggaard
    Forum|Forum|1 year ago
    T
    Visitor
    trond-eirik.kolloenVisitor

    Azure Key vault as source for login informationSUBMITTED

    About Azure key vault: https://docs.microsoft.com/en-us/azure/key-vault/basic-concepts We - as well as many other - add signin information (either just username and password, or whole connection strings) to Azure key vault. Example user scenario: You have a script that need to connect to a database and fetch some data. As you are concerned with security you do not want username and password to be written in the script. Instead you use a secret, stored in key vault, to get a connection string that the script can use. You, as a user with access to keyvault, run the script. The script connects to keyvault and fetches the connection string and uses it to connect to the database. No password or username is floating around. If the username or password changes, the connection string is updated in the keyvault and everything continues to work. For Discovery Hub the scenario is mutch the same - so Discovery Hub should just store the reference to the keyvault and get the password (or the whole connection string) from the keyvault. If the username or password changes - it is updated in the keyvault - and Discovery Hub will continue to work - as it get's the username/password from the key vault. This would free us from needing to update username and password in Discovery Hub when needs to rotate or by other means change the passwords.   Best regards, Trond-Eirik

    13
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    erik.van.mastrigt
    TimeXtender Xpert
    erik.van.mastrigtTimeXtender Xpert

    Add Fabric Lakehouse Ingest compatibility for SAP Table Data SourceSUBMITTED

    Currently Fabric Lakehouse Ingest is not compatible with TimeXtender SAP Table Data Source.Please add compatibility :)

    0
    erik.van.mastrigt
    TimeXtender Xpert
    Forum|Forum|1 year ago
    D
    Participant
    david.zebrowitzParticipant

    Multi-Select capabilitiesSUBMITTED

    TX is awesome for removing a lot of the tedious work involved with traditional ETL, but there are still some things it can improve upon.... for instance, multi-select of fields in various cases would help speed up development a great deal. The following are a couple of enhancements I'd like to see: 1.) If I add a bunch of Surrogate Key lookups to a table, they all end up at the bottom.  I prefer that all the Keys are at the top of the table, so I then have to drag each one up individually.  A multi-select capability for re-ordering would be incredibly useful     2.) Multiselect tables added to the Business Unit or Data Warehouse and drag them to reorder all at once.  This would make things much easier with a project that has many tables! 3.) Multi-select fields in table #1 and drag into table #2 to create multiple lookups at once.  This one isn't as big of a deal, but would help save clicks.   I think there are probably more places where multi-select makes a lot of sense.  I'll add more to this post as I come across them.

    21
    K
    Contributor
    Forum|Forum|1 year ago
    K
    Contributor
    KCMTContributor

    Exclude Excluded tables in Execution Package steps from auto Generated ODX Transfer TasksSUBMITTED

    AS-ISCurrently when you exclude DSA steps/tables when adding or editing an Execution Package, these tables are not excluded when Auto generating an ODX transfer task. In the Example below, I don’t want the tables OJDT, JDT1 etc. in the auto generated ODX tasks.Auto generated ODX task, which still includes the excluded steps in the packageTo BeExclude the excluded DSA tables from the auto generated ODX transfer task

    0
    K
    Contributor
    Forum|Forum|1 year ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Run custom scripts like execution taskSUBMITTED

    I have some stored procedures that I would like to run independently, it would be nice to be able to run them as Execution packages.

    2
    rvgfox
    Problem Solver
    Forum|Forum|1 year ago
    Stefán Gunnar Jóhannsson
    TimeXtender Xpert
    Stefán Gunnar JóhannssonTimeXtender Xpert

    Different UI color for different EnvironmentsSUBMITTED

    Maybe this is possible, I know it was in the old version. It would be nice to be able to set different colors for DEV and PROD environments when developing

    2
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    T
    Participant
    thzmanParticipant

    Possibility to change parameter order in Custom View editorSUBMITTED

    Hi,To keep order and maintain a good overview we try as far as possible to “group” the tables and the columns that we use in the list of parameters in the Custom View editor. Unfortunately, as soon as we need to add another parameter it always ends up at the end and there is no way to keep the “grouping” other than to remove all the parameters and add them again in the desired order. If there was a possibility to drag-and-drop or arrow buttons to be able to move the parameters up and down in the list, that would make things a lot simpler.  

    0
    T
    Participant
    Forum|Forum|1 year ago
    A
    Starter
    a.chikhiStarter

    Merge functionality in Migration Tool or PortalSUBMITTED

    For the migration of a project from v20 to v21 we used the migration tool. When using the migration tool it was indicated that an empty instance had to be available to be able to migrate the project.It would be nice if we could merge this temporary instance with an existing one. When using the migration option within the portal the data warehouse is copied from one instance to the other and the existing data areas in the existing instance disappear.It would be nice if there was an easy way in the migration tool, portal or both to merge instances without having to manually redevelop the existing data areas/warehouses.

    0
    A
    Starter
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Add security features to REST EndpointsSUBMITTED

    It is possible to create REST Endpoints for Deliver instances in TimeXtender. This is a really nice feature that makes it possible to share data in- and externally using API calls instead of directly to a database.The current implementation is backed by an IIS instance that uses a machine identity to authenticate to the database backing your Prepare instance. The main drawback of this is that there is one static login/user connecting to your datawarehouse, there are no options for more finegrained security than applying a token or oauth to the endpoint.In my experience many customers would consider using REST to deliver data to third parties. The third parties could be customers or partners that consume parts of a larger dataset. Naturally, this leads to needing to apply table/field or row-level security to filter down the data that can be accessed by a specific token/login.It would be a great addition if a single Deliver instance can be secured such that Power BI, Qlik, Tableau, REST endpoints can enjoy the same security possiblities. Apart from passing through Windows AD / Entra ID / user:pass (SQL Auth), the REST endpoint would need to be able to map database users to tokens / app registrations.The current workaround would be to create a separate Deliver instance for each data / security combination that must be delivered. This will quickly lead to an unmanageable amount of Deliver instances, or for customers to look for other solutions.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    D
    Participant
    david.zebrowitzParticipant

    Semantic Model Shared Roles - SSAS TabularSUBMITTED

    Microsoft implemented security in a different fashion with SSAS Tabular when compared with Multi-Dimensional.  With multi-dimensional we had the database concept with multiple cubes... but a security role could be defined and used across all of the cubes in the database. Tabular is a bit frustrating in that we have to create a role and define role membership for each model.  But this could be TimeXtender's time to shine!! :) I'd like to propose the ability to create a shared security role for the Semantic Models.  A role could be defined with membership applied, and that role can then be linked to the models where security can be further defined.  Essentially, the shared role would provide a centralized membership list rather than having to recreate it for each model. We have 7 models which are typically deployed and it can be a bit of a hassle to maintain membership lists in 3 environments for each role in each model. Yes, we can do this with AD Groups... most of the time.  That capability doesn't really work with Azure Analysis Services, so it becomes very painful there. 

    2
    K
    Contributor
    Forum|Forum|1 year ago
    T
    Participant
    thzmanParticipant

    Make Table Flattening Configurations an expandable section in the portalSUBMITTED

    Hi,Not an issue but more of an annoyance really. :)When you have an endpoint with many columns in the table flattening it becomes a very loooong list to scroll through to get to the Dynamic Values Configuration and Overridden Pagination Configuration at the end of the page. Like in our case we have an expanded ODATA connection which results in a total of 297 columns for one endpoint. If you enter Edit mode everything is nice and compact, but if you only want to take a quick peek of the settings it feels a bit annoying to have to scroll through all of that. A simple option to be able to expand or collapse that section would make things a bit smoother.  

    0
    T
    Participant
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Please change the name of Migrations back to Environments in the PortalSUBMITTED

    The recent Portal update has moved some functionality around and renamed the place where you perform Environment Transfers to Migrations. Given that what you do there is an Environment Transfer and has nothing to do with Migrations and that there are actual migrations between release 20.10.x and 6xxxx, I would really like this page to be renamed: Environments or Environment Transfer.I can understand that from a technical back-end person's point of view you are copying data from one cloud repository to another which could be seen as a migration of some sort. But for the other 99.999999% of the world, this is confusing.

    1
    devin.tiemens
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rvgfox
    Problem Solver
    rvgfoxProblem Solver

    Sort fields alphabeticSUBMITTED

    If a table in DSA or MDW has a lot of fields it would be nice to view it sorted alphabetic

    5
    K
    Contributor
    Forum|Forum|1 year ago
    sierd.zuiderveld
    Contributor
    sierd.zuiderveldContributor

    Option to Truncate History TableSUBMITTED

    Hi,  During development it would be nice to have the option to fully truncate a History table, currently I believe the only option is to truncate directly on the SQL database?

    1
    K
    Contributor
    Forum|Forum|1 year ago
    J
    Starter
    j.burgstallerStarter

    Option to select all tables of a schema for a perspectiveSUBMITTED

    If you have different Schemas with many tables in the Data Warehouse it would be very convenient if you can select all tables and views of one schema with just one checkbox and not to have to select every single table to have it in the perspective.

    0
    J
    Starter
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Add Job / Execution package / Task field to all relevant logging dialoguesSUBMITTED

    When checking the status of runs in TimeXtender you need to jump around between different dialogues to get to the bottom of an issue. The UX is rather lacking at the moment and could benefit from some quality-of-life improvements: please add the following fields/columns to logging dialogues across the products:Orchestration package:Orchestration package triggering a Job Job calling an Ingest Task or Package that sets a status Ingest Task or Execution Package triggering a status In case of a task, the Data Source the Task belongs to In case of an Execution Package: the instance (and Data Area) the package belongs to This would make it much easier to narrow down where to look in TDI after checking the logging from the Orchestration side, whether using Exmon DG client or browser or coming from a notification sent by Orchestration.Job:Orchestration package triggering a Job Job calling an Ingest Task or Package Ingest Task or Execution Package triggering a status In case of a task, the Data Source the Task belongs to In case of an Execution Package: the instance (and Data Area) the package belongs to Directly seeing the Task or Package setting a status, makes it much faster to jump to the place where action is required versus needing to read through a load of text to discover where to start looking will save a lot of time. Being able to click any of the fields and have the object open in the interface would really improve this. There are also some issues with the Job log dialogue itself:the dialogue is blocking, making it extra annoying to diagnose issues the error messages are cryptic: Ingest Instance <instance name>: The task <task name> CompletedWithErrors execution. It seems like there is an Enum name being passed directly instead of a descriptive stringExecution package:Orchestration package triggering a Job Job calling an Ingest Task or Package Ingest Task or Execution Package In case of a task, the Data Source the Task belongs to In case of an Execution Package: the instance (and Data Area) the package belongs to Steps within the Ingest Task or Execution PackageSimilarly to Job logging, being able to click a field and jump to the object would much improve the user's experience. As this dialogue is not blocking it is not as disruptive as the Job logging dialogue

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    rory.smith
    TimeXtender Xpert
    rory.smithTimeXtender Xpert

    Widen Ingest Execution log dialogue to show important informationSUBMITTED

    The current Execution Log dialogue in Ingest is frustrating to use. The default display width and filling of the columns means you are required to widen the window to see if tasks failed or succeeded: “Completed” may look like a positive result when the opposite is true:Please change this dialogue so that all important information is visible without needing to reshape the window and columns. While this is an Idea for a specific dialogue, there are other examples spread throughout the tooling that should not require individual Ideas to tackle.

    0
    rory.smith
    TimeXtender Xpert
    Forum|Forum|1 year ago
    K
    Contributor
    KCMTContributor

    Option for Upgrade All for SQL snippets upgradeSUBMITTED

    I’m using SQL snippets to replicate certain custom column measures across all Row Tables. However, upgrade these snippets one by one after altering them is really time consuming.I found the idea already and it shows as implemented on here but I don’t think it is? Checkboxes with "select all" option for SQL snippets upgrade | Community (timextender.com)  

    0
    K
    Contributor
    Forum|Forum|1 year ago
    J
    Starter
    j.burgstallerStarter

    Possibility to order tables in the MDW alphabeticallySUBMITTED

    It would be nice to have the option to sort the tables alphabetically in the MDW.

    0
    J
    Starter
    Forum|Forum|1 year ago
    devin.tiemens
    TimeXtender Xpert
    devin.tiemensTimeXtender Xpert

    Ability to use Variables in the PortalSUBMITTED

    Hi, It would be highly beneficial to have the ability to use variables in the TimeXtender Portal. I see a lot of potential here, but the most immediate advantage that comes to mind is as a solution for expiring or changing App registrations/client secrets. By creating a variable for the client secret and applying it across all Semantic Layer instances, you could easily update the client secret in a single location when it's about to expire.If anyone has other examples of how variables could be useful in the portal, feel free to share them below!Regards,Devin

    1
    bas.hopstaken
    Forum|Forum|1 year ago
    oscarcleve
    Contributor
    oscarcleveContributor

    Remove all Work Items optionSUBMITTED

    Instead of having to remove Work Items individually, I would like an option to remove all the Work Items at once, for example by pressing a button in the window below.  

    0
    oscarcleve
    Contributor
    Forum|Forum|1 year 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