oracle bi publisher for jd edwards l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle BI Publisher for JD Edwards PowerPoint Presentation
Download Presentation
Oracle BI Publisher for JD Edwards

Loading in 2 Seconds...

play fullscreen
1 / 31

Oracle BI Publisher for JD Edwards - PowerPoint PPT Presentation


  • 701 Views
  • Uploaded on

Oracle BI Publisher for JD Edwards. Greg Smith Oracle Principal Sales Consultant. Disclaimer.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

Oracle BI Publisher for JD Edwards


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle bi publisher for jd edwards

Oracle BI Publisher for JD Edwards

Greg Smith

Oracle Principal Sales Consultant

disclaimer
Disclaimer

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

business intelligence continuum for jde e1

5

  • Oracle Predictive Modeling Tools
  • Hyperion Essbase
  • Real Time Decisions

Oracle’s EPM System

5

4

  • Oracle Performance Mgmt Applications
    • Hyperion Planning and Budgeting
    • Hyperion Financial Management
    • more

4

3

  • Oracle BI Applications
  • Financial Analytics
  • Supply Chain & Order Mgmt Analytics
  • Procurement & Spend Analytics
  • more

3

2

  • JDE E1 Operational Consoles
    • Financial Mgmt & Compliance Console
    • Plant Manager Dashboard

2

JDE E1

1

1

  • JDE E1 Standardized Reporting
    • JDE E1 UBE, QBE (Query By Example)
    • Oracle BI Publisher
Business Intelligence Continuum for JDE E1

Strategic

Dynamic

Past Oriented

Future Oriented

Operational

Static

Roadmap subject to change without notice. The above is intended forinformation purposes and may not be incorporated into a contract.

jde reporting strategy
JDE Reporting Strategy
  • Enable E1 & World customers the tools and mechanisms necessary to Extract, Transform, Publish, Distribute data without requiring dependence on third party applications.
  • At the same time to provide E1 & World (via JDBC adaptor) customers the services and mechanisms necessary to facilitate use of third party applications should they choose to use them.
  • To deliver this capability across the spectrum of reporting needs from batch processing through business intelligence and analytics
oracle bi publisher what and why
Oracle BI Publisher – What and Why
  • BI Publisher formerly called XML Publisher
  • BI Publisher is an Oracle Fusion Application
  • Design / maintenance of report layouts is simpler
    • Layout templates are designed in MS Word
    • Users can design & preview the reports themselves
      • using sample data from E1 and World
  • BI Publisher can be called from RDA/UBE, World Writer, Dream Writer, World Export
  • E1 and World’s database could be accessed from BI Publisher
    • JDBC driver for E1 and World
slide7

From Data to Destination

PDF

Email

E1, World, Siebel, Hyperion, etc

RTF

Printer

HTML

Oracle,

SQL Server

Excel

BIPublisher

Fax

XML

XSL

Java, C++,

Pearl, etc

WebDAV

Templates

EDI

EFT

  • Word
  • Excel
  • Acrobat
  • JDeveloper
  • Government
  • PDF forms

e-Commerce

Web Services

Data Source

Layout Tools

Output

Destinations

three moving parts

Report

EFT

XML

Three “moving parts”

BI

Publisher

Desktop

Word withPlug-In

E1 UBE

World

DW,

WW

etc

Batch or

Interactive

Export or

JDBC

Template

Data

Acrobat

2.

1.

BI Publisher Engine

3.

Email or Fax

Web Site

Printer

extract once publish multiple times

Controller

CEO

BI Publisher

Government

XML

B2B

Extract Once – Publish Multiple Times

Data from E1 & World

EFT

Banking

EFT

Excel

HTML

PDF

XML

XSL

Different Templates

For different output layouts

multi site multi national companies
Multi-Site, Multi-National Companies:
  • Create one report template that can be shared by all
  • Government forms (PDF) can be filled out with World data
  • Static text on the report (headings, etc) can be translated
  • BI Publisher contains a full set of Unicode Fonts
  • No need for language-specific printers
  • BI Publisher supports 185 languages
when to use embedded or interactive reports
EMBEDDED

An event in JDE E1 triggers the report.

Need to update data in the database.

Data manipulation.

No user action.

INTEACTIVE

An event outside of JDE E1 triggers the report.

Read only data.

Minimal data manipulation.

Ad-hoc or on-demand.

When to use Embedded or Interactive Reports??
slide12

<Insert Picture Here>

BI Publisher Template Creation

user generates xml from e1 world
User Generates XML from E1/World
  • Use the Export feature from World Writer, DW
  • Save the output file on your IFS drive of the System I
  • Save the file as .XML

</WW_DTL>

<WW_DTL>

<WW_AddressNumber>4006</WW_AddressNumber>

<WW_A5AN801>A&amp;B Electric Motor Service</WW_A5AN801>

<WW_A5AN806>Denver</WW_A5AN806>

<WW_A5AN807>CO</WW_A5AN807>

<WW_AmtInvoicedThisYr>5390.00</WW_AmtInvoicedThisYr>

<WW_AmtInvoicedPriorYr>9870.00</WW_AmtInvoicedPriorYr>

<WW_ReportCodeAddBook003>MDW</WW_ReportCodeAddBook003>

<WW_ABAC0301>Midwestern</WW_ABAC0301>

</WW_DTL>

slide17

<Insert Picture Here>

BI Publisher Interactive

slide25

<Insert Picture Here>

BI Publisher Embedded – E1

report definition setup
Report Definition - Setup

Default Output type: automatic choice

Available Output types: can be chosen at submission

Language Choice is driven by available templates

Selected Languages: all those checked will print User Preference Language: prints if available

report definition setup28
Report Definition - Setup

This report will burst on address

- A full set will be sent to Max - A full set will be sent to Curtis - An individual section will be sent to each email found

bi publisher high fidelity reporting one solution for all document needs
BI Publisher High-Fidelity ReportingOne Solution for All Document Needs
  • Purchase Orders
  • Labels / Bar Codes
  • Collateral
  • Employee Forms
  • Government Forms
  • Order Forms
  • Invoices
  • Operational Reports
  • Correspondence
  • Financial Statements
  • Checks