Partitioning data from BSO to ASO cubes
In this recipe, we will use the Aggregate Storage Outline Conversion Wizard to convert the Sample.Basic
block storage to an aggregate storage database. We will then clear the new aggregate storage database using replicate partition to load data from the source cube Sample.Basic
to our new ASO database.
Getting ready
To get started, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Administration Services | Start Administration Services Console. In the Log in menu, enter your Administration Server, Username, Password, and click on the Log in button.
How to do it...
In EAS, click on the File menu, click on Wizards | Aggregate Storage Outline Conversion, click on the Essbase Server tab, click on the Look in drop-down box, click on the Sample application, double-click on Basic, and select
Basic.otl
. Your screen should look like the following image:Click on the Next > button and you will get a list of errors that you...