Knowledge Base
Here, we have collected frequently asked questions and guides to using TimeXtender products. Remember that you can find the TimeXtender User Guide in the Download section.
Azure Deployments
- Add an Azure SQL Single Database ★
- Add an Azure Synapse SQL Pool (SQL Data Warehouse) ★
- Add an Azure Data Lake Storage ★
- Configure TimeXtender with Azure Analysis Services
- 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 Azure Data Factory Data Sources to ODX Server ★
- Add a CData data source
- Connect to a REST API
- 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
- Adding geometry data from Oracle
- Creating Dynamic Data Selection Rules using Project Variables
- 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
- 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.5.x
- 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