Data warehousing - Define non-additive facts

Define non-additive facts.

The facts that can not be summed up for the dimensions present in the fact table are called non-additive facts. The facts can be useful if there are changes in dimensions. For example, profit margin is a non-additive fact for it has no meaning to add them up for the account level or the day level.

Define non-additive facts.

Non additive facts are facts that cannot be summed up for any dimensions present in fact table. This means that these columns cannot be added for producing any results.
Data warehousing - Define BUS Schema
Define BUS Schema - A BUS schema is to identify the common dimensions across business processes......
Data warehousing - List out difference between SAS tool and other tools.
Difference between SAS tool and other tools - The differences between SAS and other tools are......
Data warehousing - Why is SAS so popular?
Why is SAS so popular? - Statistical Analysis System is an integration of various software products which allows the developers to perform......
Post your comment