 |
|
| Planning for SAS OLAP Cubes |
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.
| 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 |
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.