CrowdforGeeks | Build Skills with Online Courses from Top Institutions

Ibm Cognos Tm1 Placement Papers - Ibm Cognos Tm1 Interview Questions and Answers

Q1. Define Prolog Tab?

Procedure is done earlier than the information source for the TI is opened. TI without delay is going to Epilog if the information source for the method is none and if there is no records supply then Metadata and facts tabs are overlooked.

Q2. Define Sparse Cube?

It’s a cube in which quantity of populated cells as a percent of overall cells is simply too low.

Q3. What Is The Role Of Skipcheck In Tm1?

SKIPCHECK forces TM1 to apply the Sparse Consolidation algorithm in all of the instances.

Q4. How Many Users Can Open Or Connect To One Of The Tm1 Web Application Concurrently?

Using the dispensed technique of TM1 10 they've done trying out in lots of customers.

Q5. Name The Data Sources Which Are Available With Ti?

Data Sources available with TI are:

SAP thru RFC

IBM Cognos Packages

Microsoft Analysis Services

Relational databases using ODBC Connectivity

Comma delimited textual content files inclusive of ACII documents

Other Cubes and Views

Q6. Define Feeders?

It creates a placeholder on the cells in order that the cells will no longer be skipped during the consolidation.

Q7. Define The Logic Behind The Sparsity In Cubes?

The extra dimensions a dice has, the more might be the degree of sparsity.

Q8. Define Data Tab?

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

Q9. What Is The Difference Between List And Crosstab?

List:

List record show the records in row and column(detail statistics of file).

List may be converted to Cross tab

Crosstab:

Crosstab document display the records in grids, dimensions in row and column and measures in cells or in intersection point.

Crosstab can’t be converted to listing. There is not any direct choice to be had in Report Studio to transform the go tab to listing.

Q10. How Do You Use Tm1 Cubes In Framework Manager?

TM1 v10.1 has the interoperability feature configured to permit packages to be posted from TM1.

Q11. How Does Rules Tracer Help Us?

It strains FEEDERS; it ensures that decided on leaf cells are feeding rules-calculated cells nicely or not.

It tests FEEDERS, ensures that the kids of decided on consolidated cells are fed nicely or no longer. Check Feeders alternatives is to be had from consolidated cells and it’s not to be had from leaf node.

Q12. How We Can Generate Cubes In Cognos?

Power Play Trformer carries dimension, degree, model and dice. There are special ways to generate a dice.

Steps to be observed:

Just right click on on cube call and construct.

We can write script in UNIX. Using that we are able to without difficulty generate the cube.

Q13. Differentiate Between Power Play Trformer And Power Play Reports?

Power play trformer:

It is an ‘MOLAP’ device using which you can still create multi dimensional structure called “CUBE”.Power play reviews

Power play for reviews is used to generate document from the dice. Only one document can be generated from one dice. If you want ‘n’ reviews you must create ‘n’ cubes.

Q14. What Is Epilog Tab?

Series of statements that is to be carried out after the facts source is processed.

Q15. Define Snapshot?

Snapshot is nothing it’s best a duplicate of records, every time we create any snapshot it handiest copy the exact information that is associated with the unique report. It is used to examine reports.

For ex: we need to examine the document of this month with previous month.

Q16. Name The Prompt Which Are Available In Cognos?

Value set off

Text Prompt

Date prompt

Time activate

Date and time spark off

Q17. What Are The Flaws Of Chore Start Time?

TM1 executes chores in GMT standards. It doesn’t have any car mechanism to deal with DayLight Saving. Its Chores Scheduled time should be edited when DayLight time starts offevolved and ends.

Q18. What Is The Meaning Of Ending Bulk Load Mode?

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

Q19. Name The Components Of Report Net?

Framework supervisor

Cognos connection

Query Studio

Report Studio

Q20. Name The Sub-tabs Which Are In Advance Tab Of Ti?

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

Prolog

Metadata

Data

Epilog

Q21. Define Query Subject?

A Query Subject is a group of Query Items. Generally question items have a described courting. It is ordinarily a database desk upon which question movement takes vicinity.

Q22. How Many Types Of Viewers Available In Tm1?

There are 3 varieties of viewers in TM1:

Cube Viewer.

Web Sheet Viewer.

Navigation Viewer.

Q23. How To Run Turbo Integrator Process From Command Line?

To provoke the TI system TM1RunTI is a command line interface tool.

Q24. What Are The Functions Required To Be Called For Enabling Or Disabling The Bulk Load Of Mode?

EnableBulkLoadMode() = Enable

DisableBulkLoadMode() = Disable.

Q25. Define Junk Dimension?

It is also referred to as as rubbish size. A junk size is a handy grouping of generally low-cardinality flags and indicators.

Q26. What Is The Role Of Trformer?

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

Q27. Define Metadata?

Series of statements that replace or create cubes, dimensions and different metadata structures at some point of the processing.

Q28. Name The Different Procedures Within Ti?

Defining Data Source

Setting Variables

Mapping Data

Editing Advanced Scripting

Scheduling the completed Process.

Q29. What Is The Limit Of String Length In Turbo Integrator?

The restriction of string duration in Turbo Integrator is 8000 unmarried byte person. If the duration becomes more 8000 bytes then it receives truncated.

Q30. Define Cognos Connection?

It is a Web portal for Cognos eight and a issue which interacts with the Content Store. It is a frontend to put up, locate, manipulate, arrange, and look at organization’s enterprise intelligence statistics.

Q31. Differentiate Between View And Materialized View?

View consists of query on every occasion execute views it has read from base table Materialized View

M views loading or replicated takes region simplest once which gives you higher question performance.

Q32. Define Is Catalog And Types Of Catalogs In Cognos?

Catalog is a report containing the information (Database tables) that Impromptu customers want to create reviews.

Types of catalogs are:

Personal

Distributed

Shared

Secured

Q33. What Is Chore Commit Property?

It allows you to specify if the tactics in chores will be committed as a unmarried traction or both as multiple traction

In a single dedicate mode all techniques are dedicated as a single traction. It is default by nature.

In multiple devote modes any tactics that want to be committed do so as they are processed.

It is possible to alternate chore belongings best while chore is INACTIVE.

Q34. What Is The Cube Size?

2.0 GB. It depends as in keeping with your challenge requirements.

Q35. How You Can Enable Bulk Load Mode In Ti?

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

It always advocated that Bulk Load Mode ought to be enabled in Prolog segment.

Q36. Name The Function Which Is Used To Serialize The Ti Process?

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

Q37. Give The Options Which Are Available After Importing Data Using Ti?

Create Cube and populate statistics

Create and Update dimensions

Re-create Cube. It destroys the prevailing dice definitions and overwrites it.

Q38. What Are The Basic Features Of Cognos Tm1?

Real-time, interactive multidimensional database also with write-returned functionality

64-bit, in memory OLAP server capable of pay attention massive volumes of information

Enterprise stage planning and analysis abilities

Guided modeling surroundings to facilitate making plans, analysis and forecasting

Rapid development of bendy fashions, which include profitability fashions, with out batch processing

Integrates with IBM Cognos Business Intelligence, to set up a unmarried view of performance.

Q39. What Is The Way Of Writing A Feeder Statement When Feeding One Cube From Another?

Calculation statement always is living within the target cube, however the FEEDER statement should live in the supply cube.

The Feeder is basically the inverse of the calculation declaration within the Target Cube that calls for the feeder.

Q40. Name The Window By Which You Can Create Your Own Custom Scripts?

You can create your very own custom scripts the usage of Advanced Window.

Q41. What Actually Happens When Bulk Load Mode Starts?

All the scheduled chores might be deactivated

All the processing by way of other threads can be paused

Running chores and any of the existing person threads will be suspended

TM1 Top connections and all the device-particular threads can be suspended.

Q42. Define Under Feeding?

Under Feeding me failing to the feed cells that include rules-derived values. This constantly outcomes in wrong values and have to be avoided at all costs.

Q43. Name The Components Of Report Studio?

Insertable Objects panProperties pane

Explorer bar

Report Viewer

Q44. Define Bulk Load Mode?

It enables TM1 to run in a special optimized Single-person mode. This mode has a capacity to maximise the overall performance for committed responsibilities at some point of the time while there's no load on server or at night time time.

It doesn’t display a message to quit-user to alert them. No new connections can be created.

Q45. What Kind Of System Requirement Is Needed To Run Tm1 For A Small Installation?

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

Disk Space: Minimum 500 MB

Memory: Minimum 2 GB RAM

Processor: Pentium four or higher

OS: Windows 2003(x86, x64), Windows 2008(x86, x64), Windows 7(x86, x64), Linux.

Q46. Define Cognos Reporting Tool?

It’s a reporting tool from IBM which enables in reporting and analysis of various information from a facts warehouse.

Q47. Define Tm1 Package Connector?

TM1 bundle connector allows to import information from packages/dimensions and custom queries.

Q48. What Are The Steps To Troubleshoot The Feeders?