Select the scenario in which block storage must be used instead of aggregate storage.
A.
Incremental data loading
B.
Top – down planning
C.
Extremely sparse data sets
D.
Millions of members in the outline
Explanation:
BSO is preferred to ASO in the following scenarios:
* Top-down planning and allocation (Sales Forecasting)
* Cost Allocations across products and customers (Profitability Analysis)
* Currency conversion, inter-company eliminations(Financial consolidations)
Ref:
http://gerardnico.com/wiki/epm/essbase/storage
http://bidirect.blogspot.in/2013/08/oracle-essbase-aso-vs-bso-cubes-vs.html
Thanks amie, good article to compare essbase ASO(sparse large dimension) and BSO(dense few dimension)
B
Essbase provides aggregation storage option for sparse data set with large number of dimensions and members, aggregation storage is normally for operational data; Essabase provides block storage option for dense data set with few number of dimensions and members.One typical analysis BSO is the top-down planning which required data to be loaded to upper-level members; one typical analysis ASO is the customer analysis which is on million customers with a large number of dimension.