SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Average of Children Expand / Collapse
Author
Message
Posted Monday, November 16, 2009 2:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 1:48 AM
Points: 284, Visits: 506
I have a cube that I am using for testing. I need to provide MIN, MAX, Average for a particular value. In the measures I have selected the column as a measure three times. The first I have set to Average of child on the aggregation property, the second to Max, the third to Min. The Min works and returns the smallest of the ten values preseent fo the particular slice. The Max worksm however the Average of Children returns the sum of all children?

Any pointers gratefully received.
Ells
Post #819256
« Prev Topic | Next Topic »


Permissions Expand / Collapse