ukoug presentation feb 09 v1.0.pps [compatibility mode]

7/31/2019 UKOUG Presentation Feb 09 v1.0.Pps [Compatibility Mode]

http://slidepdf.com/reader/full/ukoug-presentation-feb-09-v10pps-compatibility-mode 1/11

1/29/2009

1

BeLife.co.uk UKOUG Feb 2009

To Infinity (XMLP) and Beyond (BI Publisher Enterprise)

To INFINITY (XMLP) andBEYOND (BI PUBLISHER)



Introduction

BIPE What is BIPE

Key Features of BIPE

BIPE Vs. other Reporting Options

Checkpoint and Questions

SevenSteps

The Data layer

The Output

Conclusion

PRESENTATION OUTLINE



3


OPTION BENEFITS

XMLP(BIP)Free, but users are limited to the data layerdefined by the standard reports in EBS.

Customise ReportsExpensive to build and maintain. Limited to onlythe EBS data source.

Discoverer Limited reporting functionality

BIPE (OBIEE)Comparatively in-expensive to implement andmaintain. Single independent platform from which

to manage reports.

BI Apps Very expensive to purchase (?)

Other Packages (e.g.Business Objects)

Expensive to implement and maintain.

HOW DO YOU GET INFORMATIONOUT OF ORACLE



4


To INFINITY (XMLP) andBEYOND (BI PUBLISHER)



5


ANALYSER for EXCEL



6


REPORTS WITH EXTRA

TABLES



1/29/2009

2



Introduction

BIPE What is BIPE




SevenSteps

The Data layer

The Output

Conclusion




8


What is BIPE?

Oracle BI PublisherEnterprise (BIP E) formspart of Oracle’s suite of BItools (OBI EE) providingcomprehensive analysis andreporting capabilities.



9


What is BIPE?

BIP E provides a standaloneplatform which enables theuser to define both thepresentation and data layers.



10


What is BIPE?

The product is thin client(web based) makingimplementation quick andrelatively straight forward.



Introduction

BIPE What is BIPE




SevenSteps

The Data layer

The Output

Conclusion




12


XMLP or BIP E?

Reason/Feature XMLP BIP E Comments

Use of XML Templates Ability to reformat the report

Schedule Reports

Email Reports

Simple to use

Reliable / Robust

Customisation of Run TimeParameters

XMLP requires customisation of theOracle Reports

Customisation of Data Layer XMLP requires customisation of theOracle Reports

Use of Multiple Data Sources

Drill Down

Embed queries in Excel

Bursting

Cheap to Implement

XMLP FREE (with EBS)

BIP E fairly inexpensive@ ~£600 per license



1/29/2009

3



13


XMLP Functionality Vs BIPE

Feature XMLP BIP E Comments

XML Templates Ability to reformat the report

Schedule Reports

Email Reports


XMLP requires customisation of the Oracle Reports

Customisation of Data Layer XMLP requires customisation of the Oracle Reports


Drill Down

Plus BIP E offers a couple of greatother benefits (discussed later)



14


Other XMLP Vs BIPE

XMLP BIP E Comments

Simple & user friendly H H

Required Knowledge of Database

L H

Rich Functionality M H

Cost of Implementation L M

Reliability ? ?


BIP E fairly inexpensive @ ~£600



15


XMLP Limitations Vs BIP E

Feature XMLP BIP E Comments

XML Templates Ability to reformat the report

Schedule Reports

Email Reports


XMLP requires customisation of the Oracle Reports

Customisation of Data Layer XMLP requires customisation of the Oracle Reports


Drill Down

Analyser for Excel

Bursting





Web Based Interface

Customisation of the database

Excel Analyser

Drill down

Add runtime Parameters

Schedule reports

Burst a report

KEY FEATURES OF BIPE



17


Web Based Interface



Web Based Interface


Excel Analyser

Drill down


Schedule reports

Burst a report




1/29/2009

4



19


Editing the Data Layer

XMLF I N A N C I A L SF I N A N C I A L SF I N A N C I A L SF I N A N C I A L S

XMLXMLP

BIP EA soundunderstanding of theEBS database isrequired to producereports



20


XML


XMLF I N A N C I A L SF I N A N C I A L SF I N A N C I A L SF I N A N C I A L S

XMLP

BIP EA soundunderstanding of theEBS database isrequired to producereports



21



T2.TRANSACTION_DATE < T1.AS_OF_DATE - 30



Web Based Interface


Excel Analyser

Drill down


Schedule reports

Burst a report




23


Analyser for Excel



Web Based Interface


Excel Analyser

Drill down


Schedule reports

Burst a report




1/29/2009

5



25


Drill Down Capability



Web Based Interface


Excel Analyser

Drill down


Schedule reports

Burst a report




27


Changing the RuntimeParameters



Web Based Interface


Excel Analyser

Drill down


Schedule reports

Burst a report




29


Scheduling Reports



Web Based Interface


Excel Analyser

Drill down


Schedule reports

Burst a report




1/29/2009

6



31


Burst a Report



Introduction

BIPE What is BIPE




SevenSteps

The Data layer

The Output

Conclusion




33


Reporting Options for EBS

OPTION BENEFITS

XMLP(BIP)Free, but users are limited to the data layerdefined by the standard reports in EBS.

Customise ReportsExpensive to build and maintain. Limited toonly the EBS data source.


OBIEEComparatively in-expensive to implement andmaintain. Single independent platform fromwhich to manage reports.






Introduction

BIPE What is BIPE




SevenSteps

The Data layerThe Output

Conclusion




THE SEVEN STEPS

Create theDataLayer

1. Create the Reports

2. Create the Data Layer

3. Create the Parameters

Create theOutput

4. Test the Output

5. Design the Tempate

6. Configure Parameters

Runreport

7. Run the report



36


Step 1: Create Report



1/29/2009

7



THE SEVEN STEPS

Create the

DataLayer


2. Create the Data Layer3. Create the Parameters

Create theOutput

4. Test the Output



Runreport

7. Run the report



38


Step 2: Create Data Layer



39





40





41





THE SEVEN STEPS

Create theDataLayer




Create theOutput

4. Test the Output



Runreport

7. Run the report



1/29/2009

8



43


Step 3: Run time Parameters



44


Step 3: Run time Parameters



THE SEVEN STEPS

Create theDataLayer




Create theOutput

4. Test the Output



Runreport

7. Run the report



46


Step 4: Test Output



THE SEVEN STEPS

Create theDataLayer




Create theOutput

4. Test the Output

5. Design the Template


Runreport

7. Run the report



48


Step 5: Design Template



1/29/2009

9



49


Step 5 Design Template



50


Step 5: Attach Template



51


Step 5: Attach Template



THE SEVEN STEPS

Create theDataLayer




Create theOutput

4. Test the Output

5. Design the Template


Runreport

7. Run the report



53


Scheduling Reports



54


Burst a Report



1/29/2009

10



THE SEVEN STEPS

Create the

DataLayer


2. Create the Data Layer3. Create the Parameters

Create theOutput

4. Test the Output



Runreport

7. Run the report



56


Run the Report



57


ANALYSER for EXCEL



58


Changing the RuntimeParameters



Introduction

BIPE What is BIPE




SevenSteps

The Data layer

The Output

Conclusion




60


Overview

Whilst XMLP provides richfunctionality, it does have itslimitations.BIP E reaches well beyondthat of its EBS integratedpredecessor.





1/29/2009

11



61


Reporting Options for EBS

OPTION BENEFITS

XMLP(BIP) Free, but users are limited to thedata layer defined by the standardreports in EBS.

Customise ReportsExpensive to build and maintain. Limited to onlythe EBS data source.


OBIEE

Comparatively in-expensive toimplement and maintain. Singleindependent platform from whichto manage reports.




PERHAPS A GOODPLACE TO START…



Useful Links – Our Site!



Useful Links – OBIPE & OBIEE

BI Publisher Enterprise – Excel Analyserhttp://blogs.oracle.com/xmlpublisher/2007/05/we_want_excel.html

BI Publisher Enterprise – BIP Analysishttp://blogs.oracle.com/xmlpublisher/2007/05/bipnalysis.html

Getting Started with Oracle BI Publisherhttp://www.oracle.com/technology/obe/obe_bi/bipub/intro/gettingstarted.htm

Advanced Features of Oracle BI Publisherhttp://www.oracle.com/technology/obe/obe_bi/bipub/advance/advance.htm

ukoug presentation feb 09 v1.0.pps [compatibility mode]

Documents