Ibm Cognos Tm1 Interview Questions And Answers
Question: 1. What Are The Basic Features Of Cognos Tm1?
Answer:
Real-time, interactive multidimensional database also with write-back functionality
64-bit, in memory OLAP server able to concentrate massive volumes of records
Enterprise level making plans and evaluation skills
Guided modeling environment to facilitate making plans, analysis and forecasting
Rapid development of flexible fashions, such as profitability models, without batch processing
Integrates with IBM Cognos Business Intelligence, to set up a single view of performance.
Question: 2. How Do You Use Tm1 Cubes In Framework Manager?
Answer:
TM1 v10.1 has the interoperability function configured to allow applications to be posted from TM1.
Microstrategy Interview Questions
Question: 3. How Many Types Of Viewers Available In Tm1?
Answer:
There are 3 sorts of viewers in TM1:
Cube Viewer.
Web Sheet Viewer.
Navigation Viewer.
Question: 4. How To Run Turbo Integrator Process From Command Line?
Answer:
To provoke the TI procedure TM1RunTI is a command line interface tool.
Microstrategy Tutorial
Question: five. Define Data Tab?
Answer:
Series of statements that manipulates values for each report in statistics supply.
IBM Cognos Interview Questions
Question: 6. Define Tm1 Package Connector?
Answer:
TM1 package connector facilitates to import information from applications/dimensions and custom queries.
Question: 7. What Is Epilog Tab?
Answer:
Series of statements this is to be finished after the statistics supply is processed.
IBM Cognos Tutorial IBM DB2 Interview Questions
Question: 8. Name The Function Which Is Used To Serialize The Ti Process?
Answer:
Synchronized () function can is used to serialize TI manner so that they can be processed sequentially.
Question: nine. What Are The Functions Required To Be Called For Enabling Or Disabling The Bulk Load Of Mode?
Answer:
EnableBulkLoadMode() = Enable
DisableBulkLoadMode() = Disable.
Data Warehousing Interview Questions
Question: 10. What Is The Limit Of String Length In Turbo Integrator?
Answer:
The limit of string period in Turbo Integrator is 8000 single byte character. If the period turns into greater 8000 bytes then it receives truncated.
IBM DB2 Tutorial
Question: eleven. What Are The Flaws Of Chore Start Time?
Answer:
TM1 executes chores in GMT requirements. It doesn’t have any auto mechanism to house DayLight Saving. Its Chores Scheduled time must be edited whilst DayLight time starts offevolved and ends.
SQL Interview Questions
Question: 12. Name The Different Procedures Within Ti?
Answer:
Defining Data Source
Setting Variables
Mapping Data
Editing Advanced Scripting
Scheduling the completed Process.
Microstrategy Interview Questions
Question: 13. Name The Window By Which You Can Create Your Own Custom Scripts?
Answer:
You can create your very own custom scripts using Advanced Window.
Data Warehousing Tutorial
Question: 14. How You Can Enable Bulk Load Mode In Ti?
Answer:
In Prolog or Epilog section of TI, Bulk Load mode can be enabled.
It continually advocated that Bulk Load Mode need to be enabled in Prolog segment.
Question: 15. Name The Sub-tabs Which Are In Advance Tab Of Ti?
Answer:
The sub-tabs which can be earlier tab of TI are:
Prolog
Metadata
Data
Epilog
IBM Cloud Computing Infrastructure Architect V1 Interview Questions
Question: sixteen. What Is The Meaning Of Ending Bulk Load Mode?
Answer:
All the device and User threads will be resumed and user logins may also be allowed.
Framework7 Tutorial
Question: 17. How We Can Generate Cubes In Cognos?
Answer:
Power Play Transformer incorporates dimension, measure, version and dice. There are extraordinary ways to generate a dice.
Steps to be accompanied:
Just proper click on dice name and construct.
We can write script in UNIX. Using that we will effortlessly generate the dice.
Framework7 Interview Questions
Question: 18. Name The Data Sources Which Are Available With Ti?
Answer:
Data Sources available with TI are:
SAP thru RFC
IBM Cognos Packages
Microsoft Analysis Services
Relational databases using ODBC Connectivity
Comma delimited text files such as ACII files
Other Cubes and Views
IBM Cognos Interview Questions
Question: 19. What Is Chore Commit Property?
Answer:
It lets in you to specify if the processes in chores might be devoted as a single transaction or either as more than one transaction
In a unmarried devote mode all strategies are dedicated as a single transaction. It is default by using nature.
In multiple commit modes any tactics that want to be devoted do so as they may be processed.
It is viable to trade chore property best while chore is INACTIVE.
Question: 20. Define Snapshot?
Answer:
Snapshot is nothing it’s best a replica of statistics, on every occasion we create any snapshot it most effective copy the precise statistics this is related to the specific report. It is used to compare reviews.
For ex: we need to compare the report of this month with previous month.
IBM BPM Interview Questions
Question: 21. Differentiate Between View And Materialized View?
Answer:
View includes question whenever execute perspectives it has study from base desk Materialized View
M perspectives loading or replicated takes region most effective once which gives you better query performance.
Question: 22. Define Bulk Load Mode?
Answer:
It permits TM1 to run in a special optimized Single-consumer mode. This mode has a potential to maximise the performance for dedicated duties in the course of the time when there is no load on server or at night time time.
It doesn’t display a message to end-user to alert them. No new connections can be created.
Question: 23. What Actually Happens When Bulk Load Mode Starts?
Answer:
All the scheduled chores will be deactivated
All the processing by way of different threads might be paused
Running chores and any of the present consumer threads can be suspended
TM1 Top connections and all of the device-unique threads can be suspended.
IBM DataPower Interview Questions
Question: 24. Define Drill Through?
Answer:
By the use of Drill-through reporting you can hyperlink from one report to every other. There are range of ways to Drill Through:
Drill Through identity evolved with reports:
Parent Report
Child Report
IBM DB2 Interview Questions
Question: 25. What Is The Difference Between List And Crosstab?
Answer:
List:
List report show the statistics in row and column(detail facts of record).
List may be transformed to Cross tab
Crosstab:
Crosstab record show the information in grids, dimensions in row and column and measures in cells or in intersection factor.
Crosstab can’t be converted to listing. There isn’t any direct alternative available in Report Studio to transform the move tab to list.
Question: 26. Give The Options Which Are Available After Importing Data Using Ti?
Answer:
Create Cube and populate facts
Create and Update dimensions
Re-create Cube. It destroys the present cube definitions and overwrites it.
Question: 27. Define Prolog Tab?
Answer:
Procedure is finished before the statistics source for the TI is opened. TI directly goes to Epilog if the statistics supply for the technique is none and if there’s no facts source then Metadata and facts tabs are omitted.
Data Warehousing Interview Questions
Question: 28. Define Metadata?
Answer:
Series of statements that replace or create cubes, dimensions and different metadata structures during the processing.
Question: 29. What Is The Cube Size?
Answer:
2.Zero GB. It depends as in keeping with your venture requirements.
Question: 30. What Kind Of System Requirement Is Needed To Run Tm1 For A Small Installation?
Answer:
The minimum requirement to run the pattern TM1 servers furnished might 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.
Question: 31. How Many Users Can Open Or Connect To One Of The Tm1 Web Application Concurrently?
Answer:
Using the disbursed technique of TM1 10 they have got accomplished testing in hundreds of users.
Question: 32. Define Feeders?
Answer:
It creates a placeholder at the cells in order that the cells will no longer be skipped for the duration of the consolidation.
Question: 33. What Is The Way Of Writing A Feeder Statement When Feeding One Cube From Another?
Answer:
Calculation declaration continually resides within the goal dice, however the FEEDER statement ought to are living inside the source dice.
The Feeder is essentially the inverse of the calculation assertion in the Target Cube that requires the feeder.
SQL Interview Questions
Question: 34. What Are The Steps To Troubleshoot The Feeders?
Answer:
Use Rules Tracer might be used to assist in the improvement and debugging of guidelines.
The capability of Rule Tracer is available in Cube Viewer.
Question: 35. How Does Rules Tracer Help Us?
Answer:
It lines FEEDERS; it ensures that selected leaf cells are feeding regulations-calculated cells properly or not.
It exams FEEDERS, guarantees that the kids of selected consolidated cells are fed well or no longer. Check Feeders options is to be had from consolidated cells and it’s now not to be had from leaf node.
Question: 36. Define The Logic Behind The Sparsity In Cubes?
Answer:
The greater dimensions a dice has, the extra may be the degree of sparsity.
IBM Cloud Computing Infrastructure Architect V1 Interview Questions
Question: 37. Define Over Feeding?
Answer:
Over Feeding approach defining feeders for consolidated cells. (Feeding a consolidated cell robotically feeds all kids of the consolidation.)
Question: 38. Define Under Feeding?
Answer:
Under Feeding method failing to the feed cells that include rules-derived values. This always results in incorrect values and must be avoided at all charges.
Question: 39. What Is The Role Of Skipcheck In Tm1?
Answer:
SKIPCHECK forces TM1 to use the Sparse Consolidation set of rules in all the cases.
Question: 40. What Is The Role Of Transformer?
Answer:
It is used for building the Cubes (Multidimensional Structure used for OLAP processing).
Framework7 Interview Questions
Question: 41. Name The Components Of Report Studio?
Answer:
Insertable Objects panProperties pane
Explorer bar
Report Viewer
Question: 42. Name The Components Of Report Net?
Answer:
Framework supervisor
Cognos connection
Query Studio
Report Studio
IBM BPM Interview Questions
Question: forty three. Name The Prompt Which Are Available In Cognos?
Answer:
Value activate
Text Prompt
Date prompt
Time set off
Date and time spark off
Question: forty four. Define Cognos Connection?
Answer:
It is a Web portal for Cognos eight and a thing which interacts with the Content Store. It is a frontend to publish, locate, manipulate, arrange, and consider organisation’s enterprise intelligence data.
Question: forty five. Define Cognos Reporting Tool?
Answer:
It’s a reporting device from IBM which helps in reporting and analysis of numerous facts from a statistics warehouse.
Question: 46. Define Junk Dimension?
Answer:
It is also referred to as as garbage size. A junk measurement is a convenient grouping of commonly low-cardinality flags and signs.
Question: 47. Define Is Catalog And Types Of Catalogs In Cognos?
Answer:
Catalog is a report containing the facts (Database tables) that Impromptu users want to create reviews.
Types of catalogs are:
Personal
Distributed
Shared
Secured
Question: 48. Differentiate Between Power Play Transformer And Power Play Reports?
Answer:
Power play transformer:
It is an ‘MOLAP’ device using which you’ll create multi dimensional shape known as “CUBE”.Power play reviews
Power play for reviews is used to generate record from the dice. Only one file may be generated from one dice. If you want ‘n’ reviews you should create ‘n’ cubes.
Question: 49. Define Sparse Cube?
Answer:
It’s a cube in which number of populated cells as a percent of general cells is simply too low.
Question: 50. Define Query Subject?
Answer:
A Query Subject is a group of Query Items. Generally query items have a defined courting. It is in general a database table upon which question motion takes place.