TM1 Flash

Question 1

What is TM1 Workflow used for?

Answer 1

Wide deployment
Collaborative decision making
Allows for real-time review

Question 2

What is needed for a TM1 workflow?

Answer 2

Views
Approval hierarchy
Deployment
Security assignments

Question 3

What are the different windows in Turbo-Integrator?

Answer 3

Datasource
Variables
Maps
Advanced
Schedule

Question 4

What are the data sources available with TI?

Answer 4

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

Question 5

How to run Turbo Integrator Process from Command Line?

Answer 5

To initiate the TI process TM1RunTI is a command line interface tool.

Question 6

Define Data Tab?

Answer 6

Series of statements that manipulates values for each record in data source.

Question 7

How does SKIPCHECK help TM1?

Answer 7

SKIPCHECK forces TM1 to use the Sparse Consolidation algorithm in all cases.

Question 8

What are FEEDERS?

Answer 8

It creates a placeholder on cells so that cells will not be skipped during the consolidation

Question 9

Define TM1 package connector?

Answer 9

TM1 package connector helps to import data from packages/dimensions and custom queries.

Question 10

Name the function which is used to serialize the TI process?

Answer 10

Synchronized () function can is used to serialize TI process so they can be processed sequentially.

Question 11

What are the functions required to be called for enabling or disabling the bulk load of mode?

Answer 11

EnableBulkLoad Mode() = Enable
Disable Bulk Load Mode() = Disable.

Question 12

What is the limit of string length in Turbo Integrator?

Answer 12

The limit of string length in Turbo Integrator is 8000 single byte character.

Question 13

Name the different procedures within TI?

Answer 13

Defining Data Source
Setting Variables
Mapping Data
Editing Advanced Scripting
Scheduling the completed Process.

Question 14

Where would you enable Bulk Load Mode in TI?

Answer 14

In Prolog or Epilog section of TI

Question 15

How to Troubleshoot the FEEDERS?

Answer 15

Rules Tracer

Question 16

How does Rules Tracer help?

Answer 16

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.

Question 17

What actually happens when Bulk Load mode starts

Answer 17

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

Question 18

Give the options which are available after importing data using TI?

Answer 18

Create Cube and populate data.
Create and Update dimensions.
Re-create Cube. It destroys the existing cube definitions and overwrites it.

Question 19

Define Prolog tab?

Answer 19

Procedure is executed before the data source for the TI is opened.