10/9/16

Cognos Interview Questions and Answers

Question.1 What is Cognos Reporting tool?
Answer: Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
Question.2 What is Cognos Connection?
Answer: It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a front end to publish, find, manage, organize, and view organization’s business intelligence data.

Question.3 What is Report item?
Answer: Report item is nothing but a query item when it is drag and drop into the work area.
Question.4 What is Cardinality?
Answer: Cardinality is nothing but relation between tables.
One to One > One to Many > Many to Many > Many to One
Question.5 What is data mining?
Answer: Data mining is a process of extracting hidden trends within a data warehouse.
Question.6 What are the types of prompt in Cognos?
Answer: Value prompt ,Text Prompt, Date prompt, Time prompt, Date and time prompt
Question.7 What is Drill Through?
Answer: Drill-through reporting allows you to link from one report to another. You can drill through in a number of ways. > A Drill Through id developed with two reports.
1. Parent Report  > 2. Child Report.
Question.8 What are the components of Report Net?
Answer: Framework manager ,Cognos connection, Query Studio, Report Studio
Question.9 What is difference between content store and content manager?
Answer: A content store is a data base which stores the meta data of the reports.
But where as a content manager is a service which is available in dispatcher. which it manages the security.
Question.10 What is OLAP?
Answer: OLAP stands for On Line Analytical Processing, a series of protocols used mainly for business reporting.
Question.11 What are components of report studio?
Answer: Insertable Objects pane > Properties pane > Explorer bar >Report Viewer
Question.12 What is Snap Shot?
Answer: snapshot is a static datasource it is a picture of of report once u created a snapshot report u can’t add a data item.
Question.13 How do you define a cube?
Answer: Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing.
Question.14 What is the Difference between PowerPlay transformer and power play reports?
Answer: Powerplay transformer’ is an ‘MOLAP’ tool using which one can create multi dimensional structure called “CUBE”.
Powerplay for reports is used to generate report from the cube.Only one report can be generated from one cube.If u want ‘n’ reports u must create ‘n’ cubes.
Question.15 What is cube size?
Answer: 2.0 GBIt depends on ur project requirements.
Question.16 What is meant by Junk Dimension?
Answer: The Junk Dimension also called as garbage dimension. A junk dimension is a convenient grouping of typically low-cardinality flags and indicators.
Question.17 What is transformer?
Answer: Transformer is used for building the Cubes (Multidimensional Structure used for OLAP
Question.18 What is catalog and types of catalogs in cagnos?
Answer: A catalog is a file containing the information (Database tables) that Impromptu users need to create reports. >personal> distributed > hared > secured
Question.19 What is Cardinality?
Answer: Relationships exist between two query subjects. The cardinality of a relationship is the number of related rows for each of the two query subjects. The rows are related by the expression of the relationship; this expression usually refers to the primary and foreign keys of the underlying tables.