Cognos TM1 Interview Questions

What is Sparse Cube?

A cube in which number of populated cells as a percentage of total cells is too low

What are the different windows in Turbo Integrator?

There are different tabs available in Turbo Integrator

  • Data source
  • Variable
  • Maps
  • Advanced
  • Schedule

What is the use of advanced window in Turbo Integrator?

Using the Advanced window you can create your own custom scripts.

What is TM1 Workflow. How do you create a process in that?

Workflow is helping for Wide deployment, Collaborative decision making, Continuous and real-time review and refinement and Monitoring of Key Performance Indicators

To create the work.

  • Need to define the Views that you need to deploy to the end users for Decision making.(Its basically Input View)
  • You need to define Approval Hierarchy
  • Need to deploy
  • Security Assignments

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

Where is Portlet used?

Portlets are used in Cognos.

How can you access TM1 web form portlet?

There is a option to integrate TM1 viewers in cognos Portlets.

What are different windows in portlet?

There are 3 type of viewers available in TM1.

  • Cube Viewer
  • Web Sheet Viewer
  • Navigation Viewer.

What are the basic features of Cognos TM1?

  • Real-time, interactive multidimensional database also with write-back functionality.
  • 64-bit, in memory OLAP server capable of concentrate huge volumes of data.
  • Enterprise level planning and analysis capabilities.
  • Guided modeling environment to facilitate planning, analysis and forecasting.
  • Rapid development of flexible models, including profitability models, without batch processing.
  • Integrates with IBM Cognos Business Intelligence, to establish a single view of performance.

How do you use TM1 cubes in Framework Manager?

TM1 v10.1 has the interoperability function configured to allow packages to be published from TM1.

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.

What are sub-tabs in advance tab of TI?

  • Prolog
  • Metadata
  • Data
  • Epilog

What is the logic of Sparsity in cubes?

On average, the more dimensions a cube has, the greater the degree of sparsity.

Inclined to build a profession as Cognos TM1 Developer? Then here is the blog post on

 Cognos TM1 Training.

What is Overfeeding?

Defining feeders for for consolidated cells. (Feeding a consolidated cell automatically feeds all children of the consolidation.)

What is Under Feeding?

Failing to feed cells that contain rules-derived values. This always results in incorrect values and must be avoided at all costs.

How does SKIPCHECK helps 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


  • If rule defines string values for any cells, then FEEDSTRINGS must be inserted as the first line of rule.
  • FEEDSTRINGS declaration ensures that cells containing rules-derived strings are fed.
  • Every calculation statement in a rule should have a corresponding feeder statement.

What are simple FEEDERS?

FEEDERS that are applied to calculation within one dimension of one cube.

Define TM1 package connector?

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

What is Epilog Tab?

Series of statements that is to be executed after the data source is processed.

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. If the length will become more 8000 bytes then it gets truncated.

What are the flaws of Chore Start Time?

TM1 executes chores in GMT standards. It doesn’t have any auto mechanism to accommodate DayLight Saving. Its Chores Scheduled time should be edited when DayLight time begins and ends.

Name the different procedures within TI?

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

How you can enable Bulk Load Mode in TI?

In Prolog or Epilog section of TI, Bulk Load mode can be enabled.

It always recommended that Bulk Load Mode should be enabled in Prolog section.

How we can generate cubes in Cognos?

There are different ways to generate a cube.

Steps to be followed:

  • Just right click on cube name and build.
  • We can write script in UNIX. Using that we can easily generate the cube.

Name the data sources which are available with TI?

Data Sources available with TI are:

  • SAP via RFC
  • IBM Cognos Packages
  • Microsoft Analysis Services
  • Relational databases using ODBC Connectivity
  • Comma delimited text files including ASCII files
  • Other Cubes and Views

Define snapshot?

Snapshot is nothing it’s only a copy of data, whenever we create any snapshot it only copy the exact data that is related to the particular report. It is used to compare reports.

For ex: we want to compare the report of this month with previous month.

Define Bulk Load mode?

  • It enables TM1 to run in a special optimized Single-user mode. This mode has a capacity to maximize the performance for dedicated tasks during the time when there is no load on server or at night time.
  • It doesn’t display a message to end-user to alert them. No new connections can be created.

How is the FEEDER Statement written when feeding one cube from another?

  • Calculation statement resides in the target cube, but the FEEDER statement should reside in the source cube.
  • The Feeder is basically the inverse of the calculation statement in the Target Cube that requires the feeder.

How to Troubleshoot the FEEDERS?

  • Use Rules Tracer to assist in the development and debugging of rules.
  • Rules Tracer functionality is available in Cube Viewer

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. Check Feeders options is available from consolidated cells and its not available from leaf node

What actually happens when Bulk Load mode starts?

  • All 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

Define Drill Through?

By using Drill-through reporting you can link from one report to another.

There are number of ways to Drill Through:

Drill Through is developed with two reports

  • Parent Report
  • Child Report

What is the difference between list and crosstab?


  • List report show the data in row and column(detail information of report).
  • List can be converted to Crosstab


  • Crosstab report show the data in grids, dimensions in row and column and measures in cells or in intersection point.
  • Crosstab can’t be converted to list. There is no direct option available in Report Studio to convert the cross tab to list.

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. TI directly goes to Epilog if the data source for the process is none and if there is no data source then Metadata and data tabs are ignored.

What is the cube size?

2.0 GB. It depends as per your project requirements.

What kind of system requirement is needed to run TM1 for a small installation?

The minimum requirement to run the sample TM1 servers provided will be:

  • Disk Space: Minimum 500 MB
  • Memory: Minimum 2 GB RAM
  • Processor: Pentium 4 or higher
  • OS: Windows 2003(x86, x64), Windows 2008(x86, x64), Windows 7(x86, x64), Linux

What are the steps to troubleshoot the FEEDERS?

  • Use Rules Tracer will be used to assist in the development and debugging of rules.
  • The functionality of Rule Tracer is available in Cube Viewer

Define the logic behind the Sparsity in cubes?

The more dimensions a cube has, the greater will be the degree of sparsity.

Name the components of report studio?

  • Insertable Objects pane
  • Properties pane
  • Explorer bar
  • Report Viewer

Name the components of Reportnet? 

-Cognos connection

-Query Studio

-Report Studio

Define Cognos Connection?

It is a Web portal for Cognos 8 and a component which interacts with the Content Store. It is a front end to publish, find, manage, organize, and view organization’s business intelligence data.

Define Cognos Reporting tool?

It’s a reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.

Define is catalog and types of catalogs in Cognos?

Catalog is a file containing the information (Database tables) that Impromptu users need to create reports. Types of catalogs are:

  • Personal
  • Distributed
  • Shared
  • Secured

Define Query Subject?

A Query Subject is a collection of Query Items. Generally query items have a defined relationship. It is primarily a database table upon which query action takes place.