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

Merging dimensions from multiple data providers78
Web Intelligence cannot determine the number of sales per year for customer Jones
because the data provider that stores the number of sales does not break them down by
year. Web Intelligence therefore reproduces the total number of sales on each row.
Note: Although the Number of Sales values are duplicated, if you add a standard
calculation to the bottom of the column (for example a Sum or Average calculation), the
result is correct.
One way of adressing this issue is to add the dimensions to the second data provider that
allow Web Intelligence to calculate to the appropriate level of data. If this is not possible,
you must be aware of any situations where Web Intelligence cannot aggregate the data to
the necessary level of detail.
Extending the values returned by merged dimensions
Merged dimensions are a new concept in Web Intelligence XI R2. Synchronizing data
providers already exists in Desktop Intelligence/BusinessObjects but it does not involve the
creation of a new merged dimension. BusinessObjects reports use the original dimensions
that make up a merged dimension in Web Intelligence.
You can use these original dimensions in a Web Intelligence report. When you place them
in the report, Web Intelligence returns by default only those dimension values that have
corresponding values in the data providers synchronized through the merge. You need to
be aware of this when migrating reports from Desktop Intelligence and BusinessObjects
because BusinessObjects/Desktop Intelligence behaves differently.
Example: Web Intelligence and Desktop Intelligence/BusinessObjects behavior when
dimensions are merged
You have a report with the following data providers:
If you include the Country of Origin dimension from Data Provider 1and the Revenue
measure from Data Provider 2 in the same block, Web Intelligence returns the following
result:
The same block in Desktop Intelligence/BusinessObjects returns the following result:
Country of origin Revenue
Germany 470
Country of origin Revenue
Japan 499
Country of origin Revenue
Germany
Country of origin Revenue
Germany
Japan 499