Most important Cognos Interview Questions and Answers

Here is a list of 60 important and commonly asked interview questions for Cognos ( A reporting tool developed by IBM ). Download Complete Cognos Interview Questions PDF file.Cognos is one of the great tools to analyze the data from data warehouse. If you looking for the resources to learn online refer our Cognos Tutorials and PDF guides.Now let us look into those questions.

Cognos

Cognos (Cognos Incorporated) was a company based in Ontario, Canada.  Its main areas of focus include performance management (PM) and making business intelligence (BI) software. The company was founded in 1969 and employed close to 3,500 people, serving over 23,000 customers in over 135 countries at its peak before it was acquired by NBM on 31st January   2008. Though the company is independent, the Cognos name is still applied to IBM’s line of business intelligence and performance management products.

Cognos Interview Questions and Answers

Below are some possible Cognos interview questions and answers in case you are planning to attend a Cognos interview soon.

  1. What is the difference between ‘macro’ and ‘prompt?

Ans.

Macro is used in running set of instructions in order to execute the report, while prompt gives you a way of changing the report dynamically.

  1. What is a Transformer?

Ans.

Transformer is used for making Cubes which is for the multidimensional structure in OLAP processing.

  1. What is Cognos Impromptu?

Ans.

A Cognos Impromptu is set to be a tool that can be used to generate business intelligence reports

  1. What is a Datastore in Cognos?

Ans.

It is a query database or a relational database or files which you can access through IBM Cognos.

  1. What is a dimension?

Ans.

Dimension is defined as structure of a cube. A dimension should have at least one key attribute and hierarchies can be defined by the remaining attribute.

  1. What is Cognos Reporting tool?

Ans.

Cognos is an IBM reporting tool which is used to report and analyze various data from different datawarehouse.

  1. What is Metrics designer?

Ans.

Metrics Designer is a tool which is used modeling, deploying score cards and data loading procedures.

  1. What is the use of Cognos scenario?

Ans.

Cognos scenario is used for finding the hidden trends and data patterns.

  1. What is a Pivot?

Ans.

Pivot aids in the rotating the axis of the cube to offer a different presentation on the data

  1. What is the use of Cognos decision stream?

Ans.

Cognos decision stream is a tool that is used to extract and transform the data from data sources to target source of data

  1. What is Query studio?

Ans.

Query studio is one of the studios in Cognos which is used in carrying out Adhoc queries

  1. What are the two types of framework manager?

Ans.

The two types of framework manager include:

  • Presentation layer
  • Physical layer
  1. What is a folder?

Ans.

A folder consists of repository objects such as sources, transformation, targets and mapping that assist in organizing data warehouse

  1. What are the advantages of Cognos?

Ans.

The advantages of Cognos include:

  • Planning
  • Analysis
  • Forecasting
  • Scorecard
  1. Is it possible to join multiple Databases in a Catalog?

Ans.

No, it is impossible to join multiple databases in a catalog and it is achievable by Hotfile.

  1. What is Bitmap Index?

Ans.

A bitmap index is used replacing list of rowids for each key value. This index is largely well-organized for data warehousing as it has low cardinality and low updates.

  1. Prepare for the first interview question anout the Cognos Tool. They will ask what is that tools or tell the tool in a few words like that
  2. What is called a Cognos Connection
  3. What is called a report item in Cognos
  4. What is called a filter. For which purpose you are going to use that
  5. What is meant by a query subject.
  6. Tell me about different types of prompt
  7. Have you header about Drill Through? What is that?
  8. Name the Report Net components
  9. Difference between Content store and content manager
  10. What is Embedded filter and stand alone filter. What are the differences ?
  11. Have you header about Cognos 8 BI
  12. Tell me about folfer types in Cognos
  13. What is a standalone folder
  14. What is a package folder
  15. What is a metrics folder
  16. What is macros and promot? what are the difference between them?
  17. What is called a transformer in Cognos?
  18. Tell me about catalog and various types of catalogs
  19. Expect a question about Cardinality
  20. Question about Security Module
  21. Generating cubers procedure
  22. Snapshot in Cognos
  23. Expect questions about Datastores
  24. Question about Metric store database
  25. Tell me about View and materialized view.
  26. Question about Data Mart and Data warehouse ( One of the important question )
  27. DTM
  28. Have you used repository manager in Cognos ? What are the uses ?
  29. Cascading Prompts