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.
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Reporting
Rich Solon Principal Sales Consultant
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Information Continuum
Production Reports Online Inquiry 3rd Party Access Manage by Exception
End User Reporting & Analysis
Report Writer
Standard Reports
Query By Example
Import/Export Custom Grid Layouts
3rd Party Adapters
Data adapter for Crystal Reports Open Data Access – Any tool like Access, Excel, Word, Showcase Leverages EnterpriseOne Security
Workflow
Alerts
Analytics
Dimensional Analytics Data Warehousing
End User Execution Processing Options
Save Query Data Browser
Conditional Processing
Enterprise Report Writer
Ad Hoc Reporting
Dashboards & Metric Monitoring
Role based portals – employees, customers and suppliers
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
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
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Save QBE Query Specifications
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Data Browser
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Seamless Integration to Desktop Tools
Import data from and export to Microsoft Excel or Word
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Open Data Access (ODA)
EnterpriseOne ODBC Driver
• Access EnterpriseOne data from 3rd party reporting tools • MS Access, Excel, etc • Security is enforced
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Open Data Access (ODA)
RAW DATA
Slice and Dice with Pivot Table
Create Dynamic Graphs
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Report Writer
• • • • • Build via Wizard Drill-down to detail Unlimited “Versions” Workflow Integration Data Conversion
Output
• • • • Adobe Acrobat “.pdf” File Excel Printer Table/File Update (OneWorld, Access, XML, OSA, text, etc)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Report Writer
Single report, many uses
Powerful End User Configuration Reports and Applications
Production Report
Amount1
Descrip
Amount
Processing Options
Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Production Report Data1 Description2 12098.32 Data1 Description2 12098.32 Amount1 Descrip Amount Description2 Production Report Data1 12098.32 Data1 Description2 12098.32 Description2 Data1 12098.32 Data1 Description2 12098.32 Description2 Data1 12098.32 Amount1 Descrip Data1 Description2 12098.32 Description2 Data1 12098.32 Data1 Description2 Data1 Description2 12098.32 Description2 Data1 12098.32 Data1 Description2 Data1 Description2 12098.32 Description2 Data1 12098.32 Data1 Description2 Data1 Description2 12098.32 Description2 Data1 12098.32 Data1 Description2 Production Data1 Description2 Report 12098.32 Description2 Data1 12098.32 Data1 Description2 Data1 Description2 12098.32 Description2 Data1 12098.32 Data1 Description2 Data1 Description2 12098.32 Description2 Amount1 Descrip Data1 Amount 12098.32 Data1 Description2 Data1 12098.32 Description2 Data1 Description2 Description2 Data1 12098.32 12098.32 Data1 Description2 Data1 12098.32 Description2 Data1 Description2 Description2 Data1 12098.32 12098.32 Data1 Description2 Production Report Data1 Data1 Description2 Description2 12098.32 12098.32 Data1 Description2 Data1 Data1 Description2 Description2 12098.32 12098.32 Data1 Description2 Data1 Amount1 Descrip Amount Data1 Description2 Description2 12098.32 12098.32 Data1 Description2 Data1 Data1 Description2 Description2 12098.32 12098.32 Data1 Description2 Description2 12098.32 Data1 Data1 Data1 Description2 Description2 12098.32 12098.32 Data1 Description2 Description2 12098.32 Data1 Data1 Data1 Description2 Description2 12098.32 12098.32 Data1 Description2 Description2 12098.32 Data1 Data1 Data1 Description2 Description2 12098.32 12098.32 Data1 Description2 Description2 12098.32 Data1 Data1 Description2 12098.32 Data1 Description2 Description2 12098.32 Data1 Data1 Description2 12098.32 Data1 Description2 Description2 12098.32 Data1 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 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 Data1 Description2 12098.32 re
Amount
12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32 12098.32
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
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
Licenses Included with EnterpriseOne:
10 Crystal Reports 3 Crystal Enterprise (1 CAL = 10-11 named users)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Security Connector
• Enforces EnterpriseOne security
• User Authentication • Data Access
• Maps users/groups to Crystal Enterprise
• Eliminates complex and redundant database security
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
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
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
More Information on Customer Connection
Products + Industries -> Application Development, Integration and Portals
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Workflow & Exception Notification
Leverage Standard Workflow Templates
Browser-based, Graphical Monitoring
Integrates with standard email
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Workflow
Distribution List / Organization Structures
Multiple-Level Structure
Structure Type ORG
User or Role driven
Distribution List 7000
7500 President
7401 Vice President #1
7402 Vice President #2 7301 Director #1 7201 Manager #1 7101 7102 Clerk #1 Clerk #2
7202 Manager #2
7103 7302
Clerk #3
Director #2 7203 Manager #3
7104 Clerk #4
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Workflow Triggers
Initiating Workflow Processes
• User-initiated
• Application-initiated • Online or Batch • Table-initiated • Database activity • External – API
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Workflow / Email Integration
Open to MAPI mail services
• MS Outlook, Exchange • Lotus Notes • SMTP
Supports workflow management
•Escalation •Reassignment •Monitoring •Forward/Reply
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Oracle BI Publisher
Maximum Information Utilization
HTML
Oracle, PS, JDE
Email
RTF
Customers
Excel
Printer
Suppliers
MS, SAP, Siebel
Fusion Reporting
XSL
PDF
Fax
XML
Controllers WebDAV
Custom App Java, C++
Templates •XML Spy •Word •JDeveloper •Excel •Acrobat •Scriptura
EDI
EFT
Government e-Commerce
Web Services
Data Sources
Layout Tools
Output
Destinations
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Oracle BI Publisher
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Pervasive Information Access Through a Unified BI Foundation
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
OLTP & ODS Systems
Data Warehouse Data Mart
Essbase
SAP, Oracle PeopleSoft, Siebel, Custom Apps
Files Excel XML
Business Process
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
39
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”