'example for semi-additive fact

I'm trying to find real-time examples for semi-additive facts other than "date dimension" example.

i.e. measures can be summed up across all dimensions except time.

I'm looking for semi-additive fact example where measure cannot be summed up across dimension other than time.

Thanks in advance.

-Ash

data-warehouse


Solution 1:[1]

You can aggregate department headcounts to give an organization total, but you cannot aggregate them over time, so the Sales department headcount for March 31 maybe 20 employees, and for April 30 the headcount maybe 23, but that does not mean that the total headcount at the end of April is 43

Solution 2:[2]

  1. Quantity on hand
  2. End of the month balance
  3. Inventory of a good
  4. Number of employees
  5. Insurance policies

refer: https://community.pyramidanalytics.com/t/q5m1dp/calculating-semi-additive-measures-in-bi-office#:~:text=Semi%2Dadditive%20measures%20are%20values,add%20them%20up%20over%20time.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 user11886195
Solution 2 Swati Baikar

Related Questions