File Library


ASO Design Principles for Financial Reporting
Topic: Essbase
Owner: Gary Crisci
Date: 2014-06-20
Subtopic: Case Studies

Essbase ASO provides a storage architecture optimized for high speed data loads, aggregations, and query response time, when databases are well designed. One challenge with ASO is the restrictions inherent in Stored vs. Dynamic hierarchies and how the tradeoffs necessary to accomplish certain financial reporting tasks result in poor performance. Other challenges with ASO continue to focus on time calculations. In this session, Gary Crisci, Sr. Architect at GE, and Oracle Ace, will demonstrate work arounds to common Financial Reporting challenges in ASO and walk through strategies to convert large BSO applications to ASO. The presentation will include a case study for a large financial reporting BSO cube that was converted to ASO.


Download File   gcrisci.ASODesign.pdf
Download File   KSamp.zip
Download File   ASO Design Principles-Essbase.mp4

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