Transcript Essbase Reporting

<Insert Picture Here>
<Insert Picture Here>
Essbase Reporting
Jim Kubik
Senior Sales Consultant
Agenda
• Reporting Overview
• Performance
• Workspace
• Dashboards
• Reports
• Drill thru
• Smartview
• Excel
• PPT / Word
• Visual Analysis
© 2009 Oracle Corporation – Proprietary and Confidential
How many of you have a “Smartphone”?
What’s the common theme?
One seamless platform, running
multiple kinds of Apps/tools
Email
Music
Movies
GPS
Games
BI
Camera
Phone
© 2009 Oracle Corporation – Proprietary and Confidential
The “Smartphone” of EPM systems
Oracle’s EPM system
One Platform, Multiple Delivery Channels, Seamless
Data
Integration
Ad-hoc
Analysis
Interactive
Dashboards
Essbase
Reporting &
Publishing
Proactive
Detection
and Alerts
Disconnected
& Mobile
Analytics
MS Office
& Outlook
Integration
Common Enterprise Information Model
BI Server
• 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
© 2009 Oracle Corporation – Proprietary and Confidential
Essbase
SAP, Oracle
PeopleSoft, Siebel,
Custom Apps
Files Excel
XML
Business
Process
Essbase OLAP Server
Speed-of-Thought Analytics
•
•
•
•
•
•
•
•
•
ESSBASE FEATURES
Fast “speed-of-thought”
calculations
Leading Excel user interface
Visual analysis
Broad set of analytic functions
Financial and time intelligence
Calculation power
Optimized storage
Trickle feed
Enterprise scale
© 2009 Oracle Corporation – Proprietary and Confidential
UNIQUELY SUITED FOR
THESE APPLICATIONS
• What-if
• Forward-looking
• Multi-user scenario
modeling
• Planning
• Allocations
• End user custom analytics
6
Oracle’s Unified BI Foundation
Meeting the full continuum of BI needs
Essbase
Common Enterprise
Information Model
Oracle BI Suite EE Plus
© 2009 Oracle Corporation – Proprietary and Confidential
•
•
•
•
What-if
Scenario modeling
User crafted analysis
Predictive analytics
• Consistent definitions
• Role-based views
• Model-driven
•
•
•
•
Interactive Dashboards
Ad hoc query
Report publishing
Alerts
Premium Performance
• Multiple and cross platform deployment
• Unix and/or Windows
• 32 / 64 bit
• Application optimization
•
•
•
•
Partitioning
Clustering
Tuning
Trickle Feed
© 2009 Oracle Corporation – Proprietary and Confidential
Providing Top Performance Scalability
Market-leading OLAP Architecture
Load & Calculation
Query Response
CPU Utilization
Identical Hardware
(Minutes)
50 Concurrent Users
(Seconds)
50 Concurrent Users
(%)
350
300
90
14
294
12
11.9
83
80
70
250
10
200
8
50
150
6
40
100
4
60
162
30
20
50
2
0
0
Competing
Vendor
Essbase
© 2009 Oracle
Copyright
© 2009,
Corporation
Oracle and
– Proprietary
/ or its affiliates.
and Confidential
All rights reserved.
7
10
0.01
Competing
Vendor
Essbase
0
Competing
Vendor
Essbase
9
“Speed of Thought” response
…… for 30,000 business users
• 5,000 views & reports
•
•
•
•
Sales
HR
Purchasing
Finance
• 24 x 7 availability
• Maximum query time:
• less than 4 seconds
© 2009 Oracle Corporation – Proprietary and Confidential
“We realized we needed a
powerful OLAP system—one
that was highly dimensional and
detailed—that could provide
speed of thought response for
tens of thousands of users. We
selected Hyperion because it
met our scalability and
performance requirements….
EPM Workspace
Integrates Management Processes into a
Common Environment
• Single sign on
• Process integration with Planning
and HFM.
• User interface filtered
by security
• Tabbed view of content
• One place for applications,
reporting and administrative
content.
• OBIEE
© 2009 Oracle Corporation – Proprietary and Confidential
Dashboard Consumption
•
•
•
•
•
100% thin client
Ad-hoc report creation
Packaged and customized dashboards
Combining relational and OLAP data
Consistent semantic definition across reports
© 2009 Oracle Corporation – Proprietary and Confidential
Reporting
Reports and
Books
Standard
Financial
Web
Distributed
© 2009 Oracle Corporation – Proprietary and Confidential
Oracle EPM Smart View
Advanced Office Integration
• Capabilities across:
•
•
•
•
•
•
•
•
•
•
Excel
Word
PowerPoint
Outlook
Ad-hoc and free form analysis
Function-based grids
Dynamic data points
Multi-source reporting
Application forms
EPM content import
© 2009 Oracle Corporation
15
– Proprietary and Confidential
Visualize and Explore - Moving from
Data to Insight
In a single click see patterns that are not apparent by just looking at numbers:
P.
Copyright
© 2005, Hyperion.
All rights
reserved.
© 2009 Oracle
Corporation
– Proprietary
and Confidential
16
Demonstration
© 2009 Oracle Corporation – Proprietary and Confidential
Questions
© 2009 Oracle Corporation – Proprietary and Confidential
[email protected]
© 2009 Oracle Corporation – Proprietary and Confidential