HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Saving formulas as variables346
5. If you select Detail, an Associated Dimension box appears. Click ... next to the box
to open the Objects and Variables dialog box and select the dimension you want to
associate with the detail.
(For more information on associating details with dimensions, see ”Associating details
with dimensions” on page 346.)
6. Click OK.
The variable appears inside the Variables folder on the Data tab.
Associating details with dimensions
A detail object is an object that provides additional information about a dimension. For
example, if you have a Customer and Customer Name objects, you can associate
Customer Name as a detail of Customer. Web Intelligence requires a one-to-one
relationship between a dimension and its associated detail(s). If a detail contains more
than one value for one value of the dimension, it returns the #MULTIVALUE error when
placed in the same block as the dimension.
The behavior of detail objects Web Intelligence
Editing and deleting variables
After you have created a variable you can edit it or delete it.
Editing a variable
To edit a variable:
1. Select the variable in the list of report variables.
2. Click the right mouse button and click Edit Variable on the shortcut menu.
The Variable Editor appears.
3. Edit the variable.
4. Click OK to save the new variable definition.
The variable is saved in the document. You can include the variable in any of the
reports within the same document.
Deleting a variable
To delete a variable:
1. Select the variable in the list of report variables.
2. Click the right mouse button and click Delete Variable on the shortcut menu.
Using variables to simplify formulas
If a formula is complex you can use variables to simplify it. By using variables you break a
complex formula down into manageable parts and make it much easier to read, as well as
making building formulas much less error-prone.
You can use previously-created variables in a formula in exactly the same way as you use
other report objects. Variables appear in the formula editor under the “Variables” folder.