Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ROLLUP
- Thread starter cogdev
- Start date
schampheleer
IS-IT--Management
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
day1 cust1 store1 prod1 5
day1 cust1 store1 prod1 10
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.
HTH,
Willem
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
day1 cust1 store1 prod1 5
day1 cust1 store1 prod1 10
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.
HTH,
Willem
- Status
