1 / 48

EnterpriseOne Reporting Rich Solon Principal Sales Consultant

eli
Download Presentation

EnterpriseOne Reporting Rich Solon Principal Sales Consultant

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. 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 decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  2. EnterpriseOne Reporting Rich Solon Principal Sales Consultant

  3. EnterpriseOne Information Continuum End User Reporting &Analysis ProductionReports Online Inquiry 3rd Party Access Manage by Exception Report Writer Standard ReportsEnd User Execution Processing OptionsEnterpriseReport Writer Query By Example Import/ExportCustom Grid Layouts Save Query Data BrowserAd Hoc Reporting 3rd Party Adapters Data adapter forCrystal Reports Open Data Access – Any tool like Access, Excel, Word, Showcase Leverages EnterpriseOne Security Workflow AlertsConditional Processing Analytics Dimensional Analytics Data Warehousing Dashboards & Metric Monitoring Role based portals – employees, customers and suppliers

  4. Query by Example and Grid Customization • Query by example • “on the fly” queries • <, >, = operators • combine criteria • avoid reports • Grid Formats • Highlight columns • Fonts / Color • Field width / sequ. • Sort Order • User, Role, Public

  5. Save QBE Query Specifications

  6. Data Browser

  7. Seamless Integration to Desktop Tools Import data from and export to Microsoft Excel or Word

  8. Open Data Access (ODA) • EnterpriseOne ODBC Driver • Access EnterpriseOne data from 3rd party reporting tools • MS Access, Excel, etc • Security is enforced

  9. Open Data Access (ODA) RAW DATA Slice and Dice with Pivot Table Create Dynamic Graphs

  10. Output • Adobe Acrobat “.pdf” File • Excel • Printer • Table/File Update (OneWorld, Access, XML, OSA, text, etc) EnterpriseOne Report Writer • Build via Wizard • Drill-down to detail • Unlimited “Versions” • Workflow Integration • Data Conversion

  11. EnterpriseOne Report WriterSingle report, many uses Powerful End User ConfigurationReports and Applications Production Report Amount1 Descrip Amount Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Production Report Amount1 Descrip Amount Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Production Report Amount1 Descrip Amount Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Production Report Amount1 Descrip Amount Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 r Production Report Amount1 Descrip Amount Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 re Processing Options

  12. Crystal Reports and Crystal Enterprise • High Performance report design • 100’s of formatting options • Publish in PDF, Excel, and Word formats • Robust Web publishing tools • EnterpriseOne data adapter respects security restrictions • 10 Crystal Reports • 3 Crystal Enterprise (1 CAL = 10-11 named users) • Licenses Included with EnterpriseOne:

  13. EnterpriseOne Security Connector • Enforces EnterpriseOne security • User Authentication • Data Access • Maps users/groups to Crystal Enterprise • Eliminates complex and redundant database security

  14. EnterpriseOne Data Connector • Leverages EnterpriseOne Data Dictionary • Works with business views and tables • Enforces table row and table column security • Adds UDC descriptions to the list of available columns • Performs data decimal scrubbing and Julian date conversions

  15. More Information on Customer ConnectionProducts + Industries -> Application Development, Integration and Portals

  16. Workflow & Exception Notification LeverageStandard Workflow Templates Browser-based, Graphical Monitoring Integrates with standard email

  17. Multiple-Level Structure Structure Type ORG Distribution List 7000 7500 President 7401 Vice President #1 7402 Vice President #2 7301 Director #1 7201 Manager #1 7101 Clerk #1 7102 Clerk #2 7202 Manager #2 7103 Clerk #3 7302 Director #2 7203 Manager #3 7104 Clerk #4 EnterpriseOne WorkflowDistribution List / Organization Structures User or Role driven

  18. Workflow TriggersInitiating Workflow Processes • User-initiated • Application-initiated • Online or Batch • Table-initiated • Database activity • External – API

  19. Workflow / Email Integration Open to MAPI mail services • MS Outlook, Exchange • Lotus Notes • SMTP Supports workflow management • Escalation • Reassignment • Monitoring • Forward/Reply

  20. Email Printer Fax WebDAV e-Commerce Oracle BI PublisherMaximum Information Utilization HTML Oracle, PS, JDE Customers RTF Excel Suppliers MS, SAP, Siebel PDF Fusion Reporting XML Controllers XSL Custom App Java, C++ EDI Templates • XML Spy • JDeveloper • Scriptura • Word • Excel • Acrobat EFT Government Web Services Data Sources Layout Tools Output Destinations

  21. Oracle BI Publisher

  22. Pervasive Information Access Through a Unified BI Foundation OLTP & ODS Systems Data Warehouse Data Mart Essbase SAP, Oracle PeopleSoft, Siebel, Custom Apps Files Excel XML Business Process Ad-hoc Analysis Interactive Dashboards Search Reporting & Publishing Proactive Detection and Alerts Disconnected & Mobile Analytics MS Office & Outlook Integration Common Enterprise Information Model Integrated Security, User Management, Personalization Multidimensional Calculation and Integration Engine Intelligent Request Generation and Optimized Data Access Services 39

  23. Q & A

More Related