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


Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
$25.49
save 15%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
$49.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • 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 : English
Paperback : 254 pages [ 235mm x 191mm ]
Release Date : November 2011
ISBN : 1849683182
ISBN 13 : 9781849683180
Author(s) : Daniela Bozdoc
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Fusion Middleware, Enterprise, Oracle

Table of Contents

Preface
Chapter 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 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

                          Daniela Bozdoc

                          Daniela Bozdoc is an IT professional with experience of almost a decade working as a software developer, analyst, data and software architect on different technologies. These range from MS .NET Framework to Sybase Power Builder, Oracle and MS SQL Server, and continuing as an ERP consultant and report developer - MS dynamics NAV, Oracle EBS, and BI Publisher respectively in the present. She is a graduate of Babes-Bolyai University of Cluj-Napoca, Romania, with a B.D. in Computer Science. Daniela lives in Romania, where she has full family support of her career and enjoys taking pictures of beautiful landscapes and nature catching pieces.

                          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

                          Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting +    jBPM Developer Guide =
                          50% Off
                          the second eBook
                          Price for both: $34.80

                          Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                          What you will learn from this book

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

                          Approach

                          This is a practical guide with step-by step instructions for enhancing your application of Oracle BI Publisher 11g for enterprise reporting.

                          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.

                          Code Download and Errata
                          Packt Anytime, Anywhere
                          Register Books
                          Print Upgrades
                          eBook Downloads
                          Video Support
                          Contact Us
                          Awards Voting Nominations Previous Winners
                          Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                          Resources
                          Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software