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!

@CalcMgrMDXDataCopy Data or Partition copy in Essbase BSO to ASO

VINAYSOct 17 2019 — edited Oct 17 2019

Hi Gurus,

We have a situation where the current BSO application is taking too much of time to aggregate and we have been asked to provide an alternate where in we are planning to propose a BSO ( for data load and calculation ) and ASO for reporting.

We are analyzing an option of both partition and @CalcMgrMDXDataCopy , we have source data which has about 10 Million records that get loaded ( multi period for 12 months ) . I am just worried about performance as a whole for a huge data set. Since both the hierarchies are like to like there isn't much mapping issue. And we are looking at an option to transfer whole set of data from BSO to ASO.

Has anyone faced any such situation and any suggestions for the same. Any other alternate would also be welcome.

Thanks in advance.

Added on Oct 17 2019

#business-intelligence-applications, #calc-manager

0 comments

348 views