enterpriseone reporting rich solon principal sales consultant

“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

Email

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

PDF

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&