<Insert Picture Here>
<Insert Picture Here>
Essbase Overview
Jim Kubik
Senior Sales Consultant
Agenda
• What is Essbase?
• Essbase Key Features/Benefits/Use Cases
• User Experience
• Demonstration
© 2009 Oracle Corporation – Proprietary and Confidential
Jim’s Hotel
• How would you “view” the business??
© 2009 Oracle Corporation – Proprietary and Confidential
<Insert Picture Here>
Spreadmart Hell?
© 2009 Oracle Corporation – Proprietary and Confidential
Most Modeling is Done Here!
It is the right tool, but…
•
•
•
•
•
•
•
© 2009 Oracle Corporation – Proprietary and Confidential
Disconnected
Data Security Risks
Error-prone
Doesn’t scale
No controls / audit trails
Multiple calculations
Spreadsheets are
inefficient for more than
two dimensions
Business is more than “2D”
Market
Time
Product
• We typically look at more than
two dimensions (multidimensional)
• So what do we do?
• Add more column headers!
• In our example:
• “Total” Market BY “Total”
Product, Actual Sales for Qtr1
= 95,820
• Creates HEADACHES!
Scenario
Measures
© 2009 Oracle Corporation – Proprietary and Confidential
Multi-Dimensional = Multi-Sheet…
• Add a sheet for each brand
• 4 brands + Total = 5 Sheets
• The problem exacerbates…
Market(s)
© 2009 Oracle Corporation – Proprietary and Confidential
Multi-Sheet = Nightmare
• How about by Brand and by Market?
• 5 Brands BY 500 Properties = 2500 Sheets!
• What about by Location too?
• Welcome to “Spreadsheet Hell”
© 2009 Oracle Corporation – Proprietary and Confidential
Solution?????
© 2009 Oracle Corporation – Proprietary and Confidential
Essbase
• OLAP Database
•
•
•
•
Dimensional “cube” of information
The “By’s” of the company,
How you “see” the Business
Ability to “slice n dice” the data
• Essbase is commonly used to
•
•
•
•
•
•
Combine multiple sources of disparate data
Analyze summarized data
Provide an intuitive data model
“What If” and predictive analysis
“Speed of thought”
Satisfy the needs of a variety of users
• Executives, managers, analysts & other business users
• From power users to novices
© 2009 Oracle Corporation – Proprietary and Confidential
Essbase Provides the Best of Both Worlds
Oracle Essbase
• Use the same familiar tools, Excel, Word,
PowerPoint
• Achieve Speed of Thought response time
• Benefit from a centralized enterprise-scale
solution
© 2009 Oracle Corporation – Proprietary and Confidential
Dimension Hierarchies
• Dimensions are typically hierarchical in nature
• Allows user to “drill down” on values for greater detail
Year
Brands
Quarter 1
Properties
Upperscale
January
Pointview
February
JK3
West
CA
East
March
Middle scale
CT
Quarter 2
April
© 2009 Oracle Corporation – Proprietary and Confidential
Hotel 13
NY
Database Outline
• Tree structure for dimension hierarchies
• Consolidations and mathematical relationships between
members
• Alternate & Ragged Hierarchies support
• Time and Financial intelligence
© 2009 Oracle Corporation – Proprietary and Confidential
BI Tools Are Designed for Reporting
Essbase is Tuned for Analysis
Reporting
Analysis
Which customers spend the most?
Which customers are most profitable?
What did this customer buy?
What is the customer likely to buy next?
What is the Q4 revenue forecast?
What if demand falls short of forecast?
© 2009 Oracle Corporation – Proprietary and Confidential
Agenda
• What is Essbase?
• Essbase Key Features/Benefits/Use Cases
• User Experience
© 2009 Oracle Corporation – Proprietary and Confidential
Key Features
• One Version of the Truth
• One Place to create and maintain business rules and calculations
• Get away from spreadsheet chaos.
• Speed-of-thought analysis for thousands of concurrent
users
• Premium Performance & Optimized Storage
• Write Back capability
• Time and Financial intelligence
• Mission-critical applications
• Powerful Querying and Complex Calculations
• Enterprise scale Forward Looking Applications
• Robust Write-back & Security
• Ease of development, deployment and maintenance
© 2009 Oracle Corporation – Proprietary and Confidential
No More Spreadsheet Chaos
Improved Performance Visibility and Service Quality
Third largest pizza chain in the US
3000 locations worldwide
More than $1 billion in sales
Before
After
 Excel – cumbersome, manually
maintained (store managers phoned
in results)
 Data discrepancies, low confidence
in the numbers
 No standard set of performance
measures, lack of detail for analysis
 Operators and managers spent a lot
of time gathering data, less on
running the business
 Improved availability of data (from
hours to 30 minutes)
 Standard set of measures
 Improved quality of service (order
completeness improved, “out the
door“ time reduced 10%, higher
customer satisfaction scores)
 Faster identification and reaction to
theft issues
© 2009 Oracle
Copyright
© 2009,
Corporation
Oracle and
– Proprietary
/ or its affiliates.
and Confidential
All rghts reserved.
20
Write-Back provides an “Analytic “Sandbox”
1. Choose the intersection
2. Type the updated data
value
3. Click submit
© 2009 Oracle Corporation – Proprietary and Confidential
Forward Looking Applications
• A spectrum of analyses
“Predictive Analytics
… is where Business
Intelligence is going.”
© 2009 Oracle Corporation – Proprietary and Confidential
•
•
•
•
•
•
•
•
Trending
Forecasting
Scenario modeling
What if testing
Goal seeking
OLAP mining
Hyperion Planning
HPCM
Analytic Scalability Enterprise-wide
Sales &
Marketing
Development
& Delivery
© 2009 Oracle Corporation – Proprietary and Confidential
Human
Resources
Finance
Executive
Management
Essbase @
Merchandise Planning
• Widely Deployed
•
•
•
•
•
International Finance
Merchandise
Real Estate
Daily Sales Reporting
Human Resources
• Supplier
Collaboration
• Buyers, Suppliers, Etc.
© 2009 Oracle Corporation – Proprietary and Confidential
• Merchandise Details
• Model to SKU
• 0.5TB Input Values
• 30 Billion Values @
Sub-second
Key Enabler for the Oracle EPM System
Ad-hoc
Analysis
Interactive
Dashboards
Reporting &
Publishing
Detect &
Alert
Disconnected
Analytics
Office
Integration
PERVASIVE INFORMATION ACCESS
STRATEGIC
PLANNING
PLANNING &
BUDGETING
ERP
ANALYTICS
FINANCIAL
CLOSE
CRM
ANALYTICS
INDUSTRY
ANALYTICS
PROFITABILITY
MANAGEMENT
COMMON ANALYTIC FOUNDATION
•
•
•
•
•
•
•
•
Forward-Looking Analytic Engine
Multi-user Write-back
Financial Intelligence
Enterprise Dimension Management
OLTP & ODS
Systems
Data Warehouse
Data Mart
© 2009 Oracle
Copyright
© 2009,
Corporation
Oracle and
– Proprietary
/ or its affiliates.
and Confidential
All rights reserved.
OLAP
Single Enterprise Information Model
Conformed Dimensions
Federated Query
Intelligent Caching
Oracle, Siebel, PeopleSoft
JD Edwards, SAP, Custom
Excel
XML
Business
Process
28
Agenda
• What is Essbase?
• Essbase Key Features/Benefits/Use Cases
• User Experience
© 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
34
– 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
35
Demonstration
© 2009 Oracle Corporation – Proprietary and Confidential
<Insert Picture Here>
Essbase Sweet Spots
• Spreadsheet Hell
• Modeling / Looking into the Future
• Ad hoc Financial Analysis
• Profitability Analysis
© 2009 Oracle Corporation – Proprietary and Confidential
You are invited to a complimentary Oracle
Essbase hands on workshop
•
Drive 'what-if' scenarios to analyze alternatives
•
Identify exceptions, trends and outliers with
advanced presentation and visualization tools
•
Slice and dice through data at the speed of
thought
•
Understand why thousands of organizations
depend on the power of Essbase
•
Assess how your organization could benefit
from using Essbase
© 2009 Oracle Corporation – Proprietary and Confidential
<Insert Picture Here>
Questions
© 2009 Oracle Corporation – Proprietary and Confidential
[email protected]
© 2009 Oracle Corporation – Proprietary and Confidential
Accolades along the way ……
Top Ten Most Influential Technology
Innovations
“ Essbase:
The multi-dimensional
database technology that put
online analytical processing
(OLAP) on the business
intelligence map. Developed
by Arbor Software, it spurred
the creation of scores of rival
OLAP products - and billions
of OLAP cubes”
Information Age Magazine
August 2005
© 2009 Oracle Corporation – Proprietary and Confidential
Descargar

Essbase Overview