How to Move ASO Data to a BSO Cube

Summary

From an architectural perspective and best practices, BSO cubes are usually used for modeling input data using complex calculations and business logic for producing output data.

Content

From an architectural perspective and best practices, BSO cubes are usually used for modeling input data using complex calculations and business logic for producing output data. From there, the data is moved to the ASO cube and aggregated for the most efficient reporting and usability possible. ASO cubes are aggregated in a bottom up manner with much more efficient aggregation times and thus are better suited to hold much larger amounts of data. Although possible, it is not recommended to model with your ASO cube as that will significantly deteriorate the performance of your cube.