Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Usage of ASO cubes

adnan645Apr 17 2018 — edited May 11 2018

Hi,

I understand little bit about ASO cubes that they are faster and accommodate less Business Rules as compared to BSO cubes. I have also read about all other differences between the two. But still I couldn't understand how to bring ASO into use:

  1. How is the data transferred from BSO to ASO Cube? (in PBSC it's through smart push and on-premise through XREF? OR we just enable the members for specific ASO plan, then any report/form created in ASO using that members will show the data)
  2. If spare dimensions have parents set to store in BSO cubes and aggregations have been run, then form/report would show the data quickly on parents as it would do for the zero level members. If this is the case even then why do we need ASO?
  3. In PBCS, we have one Consolidating ASO cube, is it different in some way than other ASO cubes?
  4. Can anyone please share the real scenario in which he made use of ASO and how did he do that?

Thanks

This post has been answered by Srini+K on Apr 17 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2018
Added on Apr 17 2018
7 comments
969 views