Book Image

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

By : Daniela Bozdoc
Book Image

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

By: Daniela Bozdoc

Overview of this book

<p>Oracle BI Publisher 11g (formerly XML Publisher) enables the creation, management and delivery of various reports, making it a desirable tool for any company to achieve the best image of your resources. This book offers practical application of BIP functionality for improving your ability to design and deliver quality reports just when they are needed.<br /><br />“Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting” is an applicable guide for using Oracle BIP from the perspective of a report developer, helping you to utilize the tool from simple to complex report design. You can take advantage of both the existing functionality of BIP 10g, as well as a special emphasis on the new 11g features.<br /><br />This guide will take you on a tour of Oracle BI Publisher 11g, beginning with a description of all of the new features in 11g. You’ll continue by learning from a range of step-by –step procedures for building Data Models, Layout Templates and report configurations, packed with screenshots to help you along. Finally, you’ll tackle themes like integration with Oracle EBS, Oracle report migration, and report translations.<br /><br />By the end of “Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting”, you’ll be equipped with all you need to know to produce complex reports detailing your company’s data.</p>
Table of Contents (20 chapters)
Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Glossary
A
B
C
D
E
F
G
H
J
L
M
N
O
P
R
S
T
U
X
Z
Index

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 type Data Sets

No links between the inserted Data Sets are created at this moment.

Tip

From the XML file and HTTP Data Sets, no metadata is available, hence you cannot create links using these types of Data Set.

In the following screenshot, you...