Knowledge Base
Here, we have collected frequently asked questions and guides to using TimeXtender products. Remember that you can find the Discovery Hub User Guide in the Download section.
Release Notes
- Release Notes for Discovery Hub 20.1.x
- Release Notes for Discovery Hub 19.11.x
- Release Notes for Discovery Hub 19.9.x
- Release Notes for Discovery Hub 19.6.x
- Release Notes for Discovery Hub 19.2.x
- Release Notes for Discovery Hub 18.10.x
Administration and Settings
- List of websites and ports used for Discovery Hub
- How to open a previous version of a project
- How do I move a project from one server to another?
- Which bit version of Discovery Hub should I download?
- How to change the repository settings
- Can I Safely Create Tables in a Discovery Hub Database?
Connecting to Data
- Add a Built-in Data Source: additional resources in the User Guide
- Add a CData data source
- Connect to a REST api with a CData data source
- Connect to Azure SQL and Transfer Data with Azure Data Factory
- Connect to CSV with CData
- Connect to Dynamics CRM 2016 using TimeXtender Custom Components
Design, Modeling, and Transformations
- How to create a dynamic project variable
- How to use the Add Related Records feature
- How to build a Parent-Child dimension
- How to create secured views and securable columns
- How to keep track of historic data
- Custom conditions on Conditional Lookup fields
Deployment, Execution & Scheduling
- Creating Dynamic Data Selection Rules using Project Variables ★
- Execution Details SQL Query
- Adding geometry data from Oracle
- How to configure segmented table executions (Chunking)
- Improve execution times by splitting exchange rates out on dates
- Scheduled Execution issues. Did it not start, did it fail or is my execution still running
Incremental Loading
- How to configure Table Partitioning
- Create an incremental view
- How incremental loading works
- How to set up Source Based Incremental Load
- How To Configure Incremental Load of Multidimensional Cubes
- Understanding deployment strategy for incremental tables
SSIS, Stored Procedures, Scripts & Functions
- Configure Remote Execution of SSIS Packages
- How to use a Stored Procedure
- How to use a User Defined Function
- Using Discovery Hub with SQL Server Integration Services (SSIS)
- SSIS vs ADO.Net
- Use parameters in your scripts, views and calculations
Semantic Models, Endpoints & SSAS/OLAP Cubes
- Dynamic Security in semantic model setup
- Connect to Qlik Sense Enterprise
- How to add a Azure Analysis services tabular model
- OLAP Security in TX DWA
- How to do a test deployment of a single cube using Offline Cube Processing (video)
- How to modify a dimension or cube using XPATH (examples included)
Data Validation, Quality, and Profiling
Azure Deployments
- What Azure SQL Database Service Tier and Performance Level Should I Use? ★
- What is Azure Synapse Analytics?
- Set up a Azure SQL Database project
- Add Azure Analysis Services to an existing Azure Discovery Hub Deployment
- Add Azure Data Lake Storage to an existing Discovery Hub Deployment
- Migrate Your Discovery Hub Environment to Azure
Troubleshooting
- Data missing or incorrect on scheduled execution with no errors
- Error Connecting to Navision Native Databases on 64-bit Windows
- Error in command: Could not load file or assembly Oracle.DataAccess
- Error while trying to add an environment
- Error: "Access is denied" when deploying SSIS packages or reading objects from data source
- Error: "Cannot set column 'FileName'. The value violates the MaxLenght limit of this column."