Subscribe Jobs Via E-Mail


Cognos Interview Questions 2014/15 | Cognos Interview Questions with Answers

Cognos Interview Questions 2014/15 | Cognos Interview Questions with Answers
Cognos Interview Questions 2014/15. Cognos Interview Questions with Answers. Latest Interview Questions For Cognos. IBM Cognos Interview Questions. IBM BI Interview Questions With Answers.
1.  What to do at database side to improve performance? What is Performance tuning?

A: There are many ways to improve database performance. One of them being creating indexes on table columns that are queried the most. Another is create table partitioning. A whole lot else can be accomplished at the report level by fine tuning the query or the filters created automatically by Cognos Report Studio.

2. What is the difference between pass data item value and pass parameter value ?

A: Data item value is the one which is render in a prompt or container retrieved from per-generated values. ex combo box, list values, which has data item values and may show different display values.

Pass parameter value is usually is one which are entered by the user, like a text prompt where user enters the value to retrieve the report. ex. entering a customer number, or order number manually.

3. What is set to be Cardinality?

A: Cardinality is defined as relationships between the tables. Following are relationship formed
between the tables.
One to One
One to Many
Many to Many
Many to One

4. What is defined as Data mining?

Data mining is the process of getting hidden trends from a data ware house.

5. What are all the different types of prompt in Cognos?

A: Following are the different types of prompt in Cognos:
Value prompt
Text Prompt
Date prompt
Time prompt
Date and time prompt

6. What are the components of Report Net?

A: Following are the components of Report Net:

Framework manager
Cognos connection
Query Studio
Report Studio

7. What do you mean by Drill Through report?

A: Drill through reporting is used to link from one report to another report. It has parent and child relationship between the reports.

8. Mention the difference between ‘macros’ and ‘prompt’?

A: Macro is used to run set of instructions to execute the report but prompt provide a way to
change the report dynamically.

9. What is a Cube?

A: Cube is set to be multi-dimensional view of dimension and measures and it is used to analyze the data in various forms like Slicing and Dicing.

10. What is the size of the cube?

A: Size of the cube is 2.0GB and size varies depends on the project.

11. What is a Snapshot?

A: A snapshot is created to copy the exact data that is related to current report and compare with another report.

Example: Data of this week compared with previous week

12. What are all the components of Report Studio?

A: Following are the components of Report Studio:
Objects panel
Properties panel
Explorer bar
Report Viewer

13. What is a Transformer?

A: Transformer is used for making the Cubes which is for the Multidimensional structure on OLAP processing.

14. What is defined as catalog and types of catalogs in Cognos?

A: A catalog is defined as a file which contains information on Database tables and Impromptu
users can create reports.
Following are the types of catalog used:

15. Is it possible to join multiple Databases in a Catalog?

A: No, it is not possible to join multiple databases in a catalog and it can be achieved by Hotfile.

16. What is defined as Cognos Impromptu?

A: A Cognos Impromptu is set to be a tool which is used for the generation of business intelligence

17. What are query items?

A: Query items are the most important object in framework manager and it has a lot of properties
associated with it. This is mainly used for reporting and business intelligence.

18. What are all the advantages of Cognos?

A: Following are the advantages of Cognos:

19. What are all the types of indexes in Cognos?

A: Following are the types of Indexes in Cognos:
Bitmap index
B-tree index
Function based index
Reverse key and composite index

20. What is Bitmap Index?

A: A bitmap index is used for replacement of list of rowids for each key value. This index is mainly
efficient for data warehousing as it has low cardinality and low updates.

21. What is a Folder?

A: A folder consists of repository objects like sources, targets, transformation and mapping that
help to organize data warehouse.

22. What is a Datastore in Cognos?

A: A data store is nothing but a query database or a relational database or files that can be
accessed through IBM Cognos.

23. What is a Query Subject?

A: A Query subject is a set of query items that have inherent relationship and it is basic building
block on framework manager.

24. What are all the types of report?

A: Following are the types of report in Cognos:
Blank report
List report
Cross report
Chart report
Repeater report

25. What are the two types of framework manager?

A: There are two types of framework manager and they are as follows:
Presentation layer
Physical layer

26. What are all types of prompt?

A: Following are the types of Prompt used in Cognos:
Select and search
Date and time
Prompt button

27. What is a dimension?
A: Dimension is defined as structure of a cube. A dimension should have at least one key attribute
and remaining attribute can define hierarchies.

28. What are all the types of gateway used in Cognos?

A: Following is the list of gateway used in Cognos:
Common Gateway Interface (CGI)
Internet Service Application Interface (ISAPI)
Tomcat Server

29. What is called Cognos powerplay?

A: Cognos powerplay is nothing but a multidimensional on-line analysis of data.

30. What are the types of studio present in Cognos?

A: There are five types of studio are :
Query Studio
Metrics Studio
Analysis Studio
Report Studio
Event Studio

31. What is defined as Query studio?

A: Query studio is one of the studios in Cognos which is used to perform Adhoc queries.

32. What are the types of folder present in Cognos?

A: There are three main types of folders and they are listed below:
Standard folder
Package folder
Metrics folder

33. What do you mean by drill across?

A: The drill across executes queries with the help of more than one cube.

34. What are all the types of hierarchies?

A: There are two types of hierarchies:
Attribute hierarchies
User defined hierarchies

35. What is the use of Cognos decision stream?

A: Cognos decision stream is set to be a tool which is used for extracting, transforming the data
from different data sources to target data source.

36. What are the themes in a data warehouse?

A: The three important fundamental themes are:
Drilling Down
Drilling Across
Handling Time

37. What do you mean by Drill down and Drill Up?

A: Drill down is addition of grouping columns from the dimension tables whereas drill up is
removing grouping columns from the dimension tables.

38. What is the advantage of using shortcuts?

A: There are two shortcuts – Local and Global. Local is used for the local repository and Global for global repository. Advantage is to reuse an object instead of creating multiple objects.

39. What is called materialized view?

A: A materialized view is a view which is physically stored in a database. This view is used to increase query performance by calculating costly operations.

40. What is a Pivot?

A: Pivot is used to rotate the axis of the cube to provide a different presentation on the data.

41. What is called a slice?

A: The slice is used to perform the operation on one dimension of a cube and it is results in a subcube.

42. What is a Framework manager?

A: Frame manager is a tool, which is used to develop end user layer and it can be used by Authors
to build their own BI objects.

43. What is Metrics designer?

A: Metrics Designer is a tool which is used to model, deploy score cards and data loading

44. What is set to be Cognos configuration?

A: Cognos Configuration is a BI administrative tool which is used to define the behavior of Cognos
8 version. This will manage configuration parameters.

45. What is the difference between Standard and Metrics folder?

A: Standard Folder - This is a container of all folders and it is used for Organizational
purposes. It acts like a local computer folder. It is yellow in color.
Metrics Folder - This folder is used by Metrics studio to store metrics related
information. Metrics folder will open up directly in Metrics studio and it is dark blue in

46. What is the use of Cognos scenario?

A: Cognos scenario is used to find the hidden trends and patterns of data.

47. Which studio is used to create reports?

A: Report Studio is used to create more advanced business reports.

48. What is the difference between a cascading report and drill through report?

A: Cascading report is used to extract data from one prompt to another prompt.
Drill through report is used to extract the data by selecting the column in a report and it can be
drilled down by clicking the column data.