ASO Design

During design, understand ASO reporting and how to optimize data retrieval from ASO applications.

Watch this video to learn more: video icon Application Design for EPM Planning (Part III): ASO, Datamaps, and Smart Push.

Optimize Data Retrieval from ASO

Follow these key best practices for ASO.

  • Enable query tracking for the cube.

    • Run a few Smart Push activities that are representative of user activity.

    • Run any reports that query ASO data.

  • Build the optimal number of aggregate views.

    • Perform the aggregate action again, including query tracking.

    • Using 2.00 to 10.00 times the size ratio works for most applications.

    • If query tracking for all your processes is not feasible, try using a 10 times size ratio.

    • This aggregation process needs to be executed any time a process drops the aggregate views.

    • This can be executed in a scheduled job during slow or off hours.

  • Review the dimension hierarchy types.

    • Each ASO dimension is assigned a hierarchy type: store, dynamic, or multiple.

    • Because the hierarchy types you choose impact the number of aggregate views that can be created, Oracle recommends the following:

      • If possible, use only store type dimensions.

      • Use dynamic dimensions only if multiple or store type dimensions cannot be used .

      • For multiple hierarchy dimensions, set generation 2 to store rather than dynamic, if possible.

      • The account dimension must always be dynamic because it is the ASO compression dimension.

      • Avoid having members shared multiple times under the same parent. This forces you to make the hierarchy dynamic.

Best Practices

Follow these best practices for ASO cubes:

  • Merge data slices and remove zeros. Run the Merge Slices job periodically to merge incremental slices to the main slice. Limit the incremental slices to small sizes during user activity so that the slices can be auto-merged.

  • Large data movements negatively affect the query performance of ASO cubes and thus slow down Smart Push. Perform several small Smart Pushes to move data into the ASO cube instead of doing one large push.

  • Compact the outline.

  • Review the dimension hierarchy types.

  • Build the optimal number of aggregate views.

Resources: