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 63
6
Including multiple data providers
Overview
This chapter tells you how you can include multiple data providers in a single document.
It includes the following information:
•
using multiple data providers
• defining multiple data providers in a document
• purging data from multiple data providers
Note: This chapter tells you how to add data providers to documents that already include
a first data provider. For information about creating new documents and building the first
data provider, see ”Building basic data providers” on page 33.
Using multiple data providers
You can include one or multiple data providers in a single Web Intelligence document.
When you include multiple data providers, those data providers can be based on a single
universe or on multiple universes available in InfoView.
Example: Include product sales data and customer data in the same document
In this example, your corporate data for product line sales is available on one universe
and data on customers is available on another universe. You want to present product line
sales results and information on customer age groups in the same report. To do this, you
create a single document that includes two data providers; one query on each universe.
You can then include and format results from both data providers on the same report.
The Data tab in Report View shows the two data
Query 1 - on the customer universe
Query 2 - on the product line sales universe