You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Move ASO Data to a BSO Cube

Received Response
94
Views
10
Comments
edited Jun 12, 2018 6:39PM in Planning 10 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!