In: Computer Science
Consider the STAR schema with dimensions Customer, Product, and Time. The fact table has a measure called Purchase_Price. This measure is:
- additive
-non-additive
-semi-additive
There are three types of facts:
1) Additive
They are facts that can be summed up through all of the dimensions in the fact table.
2) Non-additive
They are facts that cannot be summed up for any of the dimensions present in the fact table.
3) Semi-additive
They are facts that can be summed up for some of the dimensions in the fact table, but not the others.
Answer:
In this scenario, the dimensions are customer, product and time. The fact table has measure Purchase_Price.
This measure is additive because one can sum up this fact along few of the dimensions.
Explanation:
Summing the purchase price for all customers will provide information about the total cost of sales procured by the customers..
Summing the purchase price for all products will provide insight about the sales cost for the products.
Summing the purchase price for time (like a week or month or year) will provide information about the purchase for the duration.