5 Replies Latest reply: Jun 20, 2010 1:59 PM by JohnGoodwin RSS

    Copy Planning cube to ASO cube

    774005
      Can some one explain me how to copy planning cube to ASO? is there any documentation?

      how to Create a partition between the Planning cube (Level 0 accounts) and ASO cube (Parent accounts) ?
        • 1. Re: Copy Planning cube to ASO cube
          JohnGoodwin
          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

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Copy Planning cube to ASO cube
            774005
            John,

            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?
            • 3. Re: Copy Planning cube to ASO cube
              JohnGoodwin
              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.

              Cheers

              John
              http://john-goodwin.blogspot.com/
              • 4. Re: Copy Planning cube to ASO cube
                774005
                John,

                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?
                • 5. Re: Copy Planning cube to ASO cube
                  JohnGoodwin
                  It will not convert bso formulas to mdx, you will need to convert them yourself.

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/