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

Chapter 3. Multiple Data Sources

We met the Data Model Editor in the previous chapter. The editor's interface deals with all the components and functionalities needed for the data model to achieve the structure you need. However, the main component is Data Set. In BIP, to create your data model structure you can choose from a variety of data set types:

  • SQL Query
  • MDX Query
  • Oracle BI Analysis
  • View Object
  • Web Service
  • LDAP Query
  • XML file
  • Microsoft Excel file
  • Oracle BI Discoverer
  • HTTP

Taking advantage of this variety requires multiple Data Sources of different types to be defined in the BIP. In this chapter, we will see:

  • How data sources are configured
  • How the data is retrieved from different data sets
  • How data set type characteristics and the links between elements ...

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