Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
How to rename a large amount of members at once in EPMA dimension library?
Hi,
In epma dimension library I can rename a member by right click and select rename, but how can I rename multiple members at once?
I've tried importing a new dimension hierarchy to replace the old one but would cause problems, the forms that uses replaced members wouldn't link to the new ones.
Can anyone help me? I have hundreds of members to rename. Thank you very much!
Eric
Best Answer
-
Hi,
Just want to note down the solution I finally found out is using EPMA-Batch-Client can solve the issue, it has rename function.
Eric
Answers
-
There is no Out of the box way to bulk rename members hence you would need to do it manually.
Additionally since you did not specify what version of Hyperion (including patch level) you are on you need to perform test on your end to ensure you do not loose your data in Essbase when you rename a member from EPMA and deploy as one of the earlier versions of EPMA some folks had noted data loss bug.
The well know John G and Celvin K have written a few blogs about using ODI and some other utilities respectively which you may want to google such.
Also you could always open an informational Oracle SR too and see what Oracle recommends.
Hopefully the information is helpful and let us know how you make out.
Once you got the clarity you needed remember to mark the thread as answered so members can focus on unanswered questions.
Did Your Question Get Answered in My Oracle Support Community (Doc ID 1180503.1) -
Hi,
Just want to note down the solution I finally found out is using EPMA-Batch-Client can solve the issue, it has rename function.
Eric
-
Excellent the belief is you were able to fully test and ensured your data was not lost( the belief is you are on 11.1.2.4.X) when you performed this process. If so other folks on the forum will certainly benefit from the information.