Data Warehousing Community Forum
November 21, 2018, 02:16:01 am

Pages: [1]   Go Down
  Print  
Author Topic: semi-additive facts  (Read 1600 times)
tina
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: October 10, 2015, 12:05:28 pm »

Hi all,

There is a paragraph in Kimball group's website which suggested a method for designing a semi-additive fact.

(A good approach for non-additive facts is, where possible, to store the fully additive components  of the non-additive measure and sum these components  into the final answer set before calculating the final non-additive fact. This final calculation is often done in the BI layer or OLAP cube.)

h

Would you please assist me with explaining this idea in details? (if you implemented a real sample please let me know it's details)

Best Regards
Tina
Logged
advertisement
SuGoSu
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 5


View Profile
« Reply #1 on: November 05, 2018, 05:46:47 pm »

Yeah, it says to treat them just like any other attribute.
For instance, don't bother to average your price tag in your data warehouse layer. Do it on your BI tool instead.
Logged
Pages: [1]   Go Up
  Print  
Jump to: