v2.15.10 Page 1 of 5
Year Milestones Details
1991 • Arbor Software releases Essbase v1 • Time & Financial Intelligence • Multi-user Read/Write • Spreadsheet Macros
1992 • Essbase v2 • Application Manager – first GUI for creating OLAP applications: o Codeless environment
o Drag-n-drop functionality o Validation routines o Scripting environments
• First Multi-platform OLAP Product 1994 • Arbor Software receives U.S. patent
for Essbase
1995 • Essbase Web Gateway • Ad-hoc Tool for analyzing OLAP data: o Thin Client
o HTML-based
o Highly scalable and fast response 1997 • Essbase Adjustment Module
• Essbase v5
• Supports “light-weight” consolidation • Dynamic Calculations
• Dynamic Time Series; a.k.a. “To-Date” • Partitioning
o Replicated o Transparent o Linked Partitions • Greater Scalability
o Cube Calculation Process Tied to CPU • Built-in Functions
1998 • Essbase Objects
• Essbase Integration Server
• Arbor Software merges with IMRS to become Hyperion
• 1st integrated set of ActiveX controls for VBA Development • GUI for building applications from DW or Star relational sources • Provides contextual drilling for spreadsheet users
2000 • Essbase v6 • Attribute Dimensions
• Query Designer
• Cross Cube calculation functionality • Forecasting, Trending & Allocations • Extensible Function Library
o I.e., user-defined custom functions • Extensible Calculator
o E.g. email alerts, calculator functions, etc. • Parallel Functionality for Data Exports • Performance Statistics for Essbase Server • 1st OLAP Server to Support Linux
v2.15.10 Page 2 of 5
Year Milestones Details
2001 • Essbase v6.2
• Essbase Integration Services v6.2
• Essbase Deployment Services v6.2
• Essbase Administration Services v6.2
• IT Deployment Enhancements o LDAP integration
o Parallel Data Load o Session Management • Supports drill to Teradata • SQL override functionality
• 1st Mid-tier Technology for Deploying OLAP • JAVA API
• Web Services
• Connection Pooling, Query Failover and Cube clustering • Next Generation GUI Application Manager
• Multi-server Support 2002 • Essbase v6.5
• Essbase Integration Services v6.5
• Essbase Administration Services v6.5
• Essbase Deployment Services v6.5
• Essbase Spreadsheet Services v6.5
• Hybrid Analysis • Parallel Calculation
• Enhancements for Hyperion Planning • Multi-source connectivity
• Enhanced SQL override
• Wizards for Application & User Migrations between Essbase Servers
• Smart Editors
• “Fire-n-Forget” for Batch Processing • HTTPS Support
• Thin-client, Web-deployable spreadsheet add-in • Utilizes EDS for Failover, Connection Pooling, etc • Provides Domain View of Essbase Applications
2003 • Essbase v7 • Predictive Analytics
o Data Mining Framework o Write Triggers
o Sampling • MDX support
• Attribute Dimension Support for Hybrid Analysis • Metadata Security
• Unicode Applications for Global Deployments • Common Installer for Windows
v2.15.10 Page 3 of 5
Year Milestones Details
2003
(cont.) • Essbase Integration Services v7.0
• Essbase Administration Services v7.0
• Essbase Deployment Services v7.0
• Essbase Spreadsheet Services v7.0
• Drill-through adds Parameterized URL Support • Mainframe DB2 as Source
• Initial Integration with Hyperion Hub • Common Installer for Windows • Redesigned GUI
• Wizards • New Editors
• Initial Hyperion Hub integration. “Batteries included” for common components
• Focus… Needs of ESS • XMLA Web Service.
o Hyperion is a lead author of the XMLA specification o 1st Release of XMLA for Hyperion
• Outline Caching • Batteries included • Common Installation
• Near Parity with “Classic” Spreadsheet Add-in • Common Installation
2004 • Essbase v7X (aka v7.1.3) • Aggregate Storage Option
o 100x Data Scalability over Essbase v6 More Dimensions
More Members per Dimension o 10x Faster Load & Calc
Allow for a “balance” between query performance and disk space
o Optimization of Sparse Data Sets o 20x Smaller Footprint
o Native 64-bit edition on Itanium
2005 • Essbase v9 • Duplicate Member Names
• Smart View for MS Office o General analytic capability
Query designer Linked views
o Hyperion Planning enhancements UI for Planning off-line
Leveraging MyAnalytics o BI + repository
Run-time prompt support in Reports Multi-page support
v2.15.10 Page 4 of 5
Year Milestones Details
2005 (cont.)
• Essbase v9 (continued)
• Information Age rates Essbase as one of the Top 10 Most Influential
Technology Innovations of the previous 10 years (along with XML, virtualization, Netscape, Google, VOIP, Linux, and the Pentium processor)
• ASO
o Restructure o Export
o Improved Compression
• Substitution variable enhancements o Outline formulae
o Partition definitions o MaxL and MDX scripts o Data load rules
• Advanced relational access • Data mining
o Scoring
o Transformations o PMML importing
• Common User Provisioning shared across all Hyperion offerings (BI tools, EPM apps and Essbase)
• Hyperion Visual Explorer option
2006 • Essbase v9.2 • Clustered Drill-back
2007 • Essbase v9.3 • 64-bit editions for Solaris, AIX, Xeon and Opteron • Analytic Provider Services
o Replaces Analytic High Availability Services (AHAS) o Smart View “Provider”
o Java API for stand-alone .JAR deployment o XMLA API
Rewritten to XMLA standard
Supports JPivot, MS Reporting Services • MaxL Encryption
• Reference Cubes
o In-Memory cubes for rapid @XREF calculations • ASO:
o Time Intelligence o Time balance Tags o Intelligent Aggregations o Write-Back
o Data Streaming • BSO
o Subset export
v2.15.10 Page 5 of 5
Year Milestones Details
2007 (cont.)
• Essbase v9.3 (continued)
• Oracle acquires Hyperion
• Smart Space gadgets for MS Windows
• Smart Search (Google or Oracle Search runs Essbase query) • Support for Office 2007
• MS Analysis Services Conversion Utility
2008 • Essbase v11 • Varying Attributes
• Text and Date Measures
• Back-Up, Recovery, Transaction Logging and Replay • ASO:
o Trickle Feed
o Write-Back to Level 0 o Partial Data Clear
o Direct Target of a Partition
• Essbase Studio – New GUI for Essbase application design o Consolidates Cube Construction Activities
Replacement for Essbase Integration Services (EIS) & Essbase Administration Services (EAS)
Unifies deployment and management of cube factory o Unifies modeling of many sources
RDBMS | Flat files | EPM Architect Dimensions OBIEE
o Creates Reusable Objects at a Granular Level Hierarchies | Metrics | Dimension | Elements o Lineage Tracking
o Drill-Through Reports
Relational, OLAP Cubes, URL, BI+ Repository and Java Method as drill report targets
Define which columns can be drilled
Control aggregation rules and customize the SQL Row Governors
• XOLAP – Cube metadata design in Essbase with actual data storage in existing relational source
• Oracle BI EE Integration
o OBI EE as a Data Source for building Essbase cubes o Essbase as “Aggregate Persistent Storage” in Oracle BI
Metadata 2009 • Essbase v11.1.1.3 • ERP Integration
o Both Data and Metadata from ERP into Essbase o Drill-back from Essbase summary to ERP detail • Crystal Ball Integration