Databases Reference
In-Depth Information
Aggregate Storage Option (ASO)
In Essbase 9.x versions, the ASO is also called
Essbase analytics
. The ASO is most
suitable for the sparser data sets of high dimensionality, allowing a greater number
of dimensions and members. The ASO model is not a replacement for the BSO, but
it is an alternative for the business users depending on the needs of the customer.
In an Essbase Application|Database built using ASO, the data is loaded into the
leaf nodes or lowest levels, but are not aggregated into the upper levels using typical
Essbase
calc
and
store
methods. Rather, they are calculated dynamically on the
fly (per user request).
It must also be mentioned that the ASO is best suited as a
Read Only
application.
It is best used when analysis on large amounts of data is necessary for presentation,
analysis, or reporting purposes.
We will talk more about ASO, and the differences between ASO and BSO, in
Chapter 10.
