This discussion is archived
5 Replies Latest reply: Jun 20, 2010 11:59 AM by JohnGoodwin RSS

Copy Planning cube to ASO cube

774005 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    It will not convert bso formulas to mdx, you will need to convert them yourself.

    Cheers

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points