1. Administering FreeForm
  2. Managing Applications
  3. Adding an Aggregate Storage Outline to an Application
  4. About Aggregate Storage

About Aggregate Storage

Aggregate storage is the database storage model that supports large-scale, sparsely distributed data that is categorized into many, potentially large dimensions. Selected data values are aggregated and stored, typically with improvements in aggregation time. Aggregate storage is an alternative to block storage (dense-sparse configuration).

Aggregate Storage Outline Cube Characteristics

  • The application doesn't generate XREFs on aggregate storage databases. XREFs can only be generated on block storage databases.

  • Dynamic time series members are not applicable for the Period dimension in an aggregate storage application.

  • Creating and refreshing security filters are not applicable for aggregate storage databases.

Troubleshooting

Performance of aggregate storage reporting cubes is governed by many factors, including the number of slices in the cube, the outline of the cube, and the type of dimensions in the cube. See Optimizing Aggregate Storage Option Cubes in Oracle Enterprise Performance Management Cloud Operations Guide.