This discussion is archived
6 Replies Latest reply: Oct 5, 2011 10:50 AM by JohnGoodwin RSS

Rename Member Using "OUTLINELOAD UTILITY"

841303 Newbie
Currently Being Moderated
HI

I am loading the metadata using the "*Outline Load Utility*" in the Planning Application..

But i was just unable to find the way to rename the existing member.
Can anyone help me out with this.

Thanks
  • 1. Re: Rename Member Using "OUTLINELOAD UTILITY"
    vikasnaidu Explorer
    Currently Being Moderated
    This link might be helpful "Renaming planning members" : -

    http://john-goodwin.blogspot.com/2010/01/odi-series-renaming-planning-members.html
  • 2. Re: Rename Member Using "OUTLINELOAD UTILITY"
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    unfortunately the outline load utility does not let you rename members, if it is only a few members to rename then you can do it in planning, if it is a lot of members then you have to look at an alternative solution.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 3. Re: Rename Member Using "OUTLINELOAD UTILITY"
    841303 Newbie
    Currently Being Moderated
    Thanks a lot Vikas and John,

    I guess i need to work on ODI tool to rename the Existing Members in the Planning application, Since There are lot of member to be renamed.
  • 4. Re: Rename Member Using "OUTLINELOAD UTILITY"
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    It can be done without ODI, the official method would be to export the data against the members you want to rename, rename the members in the data. delete the members in planning using the outline loader, load the new members using the outline load utility, load back in the data.
    The other way is shown in the blog post which can be done without ODI by going direct to the relational tables, this method is not officially supported though.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 5. Update a  Member Property Using "OUTLINELOAD UTILITY"
    841303 Newbie
    Currently Being Moderated
    Hi All,

    I was uploading the Metadata i came accross an Issue.


    My Entity Member has been linked with 3 attributes....

    Entities     "CC Function"        "CC VP"     "CC Director"
    XYZ   ,          M         ,      N         ,    O


    now i wanted to delete the attributes(M, N,O) linked to the Member"XYZ" (they are 50 Members facing same Prob)
    As my Recent outline update made the attributes to link to its child.

    I used the file

    Parent     Entities     Alias: Default     Operation     Base Currency     CC Function     CC VP     CC Director
    ABC , XYZ      ,123      ,Update     ,USD          ,*     , , .*

    for Outlineload Utility_
    But still the "XYZ" entity has been linked to all the 3 Attributes...

    to delete the attributes, Is there any other way in OutlineLoad Utility.cmd
  • 6. Re: Update a  Member Property Using "OUTLINELOAD UTILITY"
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    Try using <NONE> in the attribute column for the member you want to remove the attribute from.

    Cheers

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

Legend

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