![Page 1: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/1.jpg)
![Page 2: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/2.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
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.
![Page 3: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/3.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Reporting
Rich SolonPrincipal Sales Consultant
![Page 4: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/4.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Information ContinuumProduction
Reports
Dashboards & Metric Monitoring
Report Writer
Standard Reports
End User ExecutionProcessing Options
EnterpriseReport Writer
Analytics
DimensionalAnalytics
Data Warehousing
OnlineInquiry
3rd Party Adapters
Data adapter forCrystal Reports
Open Data Access – Any tool like
Access, Excel, Word,Showcase
Leverages EnterpriseOne
Security
Manage byException
Query By Example
Import/Export
Custom Grid Layouts
Save Query
Data Browser
Ad Hoc Reporting
3rd Party Access
Workflow
Alerts
Conditional Processing
End User Reporting &
Analysis
Role based portals – employees, customers and suppliers
![Page 5: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/5.jpg)
“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
![Page 6: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/6.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Save QBE Query Specifications
![Page 7: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/7.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 8: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/8.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 9: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/9.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Data Browser
![Page 10: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/10.jpg)
“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
![Page 11: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/11.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne ODBC DriverEnterpriseOne ODBC Driver
• Access EnterpriseOne data from Access EnterpriseOne data from 33rdrd party reporting tools party reporting tools
• MS Access, Excel, etcMS Access, Excel, etc
• Security is enforcedSecurity is enforced
Open Data Access (ODA)
![Page 12: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/12.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
RAW DATARAW DATA
Slice and Dice with Slice and Dice with Pivot TablePivot Table
Create Create Dynamic Dynamic GraphsGraphs
Open Data Access (ODA)
![Page 13: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/13.jpg)
“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)
![Page 14: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/14.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Report WriterSingle report, many uses
Powerful End User ConfigurationReports and Applications
Production Report
Amount1 DescripAmount
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Production Report
Amount1 DescripAmount
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Production Report
Amount1 DescripAmount
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Processing Options
Production Report
Amount1 DescripAmount
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
r
Production Report
Amount1 DescripAmount
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
Data1 Description212098.32
re
![Page 15: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/15.jpg)
“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)
![Page 16: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/16.jpg)
“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
![Page 17: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/17.jpg)
“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
![Page 18: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/18.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
More Information on Customer ConnectionProducts + Industries -> Application Development, Integration
and Portals
![Page 19: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/19.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
LeverageStandard Workflow
Templates
Browser-based,Graphical Monitoring
Integrates with standard email
Workflow & Exception Notification
![Page 20: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/20.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Multiple-Level Structure Structure Type ORG
Distribution List 7000
750074017402
73017201
71017102
PresidentVice President #1Vice President #2
Director #1Manager #1
Clerk #1Clerk #2
7202 Manager #27103 Clerk #3
7302 Director #27203 Manager #3
7104 Clerk #4
EnterpriseOne Workflow Distribution List / Organization Structures
User or Role driven
![Page 21: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/21.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
• User-initiated
• Application-initiated• Online or Batch
• Table-initiated• Database activity
• External – API
Workflow TriggersInitiating Workflow Processes
![Page 22: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/22.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Workflow / Email Integration
Supports workflow management
•Escalation•Reassignment•Monitoring•Forward/Reply
Open to MAPI mail services
• MS Outlook, Exchange• Lotus Notes• SMTP
![Page 23: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/23.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Web Services
Templates
XML
EDI
EFT
Printer
Fax
WebDAV
e-Commerce
Output Destinations
Oracle, PS, JDE
MS, SAP, Siebel
Custom AppJava, C++
Fusion Reporting
Data Sources
•Word•Excel•Acrobat
Oracle BI PublisherMaximum Information Utilization
XSL
Layout Tools
RTF
HTML
Excel
•XML Spy•JDeveloper•Scriptura
Controllers
Customers
Government
Suppliers
![Page 24: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/24.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
Oracle BI Publisher
![Page 25: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/25.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 26: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/26.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 27: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/27.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 28: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/28.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 29: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/29.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 30: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/30.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 31: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/31.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 32: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/32.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 33: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/33.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 34: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/34.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 35: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/35.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 36: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/36.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 37: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/37.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 38: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/38.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 39: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/39.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.” 39
Search
Pervasive Information Access Through a Unified BI Foundation
Ad-hoc Analysis
Interactive Dashboards
ProactiveDetectionand Alerts
MS Office& OutlookIntegration
Reporting & Publishing
Disconnected& MobileAnalytics
OLTP & ODSSystems
Data WarehouseData Mart
SAP, OraclePeopleSoft, Siebel,
Custom Apps
FilesExcelXML
BusinessProcess
Multidimensional Calculation and Integration Engine
Integrated Security, User Management, Personalization
Intelligent Request Generation and Optimized Data Access Services
Essbase
Common Enterprise Information Model
![Page 40: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/40.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 41: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/41.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 42: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/42.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 43: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/43.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 44: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/44.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 45: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/45.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 46: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/46.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
![Page 47: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/47.jpg)
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
AQ&
![Page 48: EnterpriseOne Reporting Rich Solon Principal Sales Consultant](https://reader036.vdocuments.us/reader036/viewer/2022062305/56815e09550346895dcc653c/html5/thumbnails/48.jpg)