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 ...