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

This is a crash course in improving your enterprise reporting skills using Oracle BI Publisher. It takes you from the fundamentals of Business Intelligence to advanced configuration techniques, and everything in between.

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

Starting
Daniela Bozdoc

This is a crash course in improving your enterprise reporting skills using Oracle BI Publisher. It takes you from the fundamentals of Business Intelligence to advanced configuration techniques, and everything in between.
$10.00
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free sample

Book Details

ISBN 139781849683180
Paperback254 pages

About This Book

  • A practical tutorial for improving your Enterprise reporting skills with Oracle BI Publisher 11g
  • Master report migration, template design, and E-Business Suite integration
  • A practical guide brimming with tips about all the new features of the 11g release

Who This Book Is For

If you are an Oracle BI Publisher 11g end user, be it a report developer, business analyst or consultant, this book is for you. You should have good knowledge of general reporting practices and XML/XSL programming, though experience of using BI/XML publisher is not essential.

Table of Contents

Chapter 1: What's New in Oracle BI Publisher 11g?
A comparison with 10g
Getting started with Oracle BI Publisher 11g
Backward compatibility of BI Publisher 11g with BI Publisher 10g reports
Summary
Chapter 2: Creating a Data Model for a Report
Report Data Model Editor interface
Data Sets
Event triggers
Flexfields
List of Values
Parameters
Bursting
Summary
Chapter 3: Multiple Data Sources
Administration
Available Data Sources
Multiple Data Sources
Summary
Chapter 4: Report Layout Template
Add a Report Layout Template
Layout Template types
Valid output types for layout types
Summary
Chapter 5: The New XPT Format
The Layout Editor
Designing a Layout
Export options
Summary
Chapter 6: Oracle BIP Template Builder for Microsoft Word
Installing Template Builder for Word
BIP and Template Builder interaction
Insert template elements
Modify template elements
Template validation
Translations
Summary
Chapter 7: The Report Configuration
Properties settings
Report Viewer options
Schedule Report Job
Manage report jobs
View report history
Report Job's life
Summary
Chapter 8: Exploring BI Publisher 11g: A Simple Report Example
Data Model
Layout Template
Report configuration
Report job
Translation
Summary
Chapter 9: BI Publisher 11g and E-Business Suite
Set up Oracle BI to use Oracle EBS security to authenticate users
Using actions to integrate Oracle BI with Oracle EBS
Summary

What You Will Learn

  • Jump start your learning by understanding what Business Intelligence really means
  • Migrate Oracle reports to Oracle BI Publisher 11g
  • Get to grips with designing Data Models for reports in Oracle BIP 11g
  • Master the management of multiple data sources
  • Gain the skills to design the layout of reports and build BI Publisher templates
  • Build RTF templates using Template Builder for MSWord
  • Go further with Oracle BIP by integrating with E-Business Suite and dealing with report translations
  • Learn how to build a report from beginning to end, including configuration

In Detail

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.

“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.

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.

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.

Authors

Table of Contents

Chapter 1: What's New in Oracle BI Publisher 11g?
A comparison with 10g
Getting started with Oracle BI Publisher 11g
Backward compatibility of BI Publisher 11g with BI Publisher 10g reports
Summary
Chapter 2: Creating a Data Model for a Report
Report Data Model Editor interface
Data Sets
Event triggers
Flexfields
List of Values
Parameters
Bursting
Summary
Chapter 3: Multiple Data Sources
Administration
Available Data Sources
Multiple Data Sources
Summary
Chapter 4: Report Layout Template
Add a Report Layout Template
Layout Template types
Valid output types for layout types
Summary
Chapter 5: The New XPT Format
The Layout Editor
Designing a Layout
Export options
Summary
Chapter 6: Oracle BIP Template Builder for Microsoft Word
Installing Template Builder for Word
BIP and Template Builder interaction
Insert template elements
Modify template elements
Template validation
Translations
Summary
Chapter 7: The Report Configuration
Properties settings
Report Viewer options
Schedule Report Job
Manage report jobs
View report history
Report Job's life
Summary
Chapter 8: Exploring BI Publisher 11g: A Simple Report Example
Data Model
Layout Template
Report configuration
Report job
Translation
Summary
Chapter 9: BI Publisher 11g and E-Business Suite
Set up Oracle BI to use Oracle EBS security to authenticate users
Using actions to integrate Oracle BI with Oracle EBS
Summary

Book Details

ISBN 139781849683180
Paperback254 pages
Read More