Creating a Data Set Using an Oracle BI Analysis

If you have enabled integration with Oracle Business Intelligence, then you can access the Oracle Business Intelligence Presentation catalog to select an Oracle BI analysis as a data source.

An analysis is a query against an organization's data that provides answers to business questions. A query contains the underlying SQL statements that are issued to the Oracle BI Server.

For more information about creating analyses, see User's Guide for Oracle Business Intelligence Publisher.

Note:

Hierarchical columns are not supported in BI Publisher data models.

  1. Click the New Data Set toolbar button and select Oracle BI Analysis.
  2. In the New Data Set - Oracle BI Analysis dialog, enter a name for this data set.
  3. Click the browse icon to connect to the Oracle BI Presentation Catalog, as shown below.
  4. When the catalog connection dialog launches, navigate through the folders to select the Oracle BI analysis to use as the data set for the report.
  5. Enter a Time Out value in seconds, as shown below. If BI Publisher has not received the analysis data after the time specified in the time out value has elapsed, then BI Publisher stops attempting to retrieve the analysis data.
  6. Click OK.

Additional Notes on Oracle BI Analysis Data Sets

Parameters and list of values are inherited from the BI analysis and they display at run time.

The BI Analysis must have default values defined for filter variables. If the analysis contains presentation variables with no default values, it is not supported as a data source by BI Publisher.

If you want to structure the data based on Oracle BI Analysis Data Sets, the group breaks, group filters, data links and group-level functions are not supported.

The following are supported:

  • Global level functions

  • Setting the value for elements if null

For more information about the above supported features, see Structuring Data.