different aggregation functions for on measure 
Author Message
 different aggregation functions for on measure


we need 2 different aggregation functions in one dimension.
on the lowest level we use max() and on the next higher level sum() in one

we tried custom rollup formula and unary op, to override the max() aggregation
with sum() aggregation on the higher level.
both works, but the aggregations are seem to be performed at query time and not
stored as a precalculated aggregation.

is this correct?

because of performance reasons, we must store precalculated aggregations. is
there any other solution we could try?

Thanks for help.

Sat, 15 Nov 2003 14:34:38 GMT
 [ 1 post ] 

 Relevant Pages 

1. Analysis Services - Create Different Aggregation Rules for Different Measures

2. AnalysisServ-Different Aggregation Rules for Different Measures

3. MDX - Different aggregation methods in different dimensions

4. Different rollup for different measures

5. different dimension for different measure in one cube

6. calculated measure: different calculation at different levels

7. Aggregation takes long time with DISTINCT COUNT measure

8. date aggregation for duration measure

9. Question on Measures Aggregation

10. Measure Aggregation - Distinct Count

11. Aggregation on calculated measures ?

12. Conditional calculated measure, plus aggregation

Powered by phpBB® Forum Software