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 providers80
For example, Paul might also have an address in London, which means that there is no
unique ‘Paul’ row with which WebIntelligence can synchronize Paul’s age:
If the relationship between Customer and Address is one-to-one, WebIntelligence can
ignore Address in the synchronization. This removes the ambiguity::
Previous versions of WebIntelligence, as well as Desktop Intelligence and BusinessObjects,
allow a one-to-many relationship between dimensions and details. If you migrate a report
created using any of these products and the detail object contains multiple values, Web
Intelligence places the #MULTIVALUE error in the detail cell.
You can solve this in Web Intelligence XI R2 by checking the Avoid Duplicate Row
Aggregation property.
For more information on working with variables, see ”Creating, editing, and deleting
variables” on page 343.
Filtering merged dimensions
Merging dimensions has implications for the way in which Web Intelligence applies filters.
Note: You cannot apply a filter a on merged dimension. You apply filters on the
dimensions that make up the merged dimension.
Report filters and merged dimensions
When you apply a report filter to a dimension that is part of a merged dimension, Web
Intelligence applies the filter to all data providers that are synchronized through the
merged dimension.
Customer Address Age
John London
Paul Paris
Paul London
John 25
Paul 28
Customer Address Age
John London 25
Paul Paris 28