File Library


Time to Spread the Wealth: Essbase Allocations Made Easier Using ASO and BSO Cubes
Topic: Essbase
Owner: Anju Rao
Date: 2014-07-03
Subtopic: Tips and Techniques

When customers deploy an Essbase allocation application, this is often the story:

At first, the application is a revelation. It’s fast, it allocates correctly, there is minimal downtime, and reporting has never been easier. Users rejoice, and congratulations are bestowed. Then, as time goes on, issues begin to arise as the business inevitably changes.

- Allocations start to take longer as the volume of data increases.
- Users are unable to report results as cube processing begins to creep into business hours.
- Prior periods cannot be reallocated without manual intervention from both IT and the business.
- Both the # of dimensions and their structure become limited by the performance constraints of Block Storage
- Functional buy-in deteriorates, users lose confidence in the data, and allocations return to Excel.

Join us as we present a different ending to this story and put your mind at ease. We will present a variety of solutions that we have deployed to address the above concerns at a wide range of clients. Solutions will touch on the considerations for using ASO/BSO together, conceptual usage of ETL to facilitate data flow between the two applications, and general lessons learned from employing this type of solution.


Download File   ARao_PCaruso-KScope14 Essbase_Allocations_Final.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database