Part VII

Building Reports with Pluggable Data Sources

This part introduces reports that use data sources other than the SQL data source accessing relational data in an Oracle database. These reports use data sources available with Oracle Reports or combine information from one or more of these data sources to publish meaningful information.

This part contains the following chapters:

• Chapter 44, "Building a Report with an XML Pluggable Data Source"

A report with an XML pluggable data source enables you to connect to any data source that is available with Oracle Reports, for example XML data. Usage of alternate data sources is possible due to the pluggable data source (PDS) architecture of Reports Builder.

• Chapter 45, "Building a Report with a Text Pluggable Data Source"

A report can contain a text pluggable data source, such as a report that uses character-delimited text as a data source.

• Chapter 46, "Building a Report with an OLAP Pluggable Data Source"

Using the OLAP data source, you can create a report based on data in Oracle OLAP, the multidimensional data model in the Oracle database. You can, for example, create a Web and paper layout that analyzes data from OLAP to compare budgets to actual costs incurred.

• Chapter 47, "Building a Report Using Oracle Express Data"

For customers using the predecessor product to Oracle OLAP, Oracle Express, Oracle Reports provides a data source you can use to access data in this multidimensional database for reporting.