Skip to main content

Types of facts



Types of Facts:

1)Addictive Type:

Measurements in a fact table that can be summed up across all dimensions

Consider the following retail fact table:

Storekey Prodcode   TRNS-CODE                REVENUE

     S1           P1         27 AUG 2010                   100

     S2           P1          27 AUG 2010                   150

     S3           P1          27 AUG 2010                   300

     S1           P2          28 AUG 2010                   600

     S2           P2          28 AUG 2010                   300

     S1           P1          29 AUG 2010                   200

     S2           P2          29 AUG 2010                   100

     S3           P3          29 AUG 2010                   400

 

 Store wise sales           Daily sales      

S1   900                     27 Aug 2010             550

S2   550                     28 Aug 2010             900

S3   700                     29 Aug 2010             700

Product wise sales

P1          750

P2          1000

P3          400 

2)Semi Addictive Fact:

Measurements in a fact table that can be summed up across only few dimensions keys

Following table is used to record current balance and profit margin for each id at a particular instance of time (Day end)

Acct_Id        Trans_Dt      Curr_Bal       Profitmargin   

21653          27Aug09       80000        0.06

21654          27Aug09       120000             0.08

21653          28Aug09       22000        0.08

21654          28Aug09       48000        012

In the above table we can not sum up current balance across Acct Id

If we ask balance for Id 21653 we will say that

22000 not 22000+80000

 3)Non addictive fact:

Facts that can not be summed up across any

dimension key

Note: % are ratio columns are non addictive facts

 

4)Factless fact table:

A fact table without any measures is called

factless fact table

•       It contains only keys

•       It acts as bridge between dimension keys

Labels:

Comments

Post a Comment

Popular posts from this blog

Data modeling

Data Modeling: Model: Model is business representation of information in one or more data sources OLTP                                    DWH   Model          Model                 Model E-R Model    (modify wih ETL)       Dimensional model (Design based on              (Design based on facts and Measures) Entities&Relationships)   Dimensional Modeling: Is a design methodology for designing a DWH It consists of following 3phases to design the Database 1)Conceptual Modeling: •          Understanding the requirements •     ...
Post a Comment
Read more

FM workflow diagram

FM workflow process diagram: A windows based tool used to design metadata Models                        import Datasource------ à FM design and create the project Prepare the metadata project(Presentation layer)--Prepare  the project business view--Create & manage package---setup  security— Publish package---Content store(Metadata)---Reporting interface   Metadata source-Cognos Application •        Cognos impromptu •        Cognos 10.1 model •        Cognos Architect •        Decision stream •        Data Manager •        IBM Data Source   Third party metadata source: •        ERWIN •     ...
Post a Comment
Read more

Book on IBM Cognos 10 written by me-

Here is a book written by me on IBM Business Intelligence Tool COGNOS which is published at the following link- http://www.amazon.com/dp/B00KKSVGPA/ref=rdr_kindle_ext_tmb Anyone who is having prior knowledge in database like oracle can easily learn to develop the business reports by following the screenshot assisted examples. This book will be a good resource for the students who wish to self learn IBM Cognos software.
Post a Comment
Read more