Measure or Fact Table
Fact tables contain measurements of individual business processes.
It contains two sections in the table
(a) Foreign Keys to Dimensions
(b) Facts or Measures
Fully Additive Facts:
It can be summarized across any and all dimensions information stored in Fact Table.
Example:
Revenue Quantity
Semi Additive Facts:
Semi Additive Facts are Facts that can be summed up for some of the dimensions in the Fact Table.
Example:
Inventory Quantities can be summed up through the model and Dealer dimension but not through the Time Dimension
Non Additive Facts:
Non Additive Facts are Facts that cannot be summed across any dimensions in the Fact Table.
All Ratios are Non Additive Facts.
Example:
In the below Diagram shows Margin rate is non additive.
Margin rate=Margin_Amount / Revenue
Fact less Fact Table:
A Fact Table contains no measures or facts that type of Facts are known as Fact less Fact Table. Sometimes store a “1” for convenience.
Example:
A fact table which has only key elements is a fact less fact. There are no measures in this table
Fact tables contain measurements of individual business processes.
It contains two sections in the table
(a) Foreign Keys to Dimensions
(b) Facts or Measures
Fully Additive Facts:
It can be summarized across any and all dimensions information stored in Fact Table.
Example:
Revenue Quantity
Semi Additive Facts:
Semi Additive Facts are Facts that can be summed up for some of the dimensions in the Fact Table.
Example:
Inventory Quantities can be summed up through the model and Dealer dimension but not through the Time Dimension
Non Additive Facts are Facts that cannot be summed across any dimensions in the Fact Table.
All Ratios are Non Additive Facts.
Example:
In the below Diagram shows Margin rate is non additive.
Margin rate=Margin_Amount / Revenue
Fact less Fact Table:
A Fact Table contains no measures or facts that type of Facts are known as Fact less Fact Table. Sometimes store a “1” for convenience.
Example:
A fact table which has only key elements is a fact less fact. There are no measures in this table
simple and clear.Keep updating MSBI online training Bangalore
ReplyDeleteToo good article,Thank you for sharing it,,,
ReplyDeletekeep updating...
MSBI Online Training Hyderabad
nice information thanks for sharing.......!
ReplyDeletemsbi course training
The explanation of fact and measure types is exceptional. It offers a comprehensive understanding without overwhelming technical jargon. The Future Of Cybersecurity Predictions And Emerging Trends This clarity helps people.
ReplyDelete