HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Performing On-Report Analysis with Web Intelligence 59
6
Merging dimensions from multiple data
providers
Overview
This chapter describes how to synchronize multiple data providers in a Web Intelligence
report by merging them on common dimensions. After merging common dimensions you
can place dimensions from different data providers in the same block.
Merged dimensions and data synchronization are new in Web Intelligence XI R2. They
enormously increase the power and flexibility of Web Intelligence by allowing you to
synthesise data from different sources in the same report, rather than simply including the
data.
For example, if you have one database that contains detailed customer information and
another database that contains sales data, you can synchronize the two data sources
around the customer.
Note: This chapter provides basic information on merging dimensions in Web Intelligence
in HTML mode. For more detailed information on merged dimensions and synchronization,
see the “Merging Dimensions from Multiple Data Providers” chapter in the Building
Reports Using the Web Intelligence Java Report Panel Guide. You can also find further
information on the behavior of merged dimensions in the BusinessObjects Report
Conversion Guide.
Synchronizing data providers through merged dimensions
Web Intelligence allows you to synchronize multiple data providers in the same document.
This allows you to build reports which synchronize data from multiple sources. When you
synchronize queries through merging, you can include report objects from different queries
in the same report block.
To create a merged dimension
1. Select the group of dimensions from different data providers that you want to merge in
the Available Objects section of the Left Panel by holding down the Ctrl key as you
select the dimensions. (For information on creating documents that contain multiple
data providers, see the Building Queries Using Web Intelligence Query – HTML
guide.)
2. Click Merge at the top of the Left Panel.