Member Summaries

This list contains predefined functions that return either a single summary value for a set of members or a different summary value for each member of a set of members.

aggregate

Returns a calculated value using the appropriate aggregation function, based on the aggregation type of the expression.

aggregate ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
aggregate ( < currentMeasure | expr > within < detail | aggregate > expr ) 

average

Returns the average value of selected data items.

average ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
average ( < currentMeasure | expr > within < detail | aggregate > expr ) 

count

Returns the number of selected data items excluding NULL values.

count ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
count ( < currentMeasure | expr > within < detail | aggregate > expr ) 

maximum

Returns the maximum value of selected data items.

maximum ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
maximum ( < currentMeasure | expr > within < detail | aggregate > expr ) 

median

Returns the median value of selected data items.

median ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
median ( < currentMeasure | expr > within < detail | aggregate > expr ) 

minimum

Returns the minimum value of selected data items.

minimum ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
minimum ( < currentMeasure | expr > within < detail | aggregate > expr ) 

percentage

Returns the percent of the total value for selected data items.

percentage ( numeric_expr  [ tuple member_expr {, member_expr } ] within set set_expr  {, set_expr } ) 

percentage ( [gosales].[sales measures].[quantity] tuple [gosales].[Staff].[].[department]->[West] within set children([gosales].[Staff].[].[Staff] ) 

percentile

Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items.

percentile ( numeric_expr  [ tuple member_expr {, member_expr } ] within set set_expr  {, set_expr } ) 

quantile

Returns the rank of a value for the specified range. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest).

quantile ( numeric_expr, numeric_expr  [ tuple member_expr {, member_expr } ] within set set_expr  {, set_expr } ) 

quartile

Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values.

quartile ( numeric_expr [ tuple member_expr {, member_expr } ] within set set_expr  {, set_expr } ) 

rank

Returns the rank value of selected data items. The type of ranking returned (Olympic, dense or serial) is data source dependent. The sort order is optional; DESC is assumed by default.

rank ( numeric_expr [ ASC | DESC ] [ tuple member_expr {, member_expr } ] within set set_expr  {, set_expr } ) 

rank  ( [gosales].[sales measures].[quantity] tuple [gosales].[Staff].[].[department]->[West] within set children([gosales].[Staff].[].[Staff] ) 

standard-deviation

Returns the standard deviation of selected data items.

standard-deviation ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
standard-deviation ( < currentMeasure | expr > within < detail | aggregate > expr ) 

total

Returns the total value of selected data items.

total ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
total ( < currentMeasure | expr > within < detail | aggregate > expr ) 

variance

Returns the variance of selected data items.

variance ( < currentMeasure | expr > within set set_expr { , set_expr } ) 
variance ( < currentMeasure | expr > within < detail | aggregate > expr )