HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Saving formulas as variables222
To create a variable using the Create New Variable dialog box:
1. Select the cell where you want to create the variable, or make sure that no cell is
selected.
2. Click Create a variable.
The Create Variable dialog box appears.
If you had selected a cell, the current cell formula appears in the Formula box. If not,
the Formula box is blank.
NOTE: The Create a variable button is available on the Formula toolbar when
you select a cell that does not already contain a variable or when no cell is
selected.
3. Type the variable name in the Name box.
4. Select the variable type by selecting Dimension, Measure or Detail.
The following table describes the differences between these variable types:
Table 0.1:
Object Description
Dimension Retrieves the data that will provide the
basis for analysis in a report. Dimension
objects typically retrieve character-type
data, for example; customer names, line
names, or dates.