Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Renaming members in PBCS

RohitGNov 1 2017 — edited Nov 7 2017

Hi all,

I am working on a requirement to rename all the level 1 parent members (~200) in a dimension. Does anyone know of a way to do this through SV admin extension or "Import Metadata" functionality or any other method rather then going to the members and manually editing them?

Thanks in advance.

This post has been answered by user11440683 on Nov 1 2017
Jump to Answer

Comments

user11440683
Answer

Hi,

you cannot rename a member, the member name is what it is.

You can change its alias.

You can delete the member and add a new member of a different name.

But you cannot rename the member name.

Btw - if you delete you lose any data stored against the member.

To change aliases, export the dimension, look at the file.

Build up a file in the same format with the same headings and delimiters for the columns you need to change.

Validate. Import.

Refresh the DBs.

Marked as Answer by RohitG · Sep 27 2020
user11440683

pastedImage_0.png

user11440683

pastedImage_0.png

user11440683

You can use your spreadsheet tool of choice to parse the columns, change what you need to, cf my original comment on not being able to change member names, save as comma delimited (watch out for commas in the content!) and reimport.

RohitG

Thanks for the input Robert. Here's what I plan to do:

1) Add members with new names as the siblings of the old ones.

2) Move all the children from old members to the new.

3) Delete old members

USER1211

You would want to go and check rules,reports and data forms which those old members are references in also.

1 person found this helpful
user11440683

I would also back up your application / DBs before you start, just in case you do lose any data...

And reconcile before and after.

RohitG

Thanks for your input guys.

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 5 2017
Added on Nov 1 2017
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
8 comments
925 views