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

Multiple Data Sources

Having a large amount of data at your disposal for creating a Data Source necessitates a great effort in creating a good structure of data with the necessary relationships between its elements.

Here are some of the tools, provided by BIP 11g Data Model Editor to design links between elements in your Data Model structure.

Add different types of Data Sets to a Data Model

You will see how the structure of the Data Model changes, after different data connections (links) are created.

As shown in the following screenshot, the Data Sets added are:

  • Independent: An HTTP type Data Set
  • trend: An Oracle BI Analysis type Data Set
  • Sales: A XML file type Data Set
  • countries: A Microsoft Excel file type Data Set
  • reader, library, and book: SQL Query ...

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