File Library


Pairing BSO and ASO Cubes
Topic: Essbase
Owner: Michael J Henderson
Date: 2013-06-25
Subtopic: Tips and Techniques

We will present how Oracle pushes data from Planning to an ASO reporting cube (hint - no partitions) and why that is the best approach. How to mimic that with MaxL and a custom defined function. Transparent partitions and why validation with no cell count mismatches isn't enough to get good results. Tools for confirming dimensions are perfectly aligned. What are GRIDEXPANSION and FORCEGRIDEXPANSION and why do they matter? Life at level 0: How do we do calculations like allocations that spread rolled up values when, strictly speaking, the BSO cube has no upper level blocks?


Download File   MHENDERSON.PAIRING_BSO_ASO.pptx
Download File   mhenderson.pairing_bso_aso.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