Cognos Interview Question and Answers

25. What are the users of Cognos 8 BI?
  The users of Cognos 8 BI can be grouped into four major roles based upon their respective business and technical requirements. These groups include the following:
  • Consumers - are users who want to have access to pre-defined content. Most of the time, they want to access the content through a web portal, but in some scenarios they may require access to content from MS Office, by performing searches, or through a mobile device such as a Blackberry.
  • Authors - are power users who have access to advanced tools to create and maintain adhoc queries, reports, analyses, scorecards, dashboards and alerts. They build the BI objects that will later be accessed by the Consumers.
  • Developers - have access to development tools that build the infrastructure required by Authors to develop content. They create user-friendly layers used by Cognos 8 BI studios for Authors to use.
  • Administrators - have access to configuration, administration and monitoring tools to ensure the availability and performance of the Cognos 8 BI infrastructure.
Your Name Your Email-ID
Your Answer
26. What are the roles of Cognos 8 BI modules?
  These four roles use a combination roles of Cognos 8 BI modules to perform their work.
  • Framework Manager - is a development tool to create the end-user layer used by Authors to build their BI objects.
  • OLAP Designer - is a development tool used to model and create multidimensional databases. A multidimensional database, often referred to as a "cube", is a highly compressed database and contains summarized information that is optimized for analysis.
  • Metrics Designer - is a development tool used to model and deploy scorecards and related data loading procedures.
  • Data Manager - is a development tool commonly referred to as an ETL. ETL stands for Extraction, Transformation and Loading. It extracts data from multiple sources or systems or transforms or integrates it and then loads it to a central database for use with BI tools.
Your Name Your Email-ID
Your Answer
27. What is the difference between a cascading report and drillthrough report?
  • Cascading prompt means to extract the data from one prompt to using values from another prompt.
  • Drill through report means to extract the data by selecting a column in a report, means to get the detailed information by clicking that column data.
Your Name Your Email-ID
Your Answer
28. What are the differences between Reporter report and Explorer report?
  In a Cube, you can either modify or explore. Reporter is used to modify where as explorer is used to explore the cube.
Your Name Your Email-ID
Your Answer
1234567 Page 7 of 7