As I posted here, there was an issue with rename and that was because the way I was opening the outline.
openOutline() read-only mode was deprecated and now there are 3 options to open an outline
openOutline(boolean)
openOutline(boolean, boolean, boolean)
openOutline(boolean, boolean, boolean, boolean)
I was using the first option openOutline(true) – write mode and keep data in restructure. restructureCube(IEssCube.EEssRestructureOption.KEEP_ALL_DATA) it was removing the data with rename.
They was to set keepTrans to true, from the API guide
keepTrans – true to keep transactions.
If you are opening an existing outline to make changes (readOnly == false), and you intend to restructure the cube and keep data,we recommend that you set this flag to true. When true, a log is kept of activities done to the outline.
If you are starting from an empty outline or are not planning on saving data when you restructure, we recommend that you set this field to false.
When false, no log is kept, saving time and memory.
Note: Take a backup of your outline and data before performing the operations
How it works
Before Rename
The data that you all remember (from our very old Sample Basic)
Create a file in the below format
oldname,newname
You’ll see a similar output.
After Rename
I’ve not included the support for renaming the members in formula. You’ll have to do that manually. The tool will generate an exception if there is a validation error.
You can download the utility from here.
Hey Celvin
Wud the same utility work on planning as well?
Have data on d cube and just want to rename 1000 members.
Thanks
AJ
Nope not on Planning. I hope we get an API for Planning soon 🙂
If you could have the utility change all upper level Sparse members to dynamic calc, this would be a very useful feature for migrating to Hybrid.
Great point Tim (Faitsch?)
I'll add that to the next version 🙂
Yes, this is Tim Faitsch. I will definitely give the utility a try if you can add that. I know Oracle had created a similar utility internally. I don't think it's available to the public though.
Celvin is it possible to send the code behind this tool , I assume you are using JAVA API
😉 It is Java API. I'm not planning to publish the code. However if you need help I can provide guidance on that. Send me an email
Hello Celvin, thank you so much for this tool, are you planing to add the Alias rename Bulk option ?
Best,
Akram
Let me try and add that to the next version. Thanks, Akram.
It will be great. Thanks Celvin.
Hello Celvin,
Let us know when you’re expecting to publish the new version.
Best,
Akram
Thinking about this, Why cannot you create a load rule with the new alias and just load that info?
Hi Celvin,
I know it’s possible using DLR but we need to give users the possibility to change directly just member aliases as it will not have an impact on our data loading even if they make an error changing it.
Best,
Akram
I’ve no idea what you are talking about. If your data load is using aliases instead of member names then you’ll have impact. You can create a dimension build load rule to just update aliases and have a file just for that purpose only.
What i mean is :
-I need to give the possibility to users to change only Aliases using a Powershell/silverlight that calls your Batch and copy the output they made handly inside the text file used by your utility, we already use data rules for updating our outlines but we cannot give users the ability to change Aliases using EAS.
Users haven’t technical skills to do that, we only do that while loading data monthly.
Thanks.
Best,
Akram
Alarm, I think you are not getting it. You can still do it using MaxL you don’t have to give them access to EAS. All I can see what is missing is if the members are coming at different levels. Otherwise you already got what you are asking for.