The Data Source tab is where you define the source used by the TI process.
Available Data Sources #
In Planning Analytics SaaS, several different objects can be used as a data source, including:
- Cube
- Dimension
- File
- JSON File
- Location
- Database Connection (ODBC)
After selecting a data source, you can define variables for it.
For example, if you select File, the TI process reads the columns within the file and allows you to map each column to a variable. These variables can then be used within the Metadata and Data sections of the script.
TI supports CSV and text file formats.
Example: Using a CSV File #
In this example, the file Personel.Measure.csv is used as the data source.
The delimiter is set to Comma.
Because the data starts on row 2 and row 1 contains headers, the Header Records setting is configured as 1. This allows the process to begin reading data from row 2 onwards.
Each column is then assigned a variable name and set to the type String.
The variables can then be referenced within the Data section of the script.
Final thought #
Setting up a clear and reliable data source is an important part of building effective Turbo Integrator processes. Taking the time to structure variables and source files properly can make processes easier to maintain, and reuse in the future. If you need help improving your Planning Analytics models or TI processes, talk to us, we are always happy to help.
