File Library


A BSO Developer’s Introduction to ASO Essbase
Topic: Kscope13 Recordings
Owner: Cameron Lackpour
Date: 2013-05-26
Subtopic: Essbase

All things to all men?
_It isn’t going to happen in 50 minutes, but I can give you a start
Why Sample.Basic?
_Harder to convert than it looks
_Complexity trumps size, although a small database misses the challenges of those really large databases
ASO basics
_ASO versus BSO architecture concepts
__A black box engine revealed, a little bit
__Exploded blocks versus in-memory calcs
__MDX in lieu of BSO calc engine
Designing for ASO
_Hierarchies should almost always be stored, and always fit in memory
_Dynamic calcs good (usually) in BSO, bad in ASO because there are no ASO calcs, and MDX is slow
_Shared hierarchies are free in ASO, expensive in BSO
_Attribute dimensions are free in ASO, sparse dynamic in BSO
_Loading movement instead of balances, the engine makes it better
_Calculation order far beyond TWO PASS
_How Stored dimensions, and particularly Accounts, affect data
_Time is the same, but very different
Other things that look the same, but aren’t
_Unique MaxL
_Folder structure on disk


Download File   CLackpourABSOsDevelopersIntroductiontoASO.pdf
Download File   Grand Ballroom D Session 13.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