Dimensions & OLAP Types in Cognos

 Conformed Dimensions

It is a dimension which is shared by multiple fact tables

Ex: customer dimension, time dimension

Fact Constellation

It is a process of connecting multiple fact tables with PK-FK relationship

Slowly changing dimension (SCD)

A slowly changing is a dimensions which captures the changes occurs over a period of time

There are three types of SCD’

SCD type1

SCD type 2

SCD type3

SCD type 1

It contain only current data

SCD type 2

It maintain couple history and current data

SCD type 3

It maintain partial history (or) recent history and current data

Surrogate key

It is a system generated key which access primary key in the dWH tools maintains the uniqueness.

Interested in mastering Cognos Training? Enroll now for FREE demo on cognos online classes

OLAP and types of OLAP

OLAP

It is a interface (or) a gate way between the user and data source (dWH)

(or)

It is a set of specifications with allows the client application (report application) to query the data from data source and displays the data and to report

Types of OLAP

DOLAP (desk top)

ROLAP (relational)

MOLAP(multi dimensional )

HOLAP(hybrid)

DOLAP

It is a OLAP used to query the data from desktop database like Dbase, fox, ms access, ckpper. While generating the report online

ROLAP

It is used to query the data from multidimensional source like cube and DMR model (dimensional relational model) to perform multidimensional analysis.

Multi dimensional analysis

It is a process of viewing the data at different levels of details

  • Use the following features to perform multidimensional analysis
  • Drill up:
  • Navigating from lowest level to highest level
  • Drill down:
  • Navigating from highest level to lowest level

HOLAP

It is a combination of both ROLAP and HOLAP it can query the data from the relational sources as well as multi dimensional sources like cognas.

Phases in dimensional modeling

Conceptual modeling

Logical modeling

Physical modeling

Conceptual modeling

In conceptual modeling face, database models conform or decide the dimensional tables and fact tables required for a particular data ware house design.

Logical modeling

In logical modeling database modelers start creating relation between the tables logically

Physical modeling

In physical modeling database modelers creates dimensional tables and fact with relations physically in the database

Interested in mastering Cognos Training? click the linkcognos training online

Comments

Post a Comment

Popular posts from this blog

Advanced Techniques for cognos TmI Scripting

Image
In this lesson, we will discuss Advanced Techniques for TI Scripting Techniques for TM1 TurboIntergrator Scripting ETL Most applications built with Cognos TM1 require some way to perform data ETL which is an acronym for extract, transform, and load. It is a process that involves extracting data from an outside source, transforming it into some form to fit an operational need, and then loading that newly formatted data into a target. OnlineItguru  provides career-oriented  cognos tm1 training​  in order to help you move ahead in your career. TM1 TurboIntergrator review TM1 TurboIntegrator is the programming or scripting tool that allows you to automate data importation, metadata management, and many other tasks. Within each process, there are six sections or tabs. They are as follows: Data Source Variables Maps Advanced Schedule The Data Source tab You use the  Data Source  tab to identify the source from which you ...
Read more

Explain about Cognos TM1 feeders

Image
 The IBM Cognos TM1 calculation engine uses FEEDERS to help manage sparsity in cubes with SKIP CHECK enabled. There may be rule calculations for certain cubes, but they are extremely small or dense and may not need SKIP CHECK,More info go through Cognos TM1 Course . Feeders FEEDERS classify the cells in a cube which may contain a measured value based on a rule and ensure that these values are included in the calculation of the aggregation. SkipCheck SKIP CHECK is a keyword entered at the top of a rule file that makes the sparse data consolidation algorithm of TM1 possible. Usually, cubes using SKIP CHECK would require FEEDERS, another keyword entered in a rule file later on. For more on SKIP CHECK, please refer to section 2.3. Why FEEDERS for use? OLAP cubes can be very sparsely populated as it is very important to handle data within TM1 cubes. Examples of problems facing the construction of the TM1 Cubes are below. Example 1- Cube Sales Take a sales cube with the following dimens...
Read more

Cognos TM1 rules editor

Image
  Using the rules of TM1, you can do the following. To calculate totals based on business rules, perform multiplication of cells. Override automatic consolidation of TM1 when necessary. Using data in one cube to measure or exchange data between cubes in another cube. Allocate the same values for multiple cells,More info go through  Cognos tm1 course  Blog. Cognos TM1 rules editor If you try to use the Rules Editor while .Net 3.5 SP1 is not properly enabled, errors can occur. You may use TM1 Server Explorer to access the Rules Editor. Right-click on the cube (the cube for which you want to define a rule) and select Build Rule from the menu If there are no rules associated with this cube already. If one or more rules already exist for this cube, you can pick Edit Rule. Upon savin g  the rules file, TM1 rules are compiled one by one. When it finds the first rule compilation error, TM1 ceases compiling rules. Compilation of Cognos TM1 For instance, you would perform the ...
Read more