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

List of Values


You can add two types of List of Values (LOVs) to a Data Model: SQL Query or Fixed Data.

For the SQL type, as you can see in the following screenshot, you must do the following:

  • Select a Data Source

  • Check Cache Result if you want your result to be cached for the current session

  • Enter or build your SQL Query

The other type, Fixed Data requires pairs Label, that is the value to be entered.