This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Jul 30, 2013 2:27 PM by 955124 RSS

Regarding Historical Data/Metadata

955124 Journeyer
Currently Being Moderated

Hello,

 

   Recently one of the BU was changed as BU OLD , there was Data in BU for prior periods . Now that when we have changed the entity as BUOLD I do not see any data for that location any more.

The system tables would have saved the data Irrespective of the change in Metadata right ? Please correct me if i am wrong. And what is the possible solution to get back the old data.

 

Thanks !

  • 1. Re: Regarding Historical Data/Metadata
    GlennS_3 Oracle ACE Director
    Currently Being Moderated


    If ALL you did was to rename the member from BU to BU Old then the data should move with it. If you did something like rename Bu to BU Old and added BU in another location, then the data will move to the new member you called Bu.

  • 2. Re: Regarding Historical Data/Metadata
    955124 Journeyer
    Currently Being Moderated

    Glenn,

     

    BU.Oploc was changed to BU.OplocOld , Original Oploc was taken to BU1.Oploc.

    In a nut shell the Oploc has been moved to new BU, thats the only change . Just that BU.OplocOld is not having the value of BU.Oploc.

  • 3. Re: Regarding Historical Data/Metadata
    TimG Guru
    Currently Being Moderated

    You mention system tables containing data, which makes me wonder this is an HFM (not Essbase) question - just to confirm, which product are you talking about?

     

    If this is an Essbase question, and when you say 'BU.Oploc' you mean 'Oploc' as a child of 'BU', then it sounds like what you did might be the scenario Glenn described, i.e. renamed 'Oploc' then added it back as the child of 'BU1' rather than 'BU'.  If you do this in one step in Essbase the data will all be in the 'new' 'Oploc' member, not 'OplocOld'.

  • 4. Re: Regarding Historical Data/Metadata
    955124 Journeyer
    Currently Being Moderated

    Tim , this is related to Essbase.

    So in that case ,  if Oploc is under different BU how can the previous BU.Oploc combination data sit new BU1.Oploc. That cannot be possible right.

    Ex: X1BU.Oploc be changed to X1BU.OplocOld which should have the data what X1BU.Oploc had .  The old Oploc is in different BU location now  X2BU.Oploc which should have different data since BU is different.

    My whole point is X1BU.OplocOld is not having XIBU.Oploc data.

  • 5. Re: Regarding Historical Data/Metadata
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

    I have other decision for this task.

        One dimension need to split to two dimension : One for Level 0 from source and other from level 1 members from the source. After that you need use Attribute dimensions with mark "old" and "new" cross members. Use attribute dimension in the planning forms for the create correct forms.

     

     

     

    ER

  • 6. Re: Regarding Historical Data/Metadata
    955124 Journeyer
    Currently Being Moderated

    We are not using any kind of forms.

  • 7. Re: Regarding Historical Data/Metadata
    GlennS_3 Oracle ACE Director
    Currently Being Moderated

    suppose you have a member called Bob that has data. Bob is a child of Tim.  You rename Bob to Robert. but at the same time you create a new member named Bob that is a child of Cameron. When you save the outline, Essbase thinks you moved Bob from Tim to Cameron so it moves the data. Cameron has now adopted Bob since the system thinks Tim Abandoned him.  It thinks Robert is a new member so it has no data.

    In order to do something like this it has to be done in multiple steps. Rename Bob to Robert then save the outline, then add the bew Bob and save the outline again.

  • 8. Re: Regarding Historical Data/Metadata
    955124 Journeyer
    Currently Being Moderated

    Glenn,

     

      But here going by you Naming conventions , there is no data when Bob is moved from Tim to Cameron. That is what it was supposed to be . We are good till here , Only concern is Bob renamed as Robert doesnt have data which should be manipulated as Robert is a child of Tim !!

  • 9. Re: Regarding Historical Data/Metadata
    GlennS_3 Oracle ACE Director
    Currently Being Moderated

    In my example is Bob originally had $10 in it the $10 would be moved from Bob under Tim to Bob moved under Cameron. Robert would have 0 unless you did it the second way I mention

  • 10. Re: Regarding Historical Data/Metadata
    955124 Journeyer
    Currently Being Moderated

    Original - >  xxxxBU.Oploc

     

    Modified - > xxxxBU.OplocOLd

     

     

    Oploc moved to yyyyBU , so original Oploc is sitting as yyyyBU.Oploc  which has no data , and is accepted !!

     

    I am expecting historical data xxxxBU.Oploc to be in xxxxBU.OplocOld.

  • 11. Re: Regarding Historical Data/Metadata
    DanP Explorer
    Currently Being Moderated

    Maybe this is a dumb question but there are some things in your posts that are suspicious:  I think all of the responders are assuming that you have never cleared the cube and reloaded the data for the prior periods?  i.e. the data you want to be reported as "xxxxBU.OplocOld"

     

    To put it another way the data for prior periods originally loaded to xxxxBU.Oploc  you expect should be moved to xxxxBU.OplocOld by the rename of the membername?  If so then if it is not there what did you respond when you saved outline and were asked if the restructure should retain data?

     

    Also did you recalculate your cube?

     

    Finally, I am unable to follow how the yyyBU.Oploc mentioned just above  fits into this whole story.

     

    Maybe you should rewrite the full summary step by step:

     

    1 I had a cube with data loaded to xxx

     

    2 I renamed member

     

    3 I then added a new member to ???? to take data for future periods for xxxbuoploc

     

    4 I modified the load files as follows:

     

    5 I I then loaded a new data for new periods making no changes to the loaded data or b I reloaded the whole cube

     

     

    so step by step

  • 12. Re: Regarding Historical Data/Metadata
    955124 Journeyer
    Currently Being Moderated

    Dan,

     

      You are correct , I expect the data to move from XXXXBU.Oploc to XXXXBU.OplocOld , when there was dimension Update EAS did ask me for "Retain all Data" or "Clear data".

    Pretty obviously I selected Retain all data and completed the Dimension Update process.

     

     

    Thanks for the suggestions Dan ,  YYYYBU.Oploc is nothing but the new BU roll up of the Original Oploc from XXXXBU to YYYYBU.

  • 13. Re: Regarding Historical Data/Metadata
    TimG Guru
    Currently Being Moderated

    I'm not trying to be irritating, but for total clarity could you describe exactly what you did to the outline - one single step at time (along the lines of Dan's numbered example) in order?  Each 'Rename', 'Add', 'Move' and 'Save'.

     

    I also object to Glenn making me a deadbeat Dad in his examples.

  • 14. Re: Regarding Historical Data/Metadata
    GlennS_3 Oracle ACE Director
    Currently Being Moderated

    TimG,

    Since you assumed I was talking about you, there must be merit in it. It could have been anyone named Tim. You will notice I used Cameron and he has not had any comments in this post sequence

1 2 Previous Next

Legend

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