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

Performing On-Report Analysis with Web Intelligence 223
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 223.
1. Create the variable formula in the Formula box by typing or double-clicking objects,
functions and operators.
NOTE: If you selected a cell that already contained a formula, the cell formula
appears in the Formula box.
2. Click OK.
The variable appears in the list of report variables. in the Left Pane under the Variables
folder.
You can now use the variable in your report just as you do with ordinary report
objects.
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), but Desktop Intelligence
documents allow a one-to-many relationship.
If a detail contains more than one value for one value of the dimension (which might be the
case in a document migrated from Desktop Intelligence), it returns the #MULTIVALUE error
when placed in the same block as the dimension.
Detail Provides descriptive data about a
dimension. A detail is always attached to
the dimension for which it provides
additional information. For example,
Age is a detail object that is associated
with Customer dimension. Address
provides additional information on
customers.
Measure Retrieves numeric data that is the result of
calculations on data in the database. For
example; Revenue is the calculation of
the number of items sold multiplied by
item price. Measure objects are often
located in a Measures class.
Table 0.1:
Object Description