Explore topic-wise InterviewSolutions in .

An Interface is a gateway between the USER and database.

• An Interface contains a LOGICAL POINTERS which pointers to data in the Data Warehouse.
• An Interface is isolates the complexity and diversity if data bases.
• A GOOD OLAP Interface writes an efficient SQL read on accurate data from database.
• An Interface needs to be designed by fulfilling the report requirement.

An Interface is a gateway between the user and database.

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.

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.

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 ROLAP tool which works with Relational databases and Multidimensional database, are called as MOLAP.
Ex: - COGNOS, BUSINESS Objects.

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 ROLAP tool which works with Relational databases and Multidimensional database, are called as MOLAP.
Ex: - Cognos, Business Objects.

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.

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.

Design the Reports according to the Report requirement templates.

Testing the each report with the FOLLOWING TYPES of TESTS:

1. Unit Testing
2. SYSTEM Testing
3. Performance Testing

Design the Reports according to the Report requirement templates.

Testing the each report with the following types of tests:

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.

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.

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.

A Cognos Administrator is assigned with following responsibilities:

It is a technique to MODIFY the data so that the data can be VIEW at the DIFFERENT levels of DETAILS.

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

Data MARTS are SOMETIMES ALSO called as HPAS (Higher Performance QUERY Structure).

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

A Data MART is a SUBSET of a data WAREHOUSE that can PROVIDE data for REPORTING and analysis.

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

BUSINESS Intelligence is a broad CATEGORY of APPLICATION programs and technology used for querying, Reporting and ANALYZING the business.

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

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.

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.

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.

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.

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.

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.

There are THREE main TYPES of FOLDERS are:

• STANDARD Folder
• Package Folder
• Metrics Folder

There are three main types of folders are:

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.

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.

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.

There are two types of filters :

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.

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.

• FRAMEWORK MANAGER
• Cognos connection
• QUERY STUDIO
• Report Studio

• VALUE PROMPT
• TEXT Prompt
• DATE prompt
• TIME prompt
• Date and time prompt

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.

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.

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.

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.

It is a Web portal for Cognos 8 and a component which INTERACTS with the CONTENT STORE. It is a frontend to publish, find, MANAGE, ORGANIZE, and view organization’s business intelligence data.

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

Cognos is a REPORTING tool from IBM which helps in reporting and ANALYSIS of VARIOUS DATA from a data WAREHOUSE.

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