O'Reilly logo

Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting by Daniela Bozdoc

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Sets

As you can see in the following screenshot, the available data set types are:

  • SQL Query
  • MDX Query
  • Oracle BI Analysis
  • View Object
  • Web Service
  • LDAP Query
  • XML file
  • Microsoft Excel File
  • HTTP (XML Feed)
Data Sets

To add a particular Data Set to your data structure, containing one of the types described in the previous screenshot, you first have to provide some parameters, which depending on the Data Set type, precisely identify your data.

Data Set types

Let's go through the steps required to add data sets of the most common types:

SQL query

To configure a SQL Query Data Set you have to enter the following, which is shown in the following screenshot:

  • Name: Data set ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required