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

Set up Oracle BI to use Oracle EBS security to authenticate users


Taking EBS as the beginning point, there are a few steps to complete in order to enable the communication with Oracle BI (BIP in particular).

Integrate EBS database into the Oracle BI repository

To enable integration with Oracle EBS, you must create a database object and connection pool for the EBS database in the Oracle BI repository.

To create a database object go to the Oracle BI Administration page found in:

Programs | Oracle Business Intelligence | BI Administration

Open the repository that you want to integrate with Oracle EBS. Right-click on the physical layer and select New Database. Enter a name and select the database type:

  1. Name: Enter a name for the new database (for example, Oracle EBS 12).

  2. Database: Select the appropriate Oracle Database type for your Oracle EBS database (for example, Oracle 10g R2 or Oracle 11g).

  3. Click on OK.

In order to create a connection pool, right-click on the created database object and...