ESSBASE: ASO - Design Aggregation Does Not Go Up To The Total Storage Space Specified (Doc ID 2132924.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Symptoms

When trying to create ASO cube aggregation views manually in Essbase Administration Services (EAS) console using the Aggregation Design Wizard, it does not use the total storage space defined.  

For example, using the following steps on a particular database:

- Design, Materialize and save aggregation -> Replace/add aggregate view -> Aggregate view selection criteria-> Total storage space -> Set the Total Storage space to 500 MB -> Next/Start.  

results in less views and goes only up to to a size of ~131 meg.  Unable to create multiple views so that it is faster for the end users.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.