Explore topic-wise InterviewSolutions in .

• COGNOS Connection
• Report Studio
• QUERY Studio
• Frame work MANAGER
• Cognos CONFIGURATION

It has system-generated artificial primary key values, which ALLOWS to MAINTAIN historical RECORDS in the Data WAREHOUSE more effectively.

It has system-generated artificial primary key values, which allows to maintain historical records in the Data Warehouse more effectively.

A RANDOMLY USED DIMENSION is JUNK Dimension

A randomly used dimension is Junk Dimension

If a Dimension is connected to MULTIPLE FACT tables then it is called as CONFORMED Dimension.

If a Dimension is connected to multiple fact tables then it is called as Conformed Dimension.

A JOIN IDENTIFIES the columns from one table that are used to LINK to another table.

A Join is commonly formed by a foreign key DEFINITION within the database.

Types of Joins:-

• Equi-joins
• Non equi-joins
• Outer joins

A Join identifies the columns from one table that are used to link to another table.

A Join is commonly formed by a foreign key definition within the database.

Types of Joins:-

An ambiguous RELATIONSHIP is where there are multiple relationship PATHS between one or more QUERY subjects leaving multiple OPTIONS for how to write a query.

An ambiguous relationship is where there are multiple relationship paths between one or more query subjects leaving multiple options for how to write a query.

The group association of a NEWLY created SUMMARY. The location of the group where you CREATE the summary determines its automatic association.

The group association of a newly created summary. The location of the group where you create the summary determines its automatic association.

A Data ITEM LINKED to the group data item. Associated data item suppress duplicate data VALUES but do not generate a CONTROL break. The associated column DISPLAYS only one data values for the group with which it is associated.

A Data Item linked to the group data item. Associated data item suppress duplicate data values but do not generate a control break. The associated column displays only one data values for the group with which it is associated.

The uses of ALIAS Table are:

• To resolve the LOOPS.
• To create self-joins with in a table.
• To provide ALTERNATE join STRUCTURE

The uses of Alias Table are:

An alternative NAME for a table GENERALLY USED in SELF joins.

An alternative name for a table generally used in self joins.

• A Loop is a CLOSED path which is resulted due to joins.
• A Loop causes PERFORMANCE degradation of query execution and wrong data will be displayed in the REPORT.
• A Loop can be resolved by CREATING the SHORT cuts (Alias).

In the report studio we can find TWO types of filters:

1. TABULAR Filters:- These filters are two types

• a. SUMMARY Filters
• b. DETAILED Filters

2. Grouped Filter

In the report studio we can find two types of filters:

1. Tabular Filters:- These filters are two types

2. Grouped Filter

An EXPRESSION that yields a Boolean value. Conditions are USED in query expressions, query filters, and Boolean REPORT variables that can be used for CONDITIONAL formatting, styles, data sources, layouts and blocks.

An expression that yields a Boolean value. Conditions are used in query expressions, query filters, and Boolean report variables that can be used for conditional formatting, styles, data sources, layouts and blocks.

A FILTER is a CONDITION, which RESTRICTS the AMOUNT of data displayed in the report.

A filter is a condition, which restricts the amount of data displayed in the report.

• A filter is a condition used to RESTRICT the DATA DISPLAYED in the Report.
• MODEL filter are reusable.

In framework manager we can CREATE TWO types of filters.

• STAND ALONE Filters.
• Embedded Filters.

In framework manager we can create two types of filters.

It IDENTIFIES the intended USE for the data represented by each query item.

It determines the aggregation RULES of query ITEMS and calculations.

The different USAGE property settings are:

•  Identified
•  Fact
• Attribute
•  Unknown

It identifies the intended use for the data represented by each query item.

It determines the aggregation rules of query items and calculations.

The different usage property settings are:

A Macro is a run time object, which USES the parameter maps and SESSION PARAMETERS in developing the conditional QUERY subjects.

A Macro is a run time object, which uses the parameter maps and session parameters in developing the conditional query subjects.

• MACRO :- To MODIFY DYNAMICALLY
• DIRECTLY

HTML, PDF, CSV, and XML.

HTML, PDF, CSV, and XML.

• A PARAMETER Map is a key value pair used in creation of conditional Query SUBJECTS.
• A Parameter map sub situates the values at the query at RUNTIME.

In Cognos "Framework Manager" a PROJECT can be created from MULTIPLE databases. The databases can be EITHER homogeneous or hetrogeneous.

In Cognos "Framework Manager" a Project can be created from multiple databases. The databases can be either homogeneous or hetrogeneous.

A NEW QUERY Subject can be created from the following sources:

• Model (Query SUBJECTS & Query Items)
• Data Sources (TABLES and Columns)
• Stored Procedure.

A new Query Subject can be created from the following sources:

• SUMMARIZE EXISTING detail values predefined summary FUNCTIONS (such as sum, avg)
• Create new report items using DATA from existing report items.
• Use model calculations PROVIDED in the package.

ACCORDING to the report requirements derive the new Items with the help of existing Query Items. This process is known as SCRUBBING at PROJECT LEVEL.

According to the report requirements derive the new Items with the help of existing Query Items. This process is known as Scrubbing at Project level.

A defined GROUP of users with the same data ACCESS needs PRIVILEGES and restrictions.

A defined group of users with the same data access needs privileges and restrictions.

To apply privileges and RESTRICTIONS for a USER class. Governor settings are used to set restrictions on queries by user class, such as

1. Sorting on non-indexed columns
2. Outer joins
3. Suppress duplicates
4. Cross-product queries
5. Retrieval of large text items
6. Number of records
7. Number of tables
8. QUERY execution TIME

To apply privileges and restrictions for a user class. Governor settings are used to set restrictions on queries by user class, such as

By SETTING GOVERNORS we can RESTRICT the TABLES.

By setting governors we can restrict the tables.

A query Item maps to columns to the DATABASE table. A Query SUBJECT contains Query ITEMS.

A query Item maps to columns to the database table. A Query Subject contains Query Items.

• DEFAULT DATA source query SUBJECTS
• MODEL Query Subjects
• Stored Query subjects

There are TWO types of query processing:

Limited Local: The database server does as much of the SQL processing and Execution as possible. HOWEVER, some REPORTS or report SECTIONS use local SQL processing.

Database only: The database server does all the SQL processing and execution with the exception of tasks not SUPPORTED by the database. An error appears if any reports of report sections require local SQL processing.

There are two types of query processing:

Limited Local: The database server does as much of the SQL processing and Execution as possible. However, some reports or report sections use local SQL processing.

Database only: The database server does all the SQL processing and execution with the exception of tasks not supported by the database. An error appears if any reports of report sections require local SQL processing.

Pass-Through SQL lets you use native SQL without any of the restrictions the data SOURCE imposes on sub queries.

ADVANTAGES:

You can ENTER any SQL SUPPORTED by the DATABASE.

Disadvantages:

There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source.

Pass-Through SQL lets you use native SQL without any of the restrictions the data source imposes on sub queries.

Advantages:

You can enter any SQL supported by the database.

Disadvantages:

There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source.

Native SQL is the SQL, the data source uses, such as Oracle SQL, but you cannot uses Native SQL in a QUERY subject that references more than one data source in the project.

ADVANTAGES:

• PERFORMANCE is optimized across all related query SUBJECTS.
• You can use SQL that is specific to your database.

Disadvantages:

• You cannot use SQL that the data source does not support for sub queries.
• The query subject may not work on different database type.

Native SQL is the SQL, the data source uses, such as Oracle SQL, but you cannot uses Native SQL in a query subject that references more than one data source in the project.

Advantages:

Disadvantages:

By default Cognos FRAME work manager uses Cognos SQL to create and edit Query subjects.

ADVANTAGES:

• Can contain metadata from multiple data sources.
• Have fewer database RESTRICTIONS
• Interact more effectively with Cognos applications.

Disadvantages:

You can not enter NONSTANDARD SQL.

By default Cognos Frame work manager uses Cognos SQL to create and edit Query subjects.

Advantages:

Disadvantages:

You can not enter nonstandard SQL.

SQL is the INDUSTRY language for creating, UPDATING and querying RELATIONAL DATABASE management system. Types of SQL.

• Cognos SQL
• Native SQL
• Pass-through SQL.

SQL is the industry language for creating, updating and querying relational database management system. Types of SQL.

• Apply or embed a FILTER
• Apply or embed a calculation
• Insert a Macro
• Insert a data source reference.
• Change the SQL TYPE.
• Change how SQL is GENERATED.

These all are we can find it in “Edit definition WINDOW”.

These all are we can find it in “Edit definition window”.

During the initial METADATA import OPERATION, a default DATA source query subject is created for each object you select (for example table) and creates the default relationships between query subjects for you AUTOMATICALLY.

During the initial metadata import operation, a default data source query subject is created for each object you select (for example table) and creates the default relationships between query subjects for you automatically.

DATA SOURCE query SUBJECTS contain SQL statements the directly reference data in a single data source. Frame work manager AUTOMATICALLY creates a data source query subject for each table and view that you import into model.

Data Source query subjects contain SQL statements the directly reference data in a single data source. Frame work manager automatically creates a data source query subject for each table and view that you import into model.

A DESCRIPTION of the DATA to be RETRIEVED from a DATABASE.

A description of the data to be retrieved from a database.

The types of Facts are:

ADDITIVE Facts: - A Fact which can be SUMMED up for any of the dimension available in the Fact Table.

Semi-Additive Facts: - A Fact which can be summed up to a few DIMENSIONS and not for all dimensions and not for all dimensions available in the Fact Table.

Non-Additive Fact: - a fact which cannot be summed up for any of the dimensions available in the Fact Table.

The types of Facts are:

Additive Facts: - A Fact which can be summed up for any of the dimension available in the Fact Table.

Semi-Additive Facts: - A Fact which can be summed up to a few dimensions and not for all dimensions and not for all dimensions available in the Fact Table.

Non-Additive Fact: - a fact which cannot be summed up for any of the dimensions available in the Fact Table.

A FACT Table is a table that contains summarized NUMERICAL (FACTS) and historical DATA. This Fact Table has a foreign KEY – primary key relation with a dimension table.

A Fact Table is a table that contains summarized numerical (facts) and historical data. This Fact Table has a foreign key – primary key relation with a dimension table.

The DIMENSIONS which are REMOVABLE and FIXED in NATURE.

The Dimensions which are removable and fixed in nature.

DIMENSIONS are CATEGORIES by which SUMMARIZED DATA can be VIEWED.

Dimensions are categories by which summarized data can be viewed.

A model in Frame work manager is a BUSINESS PRESENTATION of the structure of the data from one or more DATABASES.

A model in Frame work manager is a business presentation of the structure of the data from one or more databases.

• A Model
• Namespaces
• DATA sources
• PARAMETER MAPS
• PACKAGES
• Folders
• Query Subject
• Query ITEM
• Relation ship

To transfer all or PART of a FRAMEWORK Manager model to the Cognos connection, so that report AUTHORS can USE it.

To transfer all or part of a Framework Manager model to the Cognos connection, so that report authors can use it.

When we work with a framework manager you work in a project.

Project is a set of metadata organized for Report AUTHORS according to the Business rules and Model

A Project created APPEARS as folder, which CONTAINS following files.

• Project Name .CPF (Cognos Project File)
• Model .XML
• Preferences .XML
• Custom DATA .XML
• archive-log.xml
• log.xml
• session-log.xml
• session-log-backup.xml
• IDLog.xml

The files in the folder are unique to that Project.

When we work with a framework manager you work in a project.

Project is a set of metadata organized for Report Authors according to the Business rules and Model

A Project created appears as folder, which contains following files.

The files in the folder are unique to that Project.

DATA about data is CALLED as METADATA. The Metadata CONTAINS the DEFINITION of a data.

Data about data is called as Metadata. The Metadata contains the definition of a data.

A function SET is a COLLECTION of vendor specific DATABASE.

The EXPRESSION editor LISTS the function sets for all available vendors. However, you can restrict the function sets, so that it lists only the vendors that you want to use in your project.

A function set is a collection of vendor specific database.

The Expression editor lists the function sets for all available vendors. However, you can restrict the function sets, so that it lists only the vendors that you want to use in your project.

The Presentation layer makes it easier for report AUTHORS to find and UNDERSTAND their DATA. The Presentation layer is made up primarily of MODEL QUERY subjects that you create.

The Presentation layer makes it easier for report authors to find and understand their data. The Presentation layer is made up primarily of model query subjects that you create.