The release of by Oracle showcases the company’s promise of continued investment in Essbase. As illustrated in the diagram below, each release has delivered enhancements for both users and administrators.

EPM delivers several new benefits.  First, Oracle has enhanced block storage performance with parallel calculation, restructuring, data export and data load with cache sizes larger than 4 GB.  The new release also optimizes distinct count calculations on aggregate storage databases (NONEMPTYCOUNT (set, measure, exclude_missing) –nx versus 1x).  Users now have a distinct way to reference shared members in MDX and administrators can change Essbase server and application log levels.  Additional improvements include:

  • MDX Property Expressions
  • Throttle Active Transaction
  • Essbase API Changes
    – Changed C Main API Structures
    – Compiler Support
  • Configuration Setting (Essbase.cfg) Changes
  • SET CALCPARALLEL Calculation Command Enhancement
  • New MDX Functions
    – PROPERTY_EXPR function for querying properties of ancestor members
  • MaxL Grammar Changes

For Essbase Studio, a module that provides a single interface for performing tasks related to data modeling, cube design, and construction of analytic applications, was also improved in release  For instance, using the new “Update Out-of-sync Models” option, you can pick and choose which models to sync, without having to recreate them or reset properties.

A new streaming option in the cube deployment wizard allows the Essbase Studio Server to query external data sources directly, compared to the Essbase Server completing the task. Minischemas are now part of the data source connection and alias sets are now treated as metadata elements, on par with hierarchies, dimension elements, cube schemas, etc.  Release has also streamlined the modeling of Oracle Business Intelligence Enterprise Edition (OBIEE) model sources and allows users to create a cube scheme and model during the data source connection creation process.  Users can also deploy Essbase cubes from within OBIEE.  Finally, the release provides support for Oracle Real Application Cluster (RAC) data sources.

Next up, we will take a dive into Exalytics In-Memory Machine, the industry’s first in-memory BI machine that delivers the fastest performance for business intelligence and planning applications.

Recent Posts

Successful Reconciliation Compliance with Oracle Cloud

Would you like to learn how Key Performance Ideas can help you utilize Oracle’s Account Reconciliation Compliance Module that saves time, rework, and improves accuracy?  How about seeing the same time savings and accuracy every month?  Would you like to have real-time...

read more
Accelalpha + Key Performance Ideas

Key Performance Ideas (KPI) is pleased to announce that Accelalpha has acquired us.

Accelalpha + Key Performance Ideas

Key Performance Ideas (KPI) is pleased to announce that Accelalpha has acquired us.

Schedule Time With Us