TM1 Turbo Integrator Variabls
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
TM1 Turbo Integrator Variabls
Can anyone clarify with me what the TM1 TI variables are since I never got to encounter this in the training. Since I don't seem them being automatically generated by the TI. So I assume that this are commands manually written? Do they work the same way as the TI Function. Any feedback on this would be a great help on understand what and how they are used
- Attachments
-
- TM1 TI Variables.JPG (123.38 KiB) Viewed 2551 times
-
- Site Admin
- Posts: 6645
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TM1 Turbo Integrator Variabls
Create a new process.appleglaze28 wrote:Can anyone clarify with me what the TM1 TI variables are since I never got to encounter this in the training. Since I don't seem them being automatically generated by the TI. So I assume that this are commands manually written? Do they work the same way as the TI Function. Any feedback on this would be a great help on understand what and how they are used
Now look on the Data Source tab. Cycle through the various types of data source; ODBC, Text, TM1 Cube View, etcetera.
See all of the text boxes, radio buttons, check boxes, etcetera on the Data Source tab?
The TI Process variables allow you to change those values dynamically; that is, when the process is run.
Put another way, you can assign values to the variables in the Prolog tab to dynamically change or modify the data source before its processed. For example, if you process a text file which has a different name every day, and the name is based on the current date, you could change the DataSourceNameForServer variable to set the source filename to the one that relates to that day.
Some of the process variables (like Value_Is_String) apply to each row of the data rather than to the data source, but reading up on how those work is left as an exercise for the viewer.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.