All things to all men?
_It isn’t going to happen in 50 minutes, but I can give you a start
_Harder to convert than it looks
_Complexity trumps size, although a small database misses the challenges of those really large databases
_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
_Folder structure on disk
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