1 / 28

BI Publisher and World

BI Publisher and World. Andrews Consulting Group. 25 + years in business Headquarters – Cheshire, CT 80 + Employees Oracle Certified Partner Oracle Certified Consultants. JD Edwards Focus Consulting Software Products Custom Solutions Business Intelligence

fionn
Download Presentation

BI Publisher and World

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BI Publisher and World

  2. Andrews Consulting Group • 25+ years in business • Headquarters – Cheshire, CT • 80+ Employees • Oracle Certified Partner • Oracle Certified Consultants • JD Edwards Focus • Consulting • Software Products • Custom Solutions • Business Intelligence • Industry Analysis/Whitepapers

  3. Jeff Kloss – Sr. Manager Over 14 Years World and E1 Development Experience SME: JDE Tools, OMW, EDI, C, C++, BIP, RPG, CL Industry Experience: CPG, Services, Entertainment, Industrial MFG, High Tech, Pharma Additional: Project Management, Change Management

  4. Mark Andrzejewski-Sr. Consultant GSI, Inc. Over 20 years of WorldSoftware Experience SME: Financials, CNC, JDE Tools, C++, BIP, RPG, CL Industry Experience: Public Sector, lndustrial Manufacturing, Retail, Phara Additional: Certified specialist JDE World, CNC, Oracle DBA

  5. Information from: • JD Edwards World Business Intelligence Publisher for JD Edwards World Guide • http://docs.oracle.com/cd/E24096_01/eabp.pdf

  6. Why use BI Publisher with World

  7. BI Publisher and JD Edwards World • BI Publisher integrates with JD Edwards World to enhance reporting capabilities. • Save Money by eliminating the need for a 3rd party printing solution. • Use desktop tools you already know, reducing time and costs to develop and maintain reports. • Ad hoc reports that can include special formatting and images . • BI Publisher allows you various delivery options, including email, fax, and HTML.

  8. Considerations • Must be on JD Edwards World A9.1 or Higher • Need pc’s and the ability to run MS Office, Word. • Ensure all of the necessary Service packs and JDBC drivers are installed

  9. Set Up • BI Publisher Enterprise • BI Publisher Desktop • JD Edwards World JDBC Driver

  10. BI Publisher Enterprise This is the user interface for creating, running, and scheduling reports, and you install this on a Java based application server. You must download and install BI Publisher and an OC4J application server. If you prefer to install with a different application server, use the Manual Installation section for your application server in the Oracle Business Intelligence Publisher Installation Guide, which is in the download. To improve performance over the use of work files. (see Considerations above) Access Oracle’s E-Delivery website using the following URL and follow the instructions to download and install BI Publisher: http://edelivery.oracle.com/.

  11. BI Publisher Desktop This contains a MS Word plug-in to create report templates and you install it on the PC of every one that develops reports.

  12. JD Edwards World JDBC Driver The driver is a software component that allows Java applications, such as BI Publisher, to access the JD Edwards World database. It connects Enterprise to the iSeries so that report data is up-to-date. See the JD Edwards World Java DataBase Connectivity Guide for more information. To download the JD Edwards World JDBC Driver, which includes the JD Edwards World Java DataBase Connectivity Guide, access MyOracle Support, choose Patches and Updates and the choose the JD Edwards products link. On Update Center, choose JD Edwards World Downloads in the Type field, enter JDBC1.1 in the Search for field and click SEARCH. Continue by downloading the item in the Download Basket.

  13. Creating the Report Creating a report includes the following tasks: Selecting the Data Formatting the Report Adding a Template to the Report

  14. Selecting the Data • To create a report from an SQL statement, you must choose the data that you want in the report. After you choose the data, you can then perform the following: • View the results in the report • Edit the data for the report • Export the data

  15. Formatting the Report After you create the report, you can import the XML data into Microsoft Word and use the formatting features for Oracle BI Publisher.

  16. Adding a Template to the Report After you create the template in Microsoft Word, you upload the template to the report in BI Publisher. You then modify the SQL statement to select and sort the data that displays on the report.

  17. How we from this….

  18. To this…

  19. To this…

  20. Demonstration

  21. Download Required Software from E-Delivery Several components are needed check Oracle Support for latest requirements EDDJAVA BI Publisher Desktop BI Publisher Enterprise, needed for ad-hoc reporting only.

  22. Enable BIP Embedded within World software BIP is really an part of EDD for World Software. Enable Bursting in World Software Verify Iseries JAVA versions against current MTR Determine locations form BIP Templates, raw XML output and BIP output. Determine appropriate share permisions within Iseries IFS structure

  23. Enable BIP Embedded within World software BIP is really an part of EDD for World Software. Enable Bursting in World Software Verify Iseries JAVA versions against current MTR Determine locations form BIP Templates, raw XML output and BIP output. Determine appropriate share permisions within Iseries IFS structure

  24. Create a template for BIP Load BIP Desktop tools Create Sample XML output Copy completed template to IFS

  25. Setup EDD/BIP Options Associate templates with DreamWriters Configure email and default bursting options Configure Iseries JDBC connection, mail relaying

  26. Testing All components loaded Enabled bursting on Print Options on DreamWriter Check your email…..

  27. Andrews Consulting Group 700 W. Johnson Drive Cheshire, CT. 06410 (203) 271-1300

  28. INFOCUS is a new, replacing Quest Regional events, offering in-depth education for the most popular JD Edwards EnterpriseOne modules. The JD Edwards INFOCUS call for presentations is open now! We are looking for deep-dive sessions into JD Edwards EnterpriseOne. For more information visit QuestDirect.org/INFOCUS November 7-9, 2012 Omni Interlocken Resort Broomfield, Colorado USA

More Related