What are you trying to achieve, are you trying to copy data from a bso planning application to an ASO database or are you trying to convert a bso planning app to an ASO model (it will not be able to be used as a planning application when you convert)
What type of partition are you trying to create, there is a whole lot of information in the essbase documentation about partitions :- http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_dbag/dotprtde.htm
Thank you very much for the reply during the weekend. They are asked me to copy planning bso cube to ASO. I am also not clear exactly what they are looking.
AS you mentioned, in order to copy data from planning BSO cube to ASO, how we do that? first we need to convert planning BSO cube to ASO right by using the conversion wizard? If my approach is right can you tell me how to copy data after creating ASo Cube?
I think you need to go back to whoever requested the development work and get full requirements, that will define what you need to do.
If you want to covert a BSO database to ASO you can use the wizard in EAS.
If you want to copy the data you can export data the data from the BSO database and then load into the ASO database
or depending on the requirements you could look into partitions.
I got confirmation from them. It is same as i mentioned earlier. we need to convert Planning BSO to ASO and then create a partition on both cubes.
I created ASO cube from Planning BSO by using the wizard but it thrown so many errors. I think i need to fix all the mdx forumulas in ASO cube right? or when i use the wizard will it not fix all the member formulas by itself?