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

Layout Template


To create a Layout Template for your report, perform the following steps:

  1. On the BIP homepage select Report from the Create section.

  2. Choose the Data Model you've created when prompted to Choose Existing Data Model. Click on Open.

  3. On the Create report interface, choose the type of template to create or upload. You can also choose to generate an RTF template. For this example let's choose to create a Chart type template from the Shared Templates group:

  4. Insert report template elements by dragging and dropping them from the left menu Components or from the Insert tab of the toolbar to the main area of the Layout Editor interface . By choosing the Chart type template we already have a chart element inserted:

  5. Drag data fields to the marked areas. You can see that for a chart there are two marked areas: Drop Value Here and Drop Label Here:

    • Insert PRICE and QUANTITY fields as values in the chart.

    • Insert DESCRIPTION as the label.

  6. Set the chart properties using the Properties menu on the...