Creating Calculated and Restricted Key Figures

  To create or edit key figures:

1. Select Analysis Tools then, Calculated Key Figures

2. In Calculated Key Figures, select New or a key figure.

3. If creating a key figure, replace Untitled with a unique name.

4. Select a Function and related information.

   Note:

   Information requested differs depending on the function selected.

   Function	Measure	Cube Hierarchy
   Avg	x	x
   Var	x	x
   Max	x	x
   Median	x	x
   Min	x	x
   Sum	x	x
   Count		x

   Note:

   In the Selections box, you can only add members from the same hierarchy of a dimension

5. In Cube Hierarchy, double-click an entry to move it to Selections.

   Caution!

   Only one hierarchy can be used. If you attempt to select another hierarchy, Web Analysis asks if you want to remove all selections made on the other hierarchy.

6. Click OK to close Calculated Key Figures

7. In Key Figures Browser, select a key figure to move it to Selections and click OK.