dbTalk Databases Forums  

Aggregating using Max

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Aggregating using Max in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Brian J. Burnett
 
Posts: n/a

Default 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.







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.