TM1 Flash Flashcards
What is TM1 Workflow used for?
Wide deployment
Collaborative decision making
Allows for real-time review
What is needed for a TM1 workflow?
Views
Approval hierarchy
Deployment
Security assignments
What are the different windows in Turbo-Integrator?
Datasource Variables Maps Advanced Schedule
What are the data sources available with TI?
Comma delimited text files including ASCII files
Relational databases using ODBC Connectivity
Other Cubes and Views
Microsoft Analysis Services
SAP via RFC
IBM Cognos Packages
How to run Turbo Integrator Process from Command Line?
To initiate the TI process TM1RunTI is a command line interface tool.
Define Data Tab?
Series of statements that manipulates values for each record in data source.
How does SKIPCHECK help TM1?
SKIPCHECK forces TM1 to use the Sparse Consolidation algorithm in all cases.
What are FEEDERS?
It creates a placeholder on cells so that cells will not be skipped during the consolidation
Define TM1 package connector?
TM1 package connector helps to import data from packages/dimensions and custom queries.
Name the function which is used to serialize the TI process?
Synchronized () function can is used to serialize TI process so they can be processed sequentially.
What are the functions required to be called for enabling or disabling the bulk load of mode?
EnableBulkLoad Mode() = Enable Disable Bulk Load Mode() = Disable.
What is the limit of string length in Turbo Integrator?
The limit of string length in Turbo Integrator is 8000 single byte character.
Name the different procedures within TI?
Defining Data Source Setting Variables Mapping Data Editing Advanced Scripting Scheduling the completed Process.
Where would you enable Bulk Load Mode in TI?
In Prolog or Epilog section of TI
How to Troubleshoot the FEEDERS?
Rules Tracer
How does Rules Tracer help?
It traces FEEDERS, it ensures that selected leaf cells are feeding rules-calculated cells properly
It checks FEEDERS, ensures that the children of selected consolidated cells are fed properly.
What actually happens when Bulk Load mode starts
ll the scheduled chores will be deactivated
All the processing by other threads will be paused
Running chores and any of the existing user threads will be suspended
TM1 Top connections and all the system-specific threads will be suspended
Give the options which are available after importing data using TI?
Create Cube and populate data.
Create and Update dimensions.
Re-create Cube. It destroys the existing cube definitions and overwrites it.
Define Prolog tab?
Procedure is executed before the data source for the TI is opened.
