Statistics Available for Measures

When you define a cube, you select the statistics that are used to calculate the cube's measures. Here is the list of available statistics.

Base Stored Statistics:

Count
Sum
Maximum
Minimum
Count of Missing Values
Uncorrected Sum of Squares

Derived Statistics:

Average
Range
Corrected Sum of Squares
Variance
Standard Deviation
Standard Error of Mean
Coefficient of Variance
T Value
Probability of Greater Absolute Value
Lower Confidence Limit
Upper Confidence Limit

New cubes that are based on a data source that contains existing summarized data must include measure statements for the stored statistics. Measure statements are required for each derived statistic that you want to create for the new cube. For example, if you want to calculate AVG, you must create measures for N and SUM, as well as AVG. The following table indicates which stored statistics are required for each derived statistic.

Stored Statistics Required for Derived Statistics

Derived Statistics	Required Stored Statistics
AVG	N, SUM
RANGE	MIN, MAX
CSS	N, SUM, USS
VAR, STD, STDERR, CV, T, PRT, LCLM, UCLM	N, SUM, USS