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.
Azure Deployments
- Add an Azure SQL Single Database ★
- Add an Azure Synapse SQL Pool (SQL Data Warehouse) ★
- Configure TimeXtender with Azure Analysis Services
- Add Azure Data Lake Storage
- What is Azure Synapse Analytics?
- What Azure SQL Database Service Tier and Performance Level Should I Use?
Administration and Settings
- Enable Remote Connections to SQL Server using IP address
- List of websites and ports used for TimeXtender
- How Dynamic Ports are used during Multi-Environment transfer
- How to open a previous version of a project
- How do I move a project from one server to another?
- Which bit version of TimeXtender should I download?
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
- Execution Details SQL Query ★
- Creating Dynamic Data Selection Rules using Project Variables ★
- 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 TimeXtender with SQL Server Integration Services (SSIS)
- SSIS vs ADO.Net
- Use parameters in your scripts, views and calculations
Semantic Models
- Dynamic Security in semantic model setup
- Connect to Qlik Sense Enterprise
- OLAP Security in TimeXtender 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)
- How to create measure folders and sub-folders
Data Validation, Quality, and Profiling
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."
Release Notes
- Release Notes for TimeXtender 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