BIP

BI Publisher

Topics:

1. Oracle BIP Architecture

2. Dynamic Reports

3. Report Calling Using Webservices

4. Restrict Number Of Rows Per Page in XML/BI Publisher

4. Debug Long running BI publisher Report in Oracle Fusion 

5. Fusion BIP Report Security 

Module-1: Oracle BI Publisher 11g Overview

• Overview of BI Publisher Enterprise Edition
• Describing the Oracle BI Publisher Applications Architecture and components
• Overview of Different Report Component (Layout, Data, Translation)
• Download and Install  BI Publisher Desktop Plugin for MS Word and MS Excel (Word Template Designer)
• Designing First Report using Word Template Builder

Module-2: Data Model and Report Designer Editor

• Overview of Data Model, Data Model Editor
• Data Model Components.
• Working with different Data Source options.
• Designing Simple and Master Detail Data Model
• Working with Parameters, LOVs
• Working with Event Triggers, Substitute variables
• Understanding Data Model Properties.
• Understanding Groups, Functions, Links, Aggregation
• Understanding Bursting Definition.
• Overview of Report Designer and Report creation process.
• Understanding different Layout types (RTF, PDF, E-text, Excel, and Interactive)
• Setting Run Time Properties
• Style Templates & Sub Templates
• Understanding Translation

Module-3 : Designing RTF Template using Word Template Designer

• Create Simple Listing Report
• Working with Groups
• Working with Tables, Forms and Charts
• Implementing conditional logic to handle complex layout
• Formatting Numbers, Date and Currencies.
• Defining Headers and Footers
• Inserting Images and Charts
• Implementing XPATH Commands in RTF
• Working with Sub-Templates
• Advance Report Layout

Module-4 : Design Interactive Reports Using Layout Builder

• Overview of BI Publisher Layouts
• Designing Simple interactive Report
• Designing a Master Detail Report Using Charts

Module-5 : Scheduling the Reports

• Overview of BI Publisher Scheduler
• Creating Report Jobs
• Viewing and Managing Report Jobs
• Viewing and Managing Report History

Module-6 : BI Publisher Administration

• Introduction to Oracle BI Publisher Administration
• Understanding the Security Model
• Setting up Data Sources
• Setting up Delivery Destinations
• Defining Run-Time Configurations
• Diagnostics and Performance Monitoring
• Moving Catalogue Objects between Environments
• Overview of Web logic Console and Enterprise Manager (EM) to Administrator BI Publisher