Regular timing defines when then calculations are done. Example: calculate a ration of two measures.
after rollup -> first sum everything, then calculate the ratio (divide the two sums)
befor rollup -> first calculate all ratios and then sum them
Time state roll-up allows you to have a special roll-up for the time dimension (it is executed after all regular roll-ups). Example: you can sum measures over all dimensions but take the average over time.
Duplicates rollup is handy when you have 'duplicate' records i.e. records with the same dimension keys but different measures.
Example - a customer bought twice the same product in the same store on the same day
If you specify no duplicates roll-up, the regular roll-up will be applied. However, with duplicates roll-up you can specify a different behaviour for these duplicate records.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.