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

Building Reports Using the Web Intelligence Java Report Panel 79
The block is different in Desktop Intelligence/BusinessObjects because BusinessObjects
extends the values of the Country of Origin dimension through the values returned by the
Revenue measure.
You can alter the Web Intelligence default behavior so that it corresponds with Desktop
Intelligence/BusinessObjects behavior in this situation.
Extending dimension values in Web Intelligence
To extend dimension values in Web Intelligence:
1. Right-click your report outside any blocks or charts and select Document Properties
on the shortcut menu.
The Document Properties pane appears on the right side of the report.
2. Check the Extend merged dimension values option.
Detail objects and merged dimensions
Detail objects are associated with dimensions and provide additional information about
the dimension. (For more information on detail objects, see ”What types of objects can
you use in a query?” on page 35.)
Web Intelligence XI R2 requires a one-to-one relationship between dimensions and details
(this means that a detail object can have one value only for each value of its associated
dimension) and does not take detail objects into account when synchronizing data. The
following example illustrates why this is necessary.
Example: Synchronizing data providers with detail objects
In this example you have two data providers as follows:
If you create a merged Customer dimension to synchronize the data providers, and
Address can have more than one value for each customer, the result is ambiguous because
there is no common value around which WebIntelligence can synchronize the data:
Customer Address Revenue
John London 10,000
Paul Liverpool 15,000
Customer Age
John 25
Paul 28