Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting
eBook:
$29.99
Formats:
Formats:
$25.49
save 15%!
save 15%!
Print + free eBook + free PacktLib access to the book:
$79.98
Print cover: $49.99
$49.99
save 37%!
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
| Also available on: |
|
- 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
Book Details
Language : EnglishPaperback : 254 pages [ 235mm x 191mm ]
Release Date : November 2011
ISBN : 1849683182
ISBN 13 : 9781849683180
Author(s) : Daniela Bozdoc
Topics and Technologies : All Books, Oracle Fusion Middleware, Enterprise, Oracle
Table of Contents
PrefaceChapter 1: What's New in Oracle BI Publisher 11g?
Chapter 2: Creating a Data Model for a Report
Chapter 3: Multiple Data Sources
Chapter 4: Report Layout Template
Chapter 5: The New XPT Format
Chapter 6: Oracle BIP Template Builder for Microsoft Word
Chapter 7: The Report Configuration
Chapter 8: Exploring BI Publisher 11g: A Simple Report Example
Chapter 9: BI Publisher 11g and E-Business Suite
Appendix A: Report Translations
Appendix B: Migrating Oracle Reports to BI Publisher
Appendix C: Debugging Oracle Reports to BIP Migration
Appendix D: Glossary
Index
- Chapter 1: What's New in Oracle BI Publisher 11g?
- A comparison with 10g
- Building a Data Model
- Designing a layout
- Managing sub-templates
- Style templates
- Zipped PDF
- Scheduling a report job
- Getting started with Oracle BI Publisher 11g
- BI Publisher homepage
- Catalog
- Data Model Editor
- Layout options
- Template builder for Word
- The Online Analyzer
- Schedule report job
- Bursting options
- Report job history
- Integrated thin-client report design editor
- 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
- Data Set types
- SQL query
- Oracle BI analysis
- XML file
- Microsoft Excel file
- Data Structure builder
- Diagram view
- Structure view
- Code view
- Creating a new Data Model
- Building the query structure
- Data modelling using the Data Model Editor
- Getting XML output
- Event triggers
- Flexfields
- List of Values
- Parameters
- Bursting
- Summary
- Chapter 3: Multiple Data Sources
- Administration
- Available Data Sources
- JDBC Connection
- JNDI Connection
- OLAP Connection
- File
- Multiple Data Sources
- Add different types of Data Sets to a Data Model
- Joins between Data Set objects
- Links between Data Sets
- Element-level links
- Group-level links
- Group-level aggregate elements
- Global-level functions
- Parameters
- SQL Query statements
- Group filter expressions
- Data Set parameters
- Summary
- Chapter 4: Report Layout Template
- Add a Report Layout Template
- Layout Template types
- BI Publisher Template
- RTF Template
- Microsoft Excel Template
- XSL Stylesheet Template
- Other Template types
- PDF Template
- Flash Template
- eText Template
- Valid output types for layout types
- Summary
- Chapter 5: The New XPT Format
- The Layout Editor
- Designing a Layout
- Text elements
- Charts
- Data tables
- Automatic filtering
- Repeating sections
- Export options
- Summary
- Chapter 6: Oracle BIP Template Builder for Microsoft Word
- Installing Template Builder for Word
- BIP and Template Builder interaction
- Upload or generate layout
- Login to BIP
- Template preview
- Insert template elements
- Text field
- Chart
- Conditional region
- Table or form
- Modify template elements
- Template validation
- Translations
- Summary
- Chapter 7: The Report Configuration
- Properties settings
- Parameters
- Properties
- General
- Caching
- Formatting
- Font Mapping
- Currency Format
- Report Viewer options
- Parameters
- Layout
- View Report menu
- Actions menu
- Schedule Report Job
- General
- Output
- Schedule
- Notification
- Submit the 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
- Integrate EBS database into the Oracle BI repository
- Use EBS authentication to access Oracle BI
- Set up session variables for authentication
- Update authenticationschemas.xml
- Update instanceconfig.xml
- Include BI Publisher links into EBS pages
- Create a form function
- Create a menu
- Assign the menu to a responsibility
- Assign the responsibility to a user
- Set up a profile
- Using actions to integrate Oracle BI with Oracle EBS
- Functionality
- Action types and action execution
- Summary
- Appendix A: Report Translations
- Translation file
- Catalog translation
- File translation
- Same layout using BIP
- Same layout using Template Builder for Word
- Different layouts
- Locale selection logic
- Summary
- Appendix B: Migrating Oracle Reports to BI Publisher
- Prerequisites
- Installing Oracle Reports Designer
- Installing BI Publisher
- Installing JDK
- Conversion steps
- Summary
- Appendix C: Debugging Oracle Reports to BIP Migration
- Finding the error
- The log file
- Correcting the error
Daniela Bozdoc
Code Downloads
Download the code and support files for this book.
Submit Errata
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Sample chapters
You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.
Frequently bought together
+
=
50% Off
the eBooks
the eBooks
Buy both these recommended eBooks together and get 50% off the total price
- 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
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.
This is a practical guide with step-by step instructions for enhancing your application of Oracle BI Publisher 11g for enterprise reporting.
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.
