Blog Archive

Theme images by Storman. Powered by Blogger.

Saturday, August 20, 2016

Latest Cognos BI Interview Questions And Answers.


Latest Cognos BI Interview Questions And Answers. Most Frequently Asked Cognos BI Interview Questions. Cognos Interview Questions For Freshers And Experienced. 

1. What is Cognos Reporting tool?

 Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from   a data warehouse.

2. What is Cognos Connection?

 It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is   a frontend to publish, find, manage, organize, and view organization’s business intelligence   data.

3. What is Report item?

 Report item is nothing but a query item when it is drag and drop into the work area.

4. Define filter?
 A filter is an expression that specifies the conditions that rows or instances must meet to be   retrieved for the dimension, query subject, calculation, or report to which the filter is   applied.

5. What is query subject?
 A query subject is the basic building block in Framework Manager. A query subject is a set of   query items that have an inherent relationship.

6. What are the types of prompt in Cognos?
 Value prompt

  Text Prompt

  Date prompt

  Time prompt

  Date and time prompt
7. What is Drill Through?
 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.

8. What are the components of Report Net?
 Framework manager
 Cognos connection
 Query Studio
 Report Studio

9. What is difference between content store and content manager?
 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.
10. What is the difference between Stand–alone and Embedded filter?
 There are two types of filters :
 1) Stand–alone : to reuse the expression.
 2) Embedded : to use a filter with only one dimension or query subject.

. Define Cognos 8 BI?
 Cognos 8BI is a powerful suite of products that focuses on transforming raw data into powerful  information for business decisions. Cognos 8 BI can be used across all levels in an  organization, from users looking for pre–defined reports to analysts with complex data  requirements. For all levels of users, Cognos 8BI has a tool.
15. What are the different types of folders?
 There are three main types of folders are:

  Standard Folder

  Package Folder

  Metrics Folder

16. Explain standard folders?
 This is a container for other folders or BI objects, and is used for organizational purposes.   It will behave just like a folder on your local computer, but will operate like a web page with  active  links. A bright yellow icon specifics Standard folders.
17. Explain package folders?
 This folder is similar to a Standard Folder, but internally it contains pre-defined business   rules and metadata related to sources of information. It is used by the Studios to create new   queries, reports, analyses, etc. A dark blue icon specifics Package folders.
18. Explain metrics folders?
 Metrics folders arc used by the Metrics Studio to store metrics-related information. While the   standard behavior upon selecting the other two folder types is to show their contents, a   Metrics Folder  will open up directly into Metrics Studio. A dark blue icon with colored dots   specifies Metrics  folders.

19) Define Business Intelligence

 Business Intelligence is a broad category of application programs and technology used for querying, Reporting and analyzing the business.

20) What is a Data Mart?

 A Data Mart is a subset of a data warehouse that can provide data for reporting and analysis.

21) What is HPQS? 

 Data Marts are sometimes also called as HPQS (Higher Performance Query Structure).

22) What is multi dimension analysis? 

 It is a technique to modify the data so that the data can be view at the different levels of details.

23) What are the responsibilities of Cognos Administrator?

 A Cognos Administrator is assigned with following responsibilities.

1.     Installations and configurations in distributed network environment.
2.     Creating the Repository (Content Store).
3.     Perform back up and recovery of Meta Data.
4.     Developing the user Administration.
5.     Tuning the servers.
6.     Deployment.

24) Responsibility of Cognos Architect?

 An Architect is responsible for designing the interface by fulfilling the user requirements.
 Once the interface has been designed it should be rigorously tested before distributing to the end user population.

25) Roles of the Application Developer?
 Design the Reports according to the Report requirement templates.
 Testing the each report with the following types of tests.

a.     Unit Testing
b.    System Testing
c.     Performance Testing

26) What is OLAP?
 OLAP stands for Online Analytical Processing. It uses database tables (Fact and Dimension tables) to enable multidimensional viewing, analysis and querying of large amount of data.

27) What are the types of OLAPs?

1.     DOLAP:-The OLAP tool which works with desktop databases are called as DOLAP

 Ex:- FoxPro, Clipper, Dbase, Paradox.

2.     ROLAP:-The OLAP tool, which works with Relational databases, are called as ROLAP.

 Ex:-Oracle, SQL Server, Tera Data, DB2.

3.     MOLAP: - The OLAP tool, which works with Multidimensional databases, are called as MOLAP.

 Ex: - ESSBASE, Power Cube

4.     HOLAP: - The OLAP tool which works with Relational databases and Multidimensional database, are called as MOLAP.

 Ex: - Cognos, Business Objects.

28) What is OLTP?

 OLTP stands for Online Transaction Processing. Except data warehouse databases the other databases are OLTPs. These OLTP databases are designed for recording the daily operations and transactions of a business.

30) What is an Interface?

 An Interface is a gateway between the user and database.

0 on: "Latest Cognos BI Interview Questions And Answers."