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 81
Example: Filtering a merged dimension
In this example you have a report with the following data providers, which are merged on
the Country dimension:
If you apply the filter
Country=”US” to the first block, Web Intelligence also filters the second
block to give the following result:
If the Country dimensions are not merged the second block is unaffected by the filter.
Section filters and merged dimensions
When a dimension that is part of a merged dimension is set as a section header, any filter
applied to the section also applies to blocks from synchronized data providers within the
section. If Country is set as the section header in the example ”Filtering a merged
dimension” on page 81 and the filter
Country=”US” is applied to the section, Web
Intelligence filters both blocks in the section—(Resort, Revenue) and (Country, Number of
Guests)—so that only those rows appear where the country dimension is equal to “US”,
even though Country in the second block comes from a synchronized data provider.
Block filters and merged dimensions
When you apply a block filter to a dimension that is part of a merged dimension, Web
Intelligence applies the filter to the block. Web Intelligence does not apply the filter to
other data providers synchronized through the merged dimension.
Drilling on merged dimensions
When you merge dimensions, the new merged dimension belongs to the hierarchies of all
dimensions involved in the merge.
Country Resort Revenue
France French Riviera 835,420
US Bahamas Beach 971,444
US Hawaiian Club 1,479,660
Country Future Guests
France 46
US 56
Country Future Guests
US 56