enterpriseone reporting rich solon principal sales consultant
DESCRIPTION
- PowerPoint PPT PresentationTRANSCRIPT
“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.
“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”
EnterpriseOne Reporting
Rich SolonPrincipal Sales Consultant
“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
“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.”
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)
“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)
“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 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
“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 ConnectionProducts + Industries -> Application Development, Integration
and Portals
“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
“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
“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
“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
“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
“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.” 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
“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.”
AQ&