Post on 23-Jan-2017
Sobre interRel
• Ganador del Premio Oracle
Solución EPM & BI del Año
• 4 directores Oracle ACE
• Autores de más de 10 de los libros más
vendidos de Hyperion y Essbase
• Aliado Oracle Platinum
• Una de las 100 empresas tecnológicas de
más rápido crecimiento en los EEUU (CRN
Magazine)
• Una de las empresas de crecimiento más
rápido en los EEUU (Inc. Magazine 2007- a
la fecha presente)
Strategia
Infra-
estructura
Consultoría
EducaciónApoyo al
cliente
Libros
Fundada en 1997, tenemos la mayor
experiencia con Oracle EPM/BI de todo el
Mundo
Cutting
Edge
Essbase
Edward Roske, CEO & Oracle ACE Director
For a copy of the slides: info@interRel.com
For free videos: epm.bi/videos
Follow me on Twitter @ERoske
Raise your hand
if you have any experience
with Essbase, por favor.
Essbase:
Extended SpreadSheet
Database
OLTP & ODSSystems
Data WarehousesData Marts
PackagedApplications
(Oracle, SAP, Others)
ExcelXML/Office
BusinessProcesses
OLAPSources
Exadata Unstructured & Semi-Structured
ERP Analytics
Planning &Forecasting
Financial Close and Reporting
StrategyManagement
Profitability Management
CRM Analytics
Industry Analytics
BI Server
Common Enterprise Information Model
Essbase Dimension Management
Predictive Analytics
Interactive Dashboards
Reporting &Publishing
Query &Analysis
Detect& Alert
OfficeIntegration
Search Embedded Mobile Scorecards
Data
So
urc
es
BI/
EP
M
Pla
tfo
rm
BI
/ E
PM
Ap
plic
ations
Oracle Business Analytics
Client Behavior
Demographics
Product Profitability
Pricing Models
Portfolio Analysis
Earnings
Revenue Growth
Liquidity
Management Effectiveness
Sales per Employee
Employee Satisfaction
Annual, Qtrly and Monthly
Comparisons
Variance Anaylsis
Return on Equity
Asset Management
Internal Rate of Return
Net Present Value
Bundling / Portfolio Offerings
MarketingFinancial
Performance
Time
Client
Centric
Market Share
Market Size
Interest Rates
Essbase provides powerful analytics
Asset
Effectiveness
CompetitiveEmployee
Effectiveness
Product
Across Industries
RetailMerchandising
PlanningCustomer
SegmentationFlash Sales
Consumer Products
Inventory Tracking
Margin Analysis
Manufacturing
Asset management
Shipping optimization
Resource planning
Oil and Gas
Production Analysis
Operational Analysis
Exploration Analysis
High-TechCustomer Analytics
Product qualityMarketing Analysis
Health Care
Departmental Profitability
Grant AnalysisHospital
Consolidation
Financial Services
Portfolio Optimization
Loan Analysis Risk Analysis
Addresses common challenges
• Large amounts of data to analyze from various systems (Trading, client
level transactions, etc)
• Securing client information – confidentiality and sensitivity of the data
• Competitive market place - Speed, speed, speed
• Market sensitive – requires access to external data quickly
• Complex calculations – (time sensitivity, risk factors, etc)
• Variety of reporting requirements – regulatory, financial, internal
management, SEC - solutions must be adaptable and flexible
• Require quick turnaround of reports and ad-hoc information to make data
actionable
How Essbase Thinks
• Multidimensional cubes
• No tables and columns
• Database definition is defined in the outline
• Dimensions
• Common grouping or
hierarchy of master data
• Organization
• Product
• Accounts
• Page and index file for BSO
• Tablespaces for ASO
JAN
JAN
JAN
FEB
FEB
LA
SF
PHX
LA
SF
SALES
SALES
MARGIN
SALES
MARGIN
ACTUAL
ACTUAL
BUDGET
BUDGET
ACTUAL
500
250
180
300
400
WEST
L.A.
S.F.
PHX
DEN
Actuals BudgetSales Margin Sales Margin
Earnings
Revenue Growth
Liquidity
Annual, Qtrly and Monthly
Comparisons
Variance Anaylsis
Financial
Performance
Time
A Simple Example
Dimensional Design
• Essbase dimensions:
• Scenario
• Year
• Period
• Account (includes accounts & calculated metrics)
• Entity Structure ( Legal, Operating)
• Reporting Hierarchies within each dimension
PeriodQtr1Qtr2Qtr3Qtr4
OctNovDec
WorldwideEMEANorth America
USEast
Bank of NYLife LLCAM Service
NorthCanada
ScenarioActualForecastBudget
MeasuresNet Income
RevenueExpenses…….
MetricsEarnings per SShares IssuedShares O/S
Year20082009201020112012
Dimensional Design
Business Question: What was the 4Q09 Net Income increase (decrease) over 4Q08 for Bank of NY?
US?
Worldwide?
How does that compare with FY08?
PeriodQtr1Qtr2Q3Qtr4
OctNovDec
WorldwideEMEANorth America
USEast
Bank of NYLife LLCAM Service
NorthCanada
ScenarioActualForecastBudget
MeasuresNet Income
RevenueExpenses…….
AUMMetrics
Earnings per SShares IssuedShares O/S
Year20082009201020112012
End User Analysis: Analyze with SmartView
• Start with a clean slate
4Q09 Net Income Bank of NY
• Select the relevant member and refresh
US ? Worldwide?
• Move Entity
(Store)
Dimension to
the rows into
the report
• Now I know
Bank of NY,
East &
Worldwide Net
Income
Compared to 2008?
• Add a column
for 2008
• Refresh
Presentation Quality
• Use Excel
Formatting
• Save the
template and re-
use
• Change Time
Period,
Scenarios,
Measures to
provide
additional
reports.
Why Essbase?
Advantages of Hyperion Essbase
• Analytics using dimensional views for end users (follows the “business” hierarchies)
• Ad-Hoc and Advanced analytics with a suite of end user tools
• Optimized data storage
• Fast reporting and analysis performance
• Top down analysis
• Limitless dimensions and members with ASO
• Flexible
• Advanced calculation engine with BSO
• Shared
• Secure
• Fast – both administrators and users
• Scalable
• Easy Sharing and integration
Analysis Capabilities
• Drill up and down, pivot rows and columns, keep only / remove only
• With OBIEE and Web Analysis
• Adhoc queries over the web
• Advanced Analysis and Dashboarding
• Traffic Lighting, Sorting
• Retrieve Top / Bottom
• With Financial Reporting
• Printed formatted books of reports
• With Interactive Reporting
• Advanced Analysis and Dashboarding
• Integrate relational and multi-dimensional data
Optimized Data Storage
• Application – container for databases or cubes
• Database - single cube for analysis and reporting
• Different types of Essbase databases available
• Block Storage
• Aggregate Storage
• XOLAP
• Hybrid Aggregation (11.1.2.3.500+)
• Administration Console or Essbase Studio to create and manage Essbase
databases
Power of Block Storage Databases
• Advanced calculations
• Write back to any levels
• Considerations
• Limited to 7-10 dimensions for performance
Power of Aggregate Storage Databases
• Virtually no limit to the level of detail with Aggregate Storage Option (ASO)
Essbase Databases
• Also called Enterprise Analytics in older versions
• Different method for storing/calculating Essbase databases
• New storage kernel
• Calculates 10-100x faster
• Stores up to 252 dimension combinations
• Which means … Lots of dimensions, lots of members
Enhancements to Hybrid Aggregation
• Hybrid Aggregation is the
biggest thing for Essbase since
version 7 when ASO was
introduced.
• Hybrid Aggregation ripe for use in
all types of traditional BSO
applications
• Applies to Planning BSO plan
types as well
• Great way to get around the
limitation on ASO plan types for
EPMA-deployed Planning apps
Flexible-Custom Dimensions
• Dimensions are defined by the customer
• Organized into hierarchies
• Multiple hierarchies are available
• How should Time Periods look?
• When does the Fiscal Year begin?
• How should the Product dimension look?
• What slices of data do we need to view?
• Users report and perform analysis by
dimensions and hierarchies
• Visible
• Intuitive
Flexible – Text and Date Measures
• Use text and dates in Essbase 11
• Perform analysis based on text and dates
• Called Text List
• Stored numerically in Essbase• Can use in calculations (logic for what should display at upper
levels)
• Import text lists – mapping of numbers to
the text value
• Can load intersections via load rule
Advanced Calculations
• Aggregations
• Allocations
• Scenario planning
• Automated business logic
• Driver based logic
• 200+ functions
• Financial intelligence
• Understands expense reporting for variances
• Time intelligence
• YTD
• Aggregation over time (headcount)
Administrators: Essbase Studio
• Next generation tool for Essbase app building and administration
• Single graphical modeling environment & single set up steps to … ease of use
• Integrate Cube creation capabilities of EIS and EAS
• Promote reuse and consistency
• Standard methodology for deploying Essbase apps
• Manage change through impact analysis and artifact lineage
• Update data source administration and access
• “Cube factory”
• Drill through
• Unifies many sources for modeling
• RDB / Data Warehouse
• OBIEE
• Flat Files
• EPMA Dimension Library
Essbase Studio
XOLAP – Store your cube in a relational database
• eXtending OLAP on Relational Database
• Cube that is dynamically sourced from RDBMS
• Looks just like ASO cube
• Build in the Studio
• Can use with any front-end that talks to Essbase
• Complete outline build• Does not automatically refresh when the dimension table changes
• Data retrieval by issuing SQL on demand
• Support for summary tables (by editing an xml file)
• RDBMS friendly SQL queries
• Transparency of access
Drill Back To…
• Relational sources
• URL
• Standard
• FDM
• OBIEE
• Custom SQL
• Java Method
• In the Future
• Other Essbase cubes
• BI+ Repository
Drill Through Reports
Scalable
• Scale to thousands of users across the world
• Large volumes of data
• Large number of applications
• High concurrency
• Can use 128 simultaneous threads for a single function
More Than Just Financial Reporting
More than Financial Reporting
SalesSales Force
EffectivenessPipeline Analysis Flash Sales
CustomersCustomer
SegmentationCustomer Profitability
Promotion & Campaign
Effectiveness
Suppliers Vendor ScorecardsSupply and Demand
PlanningStrategic Sourcing
Analysis
Human Resources
Compensation Analysis
Time & Labor Analysis
Benefits Offering Analysis
Finance Budgeting / Planning Cost Analysis Cash Flow Analysis
Operations Productivity Analysis Quality AnalysisLabor and Cost
Analysis
Sales
Earnings
Profit Margins
Annual, Qtrly and Monthly
Comparisons
Seasonal
BU Level
Brand Analysis
SKU Level
Financial
Performance
Time
Sales Analysis
Product
Customer Behavior &
Loyalty
Trends
DemographicsCustomer
Who are our customers?
Why are their historical
behavioral patterns?
Which retailer or service
provider has the most
access to our target
customer?
What were Sales by demographic?
Who are the most profitable customers?
How is our sales team
interacting with our
customers?
What are differences in
the customer’s
purchasing habits today
vs a month, a year ago or
three years ago?
What are we predicting
for next year?
Which products are Customers
buying?
Promotional Items?
Using coupons?
How effective was the direct
mail campaign?MarketingFinancial
Performance
Time
Customer
Why are the
customers
purchasing our
products? Is it price,
quality or loyalty?
Customer Analysis
Product
CompetitiveEmployee
Effectiveness
Channel
Who are our vendors?
What are we buying
from whom?
What pricing, discount, sla’s
were agreed in the contract?
Do our purchases comply?
What were purchases by region?
How much are we spending on processing payments?
How do our agents interact
with our suppliers?
Are we negotiating the best
deals?
What are purchasing
today vs a month, a year
ago or three years ago?
What our current
commitments?
Which products are we buying from
our vendors?
Are we leveraging our purchasing
power?
Are we managing our working
capital effectively?
What type of discounts are we
receiving?PaymentsFinancial
Performance
Time
Vendor
Are we achieving the
lowest total cost?
best price, service
and quality?
Vendor Analysis
Product
CompetitiveEmployee
Effectiveness
Contracts
How is HR performance measured?
SatisfactionPerformance
Diversity
Employee Productivity
Career
Growth
Benefits
Competencies Certifications acquired
Training provided vs training
completed
Benefits $ per employee
Bonus Plans
Vacation time compared to
years of service
Units produced per Employee
Sales per Employee
Employee Satisfaction Index
Career Path
Attrition Rate
Years of Service
Recruitment
Compensation costs
Legal Compliance
Safe Work Environment
Equal Employment
Opportunities
Company Culture
Extracurricular programs
Tenor vs promotion
Promotion path
visibility
Communication
effectiveness
So Any Reasons Not to Use Essbase?
• Rows and columns reporting
• Detail transaction reporting with many rows and columns
• HR type reports
• Not employee analysis and planning b/c Essbase IS good at that
• Reports listing name, address, DOB, phone, SSN, etc.
Recap - Advantages of Hyperion Essbase
• Dimensional view for end users (follows the “business” hierarchies)
• Optimized data storage
• Fast reporting and analysis performance
• Top down analysis
• Limitless dimensions and members with ASO
• Flexible
• Advanced calculation engine with BSO
• Secure
• Fast – both administrators and users
• Advanced Analytics
• Scalable
• Easy Sharing and integration
Essbase 11.1.2.4
OLTP & ODSSystems
Data WarehousesData Marts
PackagedApplications
(Oracle, SAP, Others)
ExcelXML/Office
BusinessProcesses
OLAPSources
Exadata Unstructured & Semi-Structured
ERP Analytics
Planning &Forecasting
Financial Close and Reporting
StrategyManagement
Profitability Management
CRM Analytics
Industry Analytics
BI Server
Common Enterprise Information Model
Essbase Dimension Management
Predictive Analytics
Interactive Dashboards
Reporting &Publishing
Query &Analysis
Detect& Alert
OfficeIntegration
Search Embedded Mobile Scorecards
Data
So
urc
es
BI/
EP
M
Pla
tfo
rm
BI
/ E
PM
Ap
plic
ations
Essbase 11.1.2.4
Recap – What was New in Essbase 11.1.2.3.000?
Improvements to OBIEE Integration
@CREATEBLOCK Calculator Function
@ISMBRUDA Calculator Function
Runtime Substitution
Variables
@XREF Performance
Improvements
MDX Query Performance
Improvements
Essbase API Changes
The death of the Classic
Spreadsheet
Add-In
Recap – What was New in Essbase 11.1.2.3.500?
Improvements to MDX
Aggregate and Sum Functions
FIXPARALLEL
Fragmentation Reduction on
Exalytics Servers
Hybrid Aggregation Mode in BSO
Force CalcParallel
Recap – What was New in Essbase 11.1.2.3.500?
Improvements to MDX
Aggregate and Sum Functions
FIXPARALLEL
Fragmentation Reduction on
Exalytics Servers
Hybrid Aggregation Mode in BSO
Force CalcParallel
Essbase 11.1.2.3.500 - Expanded Parallel Scripting Options
FIXPARALLEL
• Execute any FIX blocks in parallel, overcomes restrictions of
CALCPARALLEL
• Give power of parallelism to the users when CALC Parallel cannot parallelize the
scripts
• Enables parallelism for DATAEXPORT, DATACOPY, scripts with
variables and more
Script Performance Improvement
FIX 22.19 Sec
FIXPARALLEL 4 5.94 Sec 3.7 X
BEFORE
FIX ( @RELATIVE(“Version”, 0))
DATACOPY “100-10” TO “300-10”;
…
ENDFIX
AFTER
FIXPARALLEL (4, @RELATIVE(“Version”, 0))
DATACOPY “100-10” TO “300-10”;
…
ENDFIXPARALLEL
Sourc
e: O
racle
11.1.2.4 – Highlights
Now available on edelivery.oracle.com
• HFM available on Exalytics
• Hyperion Planning
• enriched with PBCS improvements
• Tablet UI optimization expansion (modules, admin functions)
• HPCM Management Ledger Allocations
• FDMEE intra-EPM data synchronization
• EPM Mobile expanded to include FCM and DRG
• New FCM Module Supplemental Data Manager
• New Module Tax Governance Sourc
e: O
racle
What’s new in Essbase 11.1.2.4
New Features
• Thread pool for parallel operations
• XML outline editing
• Enhancements to Hybrid Aggregation
• Exalytics optimizations
• Support for POV and Pivot enhancements in Smart View 11.1.2.5.400
• Calculation enhancements
• Essbase.cfg Changes
• MaxL grammar changes
• Deprecated/desupported options
Thread Pool for Parallel Operations
• New Essbase.cfg setting – WORKERTHREADS
• Controls how many threads are available for:
• Parallel calculation, with CALCPARALLEL or FIXPARALLEL
• Parallel data load, for aggregate storage and block storage databases
• Parallel export, for block storage databases
• Parallel restructuring
• Default setting is half of the SERVERTHREADS Essbase.cfg setting
• Default SERVERTHREADS is 20
• Minimum value is 5, maximum is 2048
• These are advanced optimization settings, any changes to these settings
should be tested thoroughly.
XML Outline Editing
• Through the Essbase Java or C Main API, XML files may be exported
from an Essbase database outline
• The XMLs can be edited outside of EAS, then uploading using the
Java or C Main API to make the changes to the .otl file
• This method requires no dimension build rules file or calls to the Outline
API
• To use this feature with ASO outlines, the outline must be updated to
the 11.1.2.4 version
• Open and save the outline in 11.1.2.4 EAS
• Use the C or Java APIs to update the version
• BSO outlines may be edited using this feature without updating them
first.
Enhancements to Hybrid Aggregation
• Hybrid Aggregation is the
biggest thing for Essbase since
version 7 when ASO was
introduced.
• Hybrid Aggregation ripe for use in
all types of traditional BSO
applications
• Applies to Planning BSO plan
types as well
• Great way to get around the
limitation on ASO plan types for
EPMA-deployed Planning apps
Enhancements to Hybrid Aggregation, cont.
• Hybrid aggregation was introduced in
11.1.2.3.500
• Dynamically aggregates Sparse dimensions
like ASO
• New for 11.1.2.4:
• Time-balance functionality supported
• Dynamic Time Series members supported
• Many calculator functions now supported
• If a function is not supported by Hybrid
Aggregation, Essbase will default to block
storage execution for that formula.
Folder Structure for Hybrid cubes
• ASO folder structure is added
• Default
• Log
• Metadata
• Temp
• Folders are removed when database is stopped
• To change the location of the directories, edit the following setting in
essbase.cfg:ASODYNAMICAGGINBSOFOLDERPATH [appName] path-to-
directory
How to implement
• To take advantage of Hybrid Aggregation
• Add a parameter to the Essbase.cfg file to turn this feature on.
• Take your sparse dimensions and mark upper-level members that
calculate with outline operators as Dynamic Calc instead of Store
• This will allow the dynamic aggregation to take place
• May need to change dimension order and/or Sparse/Dense settings to
ensure member formulas are calculated correctly
ASODYNAMICAGGINBSO Config setting
Setting Result
ASODYNAMICAGGINBSO NONE Turn off Hybrid for all BSO databases, except where overridden
ASODYNAMICAGGINBSO FULL Turn on Hybrid for all BSO databases, even when not specified
ASODYNAMICAGGINBSO Sample NONE Turn off Hybrid for the Sample application, even if ASODYNAMICAGGINBSO FULL is specified
ASODYNAMICAGGINBSO PARTIAL Behavior as FULL
Outline Example
Functions Not Supported in Hybrid Aggregation
@ACCUM
@ALLOCATE
@ANCEST
@ANCESTVAL
@AVGRANGE
@COMPOUND
@COMPOUNDGROWTH
@CORRELATION
@CREATEBLOCK
@CURRMBR
@CURRMBRRANGE
@DECLINE
@DISCOUNT
@GROWTH
@INTEREST
@IRR
@IRREX
@MDALLOCATE
@MDANCESTVAL
@MDPARENTVAL
@MDSHIFT
@MEMBER
@MOVAVG
@MOVMAX
@MOVMED
@MOVMIN
@MOVSUM
@MOVSUMX
@NPV
@PARENT
@PARENTVAL
@PTD
@SANCESTVAL
@SHIFT
@SLN
@SPLINE
@STDEV
@STDEVP
@STDEVRANGE
@SYD
@TREND
@XRANGE
@XREF
@XWRITE
Not Supported for Hybrid Aggregation
• Attribute calculations
• Formulas with cross-dimensional operators
• Dynamic Calc members with formulas that are a target of transparent
partitions
• Queries which include both two-pass and one-pass dynamic calc
members from the same dimension
• XOLAP
• Can't use report scripts or dataexport to pull data from upper levels in
Hybrid mode- have to use MDX
• If a query mixes supported and unsupported hybrid mode calculation
types, Essbase defaults to block storage execution.
Exalytics Optimizations
• Additional tuning added to increase performance on Exalytics servers
• An increase virtual memory usage is expected
• Virtual memory usage is increased by the size of the page files
POV and Pivot Enhancements for Smart View 11.1.2.5.400
• Smart View 11.1.2.5.400
• Multiple members can be pivoted
from the grid to the POV toolbar
• Multiple members can be pivoted
from the POV toolbar to the grid
• A single dimension can remain in
the POV toolbar
• Prior releases allowed only one
member to be pivoted between
the POV and grid. Also needed at
least two dimensions in the POV.
Calculation Enhancements
• @RELXRANGE
• New function that returns a cross dimensional list based on the relative
position of the cell that is currently being calculated and the offsets
• More support for the XrangeList parameter
• Now supported in 27 functions
• XrangeList logically combines members at the same level from two or more
dimensions
• Helps to traverse separate year and period dimensions as if they were one
continuous list of members
• @XRANGE (Actual->Jan, Budget->Mar)
Essbase.cfg Changes
• New Configuration Settings
• WORKERTHREADS – covered earlier
• Defines the number of threads available for parallel operations
• CRASHDUMPLOCATION
• When CRASHDUMP is enabled, this setting provides the location where
the core dump files should be saved.
• Core dump differs from an .xcp file
• CONNECTIONTIMEOUT
• Maximum time Essbase should wait for a SQL connection before timing
out
• QUERYTIMEOUT
• Maximum time Essbase should wait for a SQL query before timing out
MaxL Grammar Change
• Export data now offers an
anonymous export option
• export database <dbsname>
all data anonymous…
• Allows customers with sensitive
data the ability to provide copies
of their data to Oracle Support or
partners like interRel without the
fear of data disclosure.
• Each data cell in the block is
replaced with an iterated number.
Features No Longer Supported
• Essbase Native Security Mode
• Essbase Native Security is the non-Shared Services mode, managed in EAS
• Pre-System 9 method of administering users and groups
• This is not Shared Services Native Users or Groups
• Essbase Integration Services
• Same functionality available in Essbase Studio
• Visual Basic API for Essbase
• Oracle recommends using the Java APIs or the Essbase C APIs
• Essbase.cfg Settings
• PRELOADALIASNAMESPACE
• PRELOADMEMBERNAMESPACE
• PRELOADUDANAMESPACE
• MAXACTIVEUPDATETRANSACTIONS
• MAXTOTALACTIVETRANSACTIONS
Featured Deprecated
Deprecated features are fully functional and supported, but will no longer
be supported in the next release
• Direct I/O
• Block storage outline
synchronization
• Outline change log
• Currency conversion applications
and currency partitions
• Zlib and None Data compression
types
• Linked partitions
• EAS Java API
• NFS protocol on NAS devices
• MaxL Statements:
• Alter user statement (add to group
and remove from group)
• Create group/user statements
• Display group/user statements
• Drop group/user statements
(except the from security_file
grammar)
What’s new in Exalytics X4-4
February 27, 2012
REDWOOD SHORES, CA, Feb 27
(MARKET WIRE) -- Oracle (NASDAQ: ORCL)
Oracle today announced the availability of Oracle
Exalytics In-Memory Machine, the industry's first
high-speed engineered system featuring in-memory
business intelligence (BI) software and hardware to
deliver extreme performance for analytic and
performance management applications.
Exalytics X4-4 Overview
• New chipset
• Intel Xeon E7-8895 v2 processors, custom built for Oracle
• Used in Exadata X4-8 and Exalytics X4-4
• 50% more CPU cores over X3-4 processors
• 50% higher clock speed over X3-4 processors
• More memory
• 50% more memory available over Exalytics X3-4 (when X4-4 is
upgraded to 3 TB of RAM)
• Better Performance
• Nearly twice the performance over Exalytics X3-4
Exalytics In-Memory Machine
HardwareTimesTen/Oracle In
Memory 12C/Essbase
for Exalytics, In Memory
Analytics
Oracle BI
Foundation Suite
Hardware – X4-4
• Announced Open World 2014, Replaces X3-4
• Four Intel Xeon E7-8895 v2 processors• 15 adjustable CPU cores each = 60 cores
• CPUs custom built by Intel for Oracle
• 2 TB of RAM (upgradeable to 3 TB)
• 2.4 TB of PCI flash (upgradeable to 4.8 TB)
• 7.2 TB of hard drive
• High-speed network cards
• 2x40 Gbps Infiniband
• 4x1 Gbps Ethernet
http://oracle.com.edgesuite.net/producttours/
3d/exalytics/index.html
Exalytics T5-8
Introduced Sep 12, 2013
First announced at Open World 2013
X = intel Cores
T = Solaris Cores
Second character = generation of chips
Third character – number of sockets
X4-4 VS T5-8
Component Exalytics X4-4 Exalytics T5-8
CPU cores 60 Intel Cores 128 SPARC T5 Cores
Main Memory 2 TB -> 3 TB 4 TB
PCIe Flash Storage 2.4 TB -> 4.8 TB 3.2 TB
Hard Disk Capacity 7.2 TB 7.2 TB
Operating System Oracle Linux Oracle Solaris
Endeca Information Discovery
Large scale consolidation
ZFS file system with snapshot capability
Pricing – High Level
• Exalytics X2-4 is $135,00 plus software*
• Exalytics X3-4 is $175,000 plus software*
• Exalytics X4-4 is $175,000 plus software
• Exalytics T5-8 is $ 330,00 plus software
• All pricing is public:
• *No longer on price list
You will likely want more than one
• Supports both Essbase and BI on the same server but in real life you may
want to split
• Depends on how much data, number of users, processes, etc.
• Beta testers tested Essbase only on the Exalytics server or OBIEE
only on the Exalytics server
• Test and Production instance
• Cluster for High Availability
• Scale to More Users and Applications
• All of our customers purchased 2-5 Exalytics servers
7
Value Add
• Time to Market
• Installed quickly
• Migrate RPDs
• Can get performance benefits just from the hardware without running
Summary Advisor
• Happy Users – Speed of Thought Visualization
• Automatic movement of data driven by the end user experience and existing BI
models
• Re-purpose resources / reduce consulting
• Eliminate need for ETL or DB experts
• Reduce consulting and internal resources to tune data
• Repurpose FTEs to value added analysis
7
Improved Analytics Performance
• Performance improvements found up to:
• 6x Planning cycle time
• 30x Calculation time
• 79x Query time
• Purchases occurring
• During new server purchases
• During server refreshes
• To improve performance
Real World Success Story
Benchmark Hardware
• IBM Power 595 (9119-FHA)
• 32 Core 64-Bit Power6 Processers running @ 5.0 GHZ.
• 4 cores dedicated to Virtual IO.
• Split into 4 separate LPARS
• 96 Gigabytes RAM
• 2 Terabytes EMC Storage
• AIX 6.1
BSO Performance
• Saw over 2-3X improvement
across the board.
• Serial calculations
represented roughly 200,000
lines of calculation script
code.
• BSO data loads weren’t
tested because the
benchmark process didn’t
have a load over 2 seconds.
• Export = 2 Gigabytes @
level0.
0100200300400500600700800900
WLP
Exalytics
BSO Performance (Continued)
200
210
220
230
240
250
260
Calcs
Calcs
• Optimizing data cache and
index caches improved
performance.
• As today, must empirically
optimize cache settings on
a per application basis.
• Performance could get
worse if cache is set too
high.
ASO Performance
050
100150200250300350400450
WLP
• Buffer loads saw a 2X
increase. Already
loading in memory.
• Commits and aggs
performed 3-4X better
• Setting the Pending
Cache Size Limit
improved performance.
Set too high and
performance went down.
ASO Query Performance
0
10
20
30
40
50
60
MDX ReportScripts
WLP
Exalytics
• Baseline MDX times from
Financial Reporting Server logs.
• Did not have FR on Exalytics,
so we extracted FR MDX from
logs to run on Exalytics.
• MDX Query times had the
biggest variability improvement
– from 2-8X better
• 95% of our queries are fast, so
we looked for large dynamic
Hierarchies with lots of formulas
for test.
Summary Highlights
Cutting
Edge
Essbase
Edward Roske, CEO & Oracle ACE Director
For a copy of the slides: info@interRel.com
For free videos: epm.bi/videos
Follow me on Twitter @ERoske