Call us: +1-786-629-6893 (USA) | +91 755-491-0482 (India)

Essbase ASO Allocation

What is Hybrid Aggregation Mode

Hybrid Aggregation Mode is an option applied to BSO Essbase cubes that combines the strengths of BSO and ASO into single cube. In simple terms, the bottom of the cube is BSO, while upper-level sparse member combinations are

calculated dynamically… Like ASO Method .

Advantages & Benefits :

  • Sparse Aggregations are faster.
  • Sparse Dimension Do not need to be aggregated. Just like an ASO cube.
  • Hasel Free for Developers.
  • Only Few Blocks will be created. Hence Database restructure is faster.
  • Faster Batch Time and lower disk space requirements.
  • Important benefit it reduced complexity.
  • Reduce to design both ASO and BSO combination.
  • Reduce the performance of Dynamic Sparse Calculation

The Steps :

The main steps for leveraging Hybrid Aggregation Mode are as follows:

  • Create a BSO Essbase Cube
  • Modify the Essbase Config File
  • Set Upper-Level Sparse Members to Dynamic
  • Load Data
  • Calculate “Base” Blocks (if necessary)
  • Retrieve Data
  • Review the Log File

Step 1: Creating a BSO Essbase Cube:

Step 2 : Modify the Essbase Config File :

To enable Hybrid Aggregation Mode, a setting is required in the Essbase Config file called “ASODYNAMICAGGINBSO”. This setting can be enabled or disabled for an entire server, application or specific database.

We can select from “Partial”, “Full” or “None” mode.

  • Partial enables Hybrid Aggregation Mode for simple outline aggregations (+, -, ~) only. Everything else (formulas, other unary operators, etc) will fire in Block Storage Mode.
  • Full enables Hybrid Aggregation Mode for simple outline aggregations (+, -, ~) and

for certain formulas.  Note that there are quite a few limitations that we will cover later.

  • None disables Hybrid Aggregation Mode. This is the default.

Step 3: Set Upper level Sparse Members to Dynamic :

If you’ve worked with Essbase for very long, you probably know that Dynamic calculations work best with Dense dimensions and can be used sparingly with certain Sparse dimensions. But under no circumstances would we ever set all of our upper-level Sparse members to Dynamic . until now.

It seems crazy, but if you want to leverage Hybrid Aggregation Mode, you will need to set at least some of your upper-level sparse members to “Dynamic Calc”. In this example, I’m going to set them all to Dynamic. Just remember , any sparse members not set to dynamic will need to be aggregated with a calc script (assuming they are aggregated dimensions).

Step 5: Calculate "Base" Blocks (if necessary)

If you’ve ever written a procedural calculation for an ASO cube, you know they’re a bit clunky (even with the enhancements to Calc Manager). Hybrid Aggregation Mode gets us away from this technology by allowing us to use BSO Calc Scripts against the BSO portion of the cube. Remember, the “BSO portion of the cube” is represented by the non-dynamic sparse member combinations. In my example, this is simply level zero sparse members (because I set all aggregated upper-level sparse members to “Dynamic Calc”).

So if you need to run a stored calculation, break out your old BSO calc scripting skills! But make sure you only reference the BSO portion of the cube in your calc script, otherwise, you’ll tak e a performance hit.

Step 6 : Retrieve Data

We can now retrieve data at upper-level sparse member combinations, and we never had to aggregate our cube. In fact, our cube has no upper-level blocks at all.

  • In Hybrid Aggregation Mode, the query only took 0.129 seconds (with no tuning whatsoever).
  • In Block Storage Mode, without pre-aggregation, this query would have required over 20,000 blocks.

 

 

 

 

 

 

 

Why BISP Solutions?

 

We are focused on Enterprise performance management, business intelligence, CRM services; application development, Data Migration and support. From managed services and consulting to 24x7 operational support, BISP Solutions has become preferred partner in clients list. BISP's clients include Fortune 100 to mid-sized companies that rely on robust support services that build their revenue-generating data infrastructure.


24*7*365 Support

Cloud Specialists

Onshore /offshore

Highly Skilled Experts