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 77
Understanding the effects of merged dimensions
Data synchronization through merged dimensions adds enormous power to Web
Intelligence. Merged dimensions also have implications for the results that Web
Intelligence displays in certain situations. You need to understand these implications to
work effectively with merged dimensions and synchronized data.
The following sections describe these situations.
Synchronizing data providers with different aggregation levels
You can synchronize data providers with different aggregation levels. This can have
implications for the way in which Web Intelligence calculates measures.
Example: Synchronizing data providers with different aggregation levels
In this example you have two data providers as follows:
If you merge the two data providers and the table properties Avoid Duplicate Rows
Aggregation and Show Rows with Empty Dimensions are unchecked, Web
Intelligence returns the following:
(For more information on the Avoid Duplicate Rows Aggregation and Show Rows
with Empty Dimensions properties, see the Web Intelligence online help.)
Customer Year Revenue
Jones 2004 1,500
Jones 2005 2,000
Smith 2005 1,200
Customer Number of sales
Jones 12
Smith 10
Customer Year Revenue Number of
sales
Jones 2004 1,500 12
Jones 2005 2,000 12
Smith 2005 1,200 10