Q.1) What is Sparse Cube?
Ans) A cube in which the number of populated cells as a percentage of total cells is too low
Q.2) What are the different windows in Turbo Integrator?
Ans) There are different tabs available in Turbo Integrator
Q.3) What is the use of an advanced window in the Turbo Integrator?
Ans) Using the Advanced window you can create your own custom scripts.
Q.4) What is TM1 Workflow? How do you create a process in that?
Ans) 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.
Q.5) What are the data sources available with TI?
Q.6)Where is Portlet used?
Ans) Portlets are used in Cognos.
Q.7) How can you access the TM1 web form portlet?
Ans) There is an option to integrate TM1 viewers in Cognos Portlets.
Q.8) What are the different windows in the portlet?
Ans) There is 3 type of viewers available in TM1.
Q.9) What are the basic features of Cognos TM1?
Q.10) How do you use TM1 cubes in Framework Manager?
Ans) TM1 v10.1 has the interoperability function configured to allow packages to be published from TM1.
Q.11)How to run Turbo Integrator Process from Command Line?
Ans) To initiate the TI process TM1RunTI is a command-line interface tool.
Q.12) Define Data Tab?
Ans) Series of statements that manipulate values for each record in data source.
Q.13) What are sub-tabs in advance tab of TI?
Q.14) What is the logic of Sparsity in cubes?
Ans) 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.
Q.15) What is Overfeeding?
Ans) Defining feeders for consolidated cells. (Feeding a consolidated cell automatically feeds all children of the consolidation.)
Q.16) What is Under Feeding?
Ans) Failing to feed cells that contain rules-derived values. This always results in incorrect values and must be avoided at all costs.
Q.17) How does SKIP CHECK help TM1?
Ans) SKIP CHECK forces TM1 to use the Sparse Consolidation algorithm in all cases.
Q.18) What are FEEDERS?
Ans) It creates a placeholder on cells so that cells will not be skipped during the consolidation
Q.19) What is FEEDSTRING?
Q.20) What are simple FEEDERS?
Ans) FEEDERS are applied to calculation within one dimension of one cube.
Q.21) Define TM1 package connector?
Ans) TM1 package connector helps to import data from packages/dimensions and custom queries.
Q.22) What is Epilog Tab?
Ans) Series of statements that is to be executed after the data source is processed.
Q.23) Name the function which is used to serialize the TI process?
Ans) The synchronized () function can is used to serialize the TI process so they can be processed sequentially.
Q.24) What are the functions required to be called for enabling or disabling the bulk load of mode?
Q.25) What is the limit of string length in Turbo Integrator?
Ans) The limit of string length in Turbo Integrator is 8000 single-byte characters. If the length will become more 8000 bytes then it gets truncated.
Q.26) What are the flaws of Chore Start Time?
Ans) 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.
Q.27) Name the different procedures within TI?
Ans) 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.
Ans) There are different ways to generate a cube.
Steps to be followed:
Q.30) Name the data sources which are available with TI?
Ans) Data Sources available with TI are:
Q.31) Define snapshot?
Ans) 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.
Q.32) Define Bulk Load mode?
Q.33) How is the FEEDER Statement written when feeding one cube from another?
Q.34) How to Troubleshoot the FEEDERS?
Q.35) How does Rules Tracer help?
Q.36) What actually happens when Bulk Load mode starts?
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
Q.38) What is the difference between list and crosstab?
Q.39) Give the options which are available after importing data using TI?
Q.40) Define Prolog tab?
Ans) The 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.
Q.41) What is the cube size?
Ans) 2.0 GB. It depends as per your project requirements.
Ans) The minimum requirement to run the sample TM1 servers provided will be:
Q.44) Define the logic behind the Sparsity in cubes?
Ans) The more dimensions a cube has, the greater will be the degree of sparsity.
Q.45) Name the components of report studio?
Ans) It is a Web portal for Cognos 8 and a component that interacts with the Content Store. It is a front end to publish, find, manage, organize, and view the organization’s business intelligence data.
Ans) It’s a reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
Q.49) Define is catalog and types of catalogs in Cognos?
Ans) the catalog is a file containing the information (Database tables) that Impromptu users need to create reports. Types of catalogs are:
Q.50) Define Query Subject?
Ans) 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.
You liked the article?
Like : 1
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox