add

About Me

My photo
Oracle Apps - Techno Functional consultant

Wednesday, September 21

Introduction to BI Publisher Enterprise
Demonstration
  • Connecting to a database
  • Extracting data as XML
  • Creating a Layout Template
  • Setting up Delivery Channels
  • Delivering Documents
  • Bursting Documents
Starbucks and BI Publisher Enterprise
Introduction to BIP Enterprise


BIP is the new standard for reporting from Oracle Part of Fusion Middleware Integrated into EBS, PeopleSoft, JDE, OBIEE, Siebel

Enterprise = Standalone
Completely Standalone Application
Use for all your business reporting regardless of data source
Integrates into existing OAS architecture
Integrates into existing J2EE Application Server

Separates Data Model from Report Formatting

2 fundamental components create output:
  1. XML Data
  2. Layout
Generating the Data
Navigate to Admin->Data Sources->JDBC Connection->Add Data Source


Generating the XML Data
Create XML using standard data extraction methods
Data can be extracted via
  • SQL Queries
  • Web Services
  • XML Feeds
  • Data Templates
  • BI Answers
Data Template (Oracle Recommended)
-->Create a query and map results to XML Elements

No comments: