Explore topic-wise InterviewSolutions in .

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.

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.

It’s a CUBE in which NUMBER of populated cells as a PERCENTAGE of TOTAL cells is too low.

It’s a cube in which number of populated cells as a percentage of total cells is too low.

Power PLAY transformer:

1. It is an ‘MOLAP’ tool USING which one can create MULTI dimensional structure called “CUBE”.Power play reports
2. Power play for reports is used to generate report from the cube. Only one report can be GENERATED from one cube. If you want ‘N’ reports you must create ‘n’ cubes.

Power play transformer:

CATALOG is a file containing the INFORMATION (DATABASE tables) that Impromptu users NEED to create reports.

Types of catalogs are:

• PERSONAL
• Distributed
• Shared
• Secured

Catalog is a file containing the information (Database tables) that Impromptu users need to create reports.

Types of catalogs are:

It is ALSO CALLED as garbage dimension. A JUNK dimension is a convenient grouping of typically low-cardinality FLAGS and indicators.

It is also called as garbage dimension. A junk dimension is a convenient grouping of typically low-cardinality flags and indicators.

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

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

It is a Web portal for Cognos 8 and a COMPONENT which INTERACTS with the CONTENT Store. It is a frontend to publish, find, MANAGE, organize, and view organization’s business intelligence data.

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

• VALUE PROMPT
• TEXT Prompt
• DATE prompt
• TIME prompt
• Date and time prompt

• Framework manager
• COGNOS connection
• QUERY STUDIO
• Report Studio

• Insertable OBJECTS panProperties pane
• Explorer BAR
• REPORT VIEWER

It is USED for building the CUBES (MULTIDIMENSIONAL STRUCTURE used for OLAP PROCESSING).

It is used for building the Cubes (Multidimensional Structure used for OLAP processing).

SKIPCHECK forces TM1 to USE the Sparse CONSOLIDATION algorithm in all the cases.

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

Under FEEDING means failing to the feed cells that contain rules-derived values. This ALWAYS results in incorrect values and MUST be AVOIDED at all costs.

Under Feeding means failing to the feed cells that contain rules-derived values. This always results in incorrect values and must be avoided at all costs.

Over FEEDING means DEFINING feeders for CONSOLIDATED cells. (Feeding a consolidated CELL automatically FEEDS all children of the consolidation.)

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

The more DIMENSIONS a CUBE has, the GREATER will be the DEGREE of SPARSITY.

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

• It TRACES FEEDERS; it ensures that SELECTED leaf cells are FEEDING rules-calculated cells properly or not.
• It checks FEEDERS, ensures that the children of selected consolidated cells are fed properly or not. Check Feeders options is AVAILABLE from consolidated cells and it’s not available from leaf node.

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

• Calculation statement always 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.

It CREATES a PLACEHOLDER on the CELLS so that the cells will not be SKIPPED during the CONSOLIDATION.

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

USING the distributed APPROACH of TM1 10 they have DONE TESTING in thousands of users.

Using the distributed approach of TM1 10 they have done testing in thousands of users.

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.

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

2.0 GB. It DEPENDS as PER your PROJECT REQUIREMENTS.

2.0 GB. It depends as per your project requirements.

Series of statements that update or create CUBES, DIMENSIONS and other metadata STRUCTURES during the PROCESSING.

Series of statements that update or create cubes, dimensions and other metadata structures during the processing.

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.

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.

• Create Cube and populate DATA
• Create and UPDATE DIMENSIONS
• Re-create Cube. It destroys the EXISTING cube DEFINITIONS and overwrites it.

List:

1. List REPORT show the data in row and column(detail INFORMATION of report).
2. List can be converted to Cross TAB

Crosstab:

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

List:

Crosstab:

By using DRILL-through REPORTING you can link from one REPORT to another. There are number of ways to Drill Through:

Drill Through id developed with TWO reports:

1. PARENT Report
2. Child Report

By using Drill-through reporting you can link from one report to another. There are number of ways to Drill Through:

Drill Through id developed with two reports:

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

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

1. VIEW CONTAINS QUERY whenever execute views it has read from base table Materialized View
2. M views LOADING or replicated takes place only once which gives you better query performance.

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.

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.

• It allows you to specify if the processes in CHORES will be COMMITTED as a single transaction or either as multiple transaction
• In a single commit mode all processes are committed as a single transaction. It is default by nature.
• In multiple commit MODES any processes that need to be committed do so as they are PROCESSED.
• It is possible to change chore property only when chore is INACTIVE.

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 ACII files
• Other Cubes and Views

Data Sources available with TI are:

Power Play TRANSFORMER contains dimension, measure, model and cube. There are different ways to GENERATE a cube.

Steps to be FOLLOWED:

1. Just right CLICK on cube name and build.
2. We can write script in UNIX. Using that we can EASILY generate the cube.

Power Play Transformer contains dimension, measure, model and cube. There are different ways to generate a cube.

Steps to be followed:

All the SYSTEM and User THREADS will be resumed and user LOGINS will also be allowed.

All the system and User threads will be resumed and user logins will also be allowed.

The sub-tabs which are in advance TAB of TI are:

• PROLOG
• Metadata
• Data
• Epilog

The sub-tabs which are in advance tab of TI are:

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

You can create your own CUSTOM SCRIPTS using Advanced WINDOW.

You can create your own custom scripts using Advanced Window.

• Defining Data Source
• Setting Variables
• Mapping Data
• EDITING Advanced Scripting
• SCHEDULING the completed PROCESS.

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.

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.

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.

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.

EnableBulkLoadMode() = Enable
DisableBulkLoadMode() = DISABLE.

EnableBulkLoadMode() = Enable
DisableBulkLoadMode() = Disable.

Synchronized () function can is used to SERIALIZE TI PROCESS so they can be PROCESSED SEQUENTIALLY.

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

Series of statements that is to be EXECUTED after the data SOURCE is PROCESSED.

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

TM1 package connector HELPS to import DATA from packages/dimensions and CUSTOM queries.

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

SERIES of STATEMENTS that manipulates values for each record in DATA source.

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

To INITIATE the TI PROCESS TM1RunTI is a COMMAND line interface tool.

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

There are 3 TYPES of viewers in TM1:

1. Cube Viewer.
2. WEB SHEET Viewer.
3. Navigation Viewer.

There are 3 types of viewers in TM1:

TM1 v10.1 has the interoperability function configured to ALLOW PACKAGES to be PUBLISHED from TM1.

TM1 v10.1 has the interoperability function configured to allow packages to be published from 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.