{"id":8803,"date":"2024-04-25T12:30:53","date_gmt":"2024-04-25T12:30:53","guid":{"rendered":"https:\/\/www.gologica.com\/elearning\/?p=8803"},"modified":"2025-04-07T12:55:28","modified_gmt":"2025-04-07T12:55:28","slug":"model-types-in-ibm-cognos","status":"publish","type":"post","link":"https:\/\/www.gologica.com\/elearning\/model-types-in-ibm-cognos\/","title":{"rendered":"Model Types in IBM Cognos"},"content":{"rendered":"

A model is a collection of metadata for one or more data sources which include physical information and business information. It entitles a variety of OLAP data sources. IBM Cognos software enables performance management on normalized and de-normalized relational data sources.<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n

\"\"<\/a><\/figure>\n

<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n

Types of Cognos<\/strong> <\/h2>\n<\/p>\n

Important types of Cognos reporting tools:<\/p>\n

Content Store:<\/strong><\/p>\n<\/p>\n

It is a set of database tables to store application data of the Cognos<\/em><\/strong><\/a> which are used by the Content Manager.<\/p>\n<\/p>\n

Content Manager:<\/strong><\/p>\n<\/p>\n

The Cognos manager assists you to manage storage from the content store database and retrieval of report specifications, configuration data, and published packages.<\/p>\n<\/p>\n

Cognos Content Database:<\/strong><\/p>\n<\/p>\n

Cognos content database is a self-contained database server that is used to host the content store database in demo environments when enterprise DMBS is unavailable.<\/p>\n

<\/p>\n

How to customize the Cognos Model<\/strong> <\/h2>\n<\/p>\n

When customizing a certain schema that includes additional metrics, attributes, or audience levels, a Unica reporting schema can edit the IBM Cognos model also it modifies the reporting view or tables that are based on that schema. Importing the additional items into the data model and using the Cognos Framework Manager<\/em><\/strong><\/a> features to query the views or tables. Updating the Cognos model which totally depends on the changes that have been made in the Unica reporting views or tables. To represent the associated views by updating the query object to import the new columns as well as by adding columns for attributes, metrics, or response types by modifying the existing views. In the case of modifying the overtime variations for performance or runtime reports or if you created new reporting schemas for all additional audience levels, you have added new views, there is a possibility of usage of the Framework Manager MetaData Wizard to import the views into the data model.<\/p>\n

<\/p>\n

There are 2 types of models in Cognos:<\/p>\n

1. Relational model<\/p>\n<\/p>\n

2. Dimensionally modeled relational source model<\/p>\n

<\/p>\n

1. Relational model:<\/strong> <\/h2>\n<\/p>\n

A relational model as a source is created from the relational database. This relational model supports ROLAP. The users cannot perform multi-dimensional analyses such as drill up and drill down analyses. To modify the data adapt a multi-dimensional analysis so that users can view the data at various levels of detail.<\/p>\n

<\/p>\n

The following are the multidimensional techniques:<\/p>\n

<\/p>\n

Drill down:<\/strong><\/p>\n<\/p>\n

Users can view the detailed information, As it is a process of navigating the data from the highest level to the lowest level details<\/p>\n

<\/p>\n

Drill up: <\/strong><\/p>\n<\/p>\n

Users can view the summary data, and it is a process of browsing the data from the lowest level to the highest level.<\/p>\n

<\/p>\n

2. DMR Model:<\/strong> <\/h2>\n<\/p>\n

This model as a source is created from a relational model. The DMR model is created with hierarchies. A hierarchy is an ordered series of related dimensions grouped together to perform multidimensional analysis. Between the levels, there is a multiple and too many relationships. DMR model is created with 2 types of dimensions.<\/p>\n<\/p>\n

Regular Dimension<\/p>\n

Measure Dimension<\/p>\n

<\/p>\n

1. Regular Dimension:<\/strong><\/p>\n


<\/strong><\/p>\n

A regular dimension is created with hierarchies. The regular dimension organizes the information in a hierarchy from the highest level of granularity to the lowest level. A hierarchy is an ordered list of levels. It usually contains multiple levels. It contains descriptive and business key information. Each level requires KEY and CAPTION Hierarchies for regular dimensions.<\/p>\n<\/p>\n

<\/p>\n

2. Measure Dimension:<\/strong><\/p>\n


<\/strong><\/p>\n

It is defined as a collection of facts. Can create a measure dimension for one or more query subjects that have a valid relationship between them. Model measure dimensions should be composed of only quantitative items. For example, Key performance indicators like Sales, Net profit.<\/p>\n

<\/p>\n

COGNOS Roles<\/strong>
<\/h2>\n<\/p>\n

Cognos Architect:<\/strong><\/p>\n

<\/p>\n

Architects are responsible to understand the metadata and security. Should report the requirement Templates. The pace at designing the interfaces of a project. In most cases, the tables which are in DWH are not directly used to generate the reports.<\/p>\n

<\/p>\n

Cognos Developer: <\/strong><\/p>\n

<\/p>\n

They create reports from the Model. Cognos<\/em><\/strong><\/a> is based on modern reporting technology<\/p>\n

In the concept of MRT, technical issues of database and organization structure are hidden from the end-user point of view.<\/p>\n

<\/p>\n

Features of IBM Cognos<\/strong>
<\/h2>\n

Important features of Cognos are as given below:<\/p>\n

<\/p>\n