Aggregating using Max -
09-20-2004
, 07:03 AM
I would greatly appreciate any help or pointers with the following...
I have an Analysis Services database made up as follows..
Physical Cube 1:
Measure : Numerator
Dimensions: DimA, DimB, DimC, DimX
Physical Cube 2:
Measure: Denominator
Dimensions: DimA, DimB,DimC
Virtual Cube
Calculated Measures: RateA = Numerator/Denominator, MaxRateA =
Max([DimX.[Hour of Day].Children, RateA)
Dimensions: DimA, DimB, DimC, DimX
DimA, DimB and DimC are share between the two cubes and each has multiple
levels.
DimX has one level called [Hour of Day] in addition the "All" level.
So here is my question..
What I am trying to do is equivalent to what the "Max" Aggregate function
does for a physical measure by for the Calculated Measure MaxRateA. i.e. I
want to roll up MaxRateA over all of the dimensions of my virtual cube
rather than have it calculate the Max of the rolled up Numerator and
Denominator. |