CODEWITHSUNDEEP
data-warehouse
Ash
Ash

Reputation: 1466

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

Upvotes: 2

Views: 3689

Answers (3)

Swati Baikar
Swati Baikar

Reputation: 1

  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.

Upvotes: 0

user11886195
user11886195

Reputation: 31

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

Upvotes: 3

Ron Dunn
Ron Dunn

Reputation: 3078

Account Balance ... Store Stock ... anything that has a "count" associated with it is typically semi-additive.

After "Rich"s helpful comment, I'll add some examples from the literature of measures that may not be additive across dimensions other than time.

  1. Christopher Adamson's book "Star Schema - The Complete Reference" quotes two examples on page 269 - (i) A sales_goal which can not be summed over sales plan versions; (ii) a budget_amount, which can not be summed across budget versions.

  2. Lawrence Corr's book "Agile Data Warehouse Design" uses the example of an order_count - page 245 - which would cause double-counting over levels in the Product hierarchy.

  3. Chapter 7 of Kimball Group's Data Warehouse Toolkit, 3rd Edition, discusses the issue of over-counting in some depth, in relation to budgetting.

You'll find links to these books on our data warehousing bookshelf, http://ajilius.com/bookshelf

Upvotes: 5

Related Questions