Again another draft item (there in drafts for almost 2 years now) getting materialized 🙂
If you look at load rules (I know Cameron is going to say dead to load rules, yes dead to load rules 🙂 ) there is no option to perform a rename or a delete a single member or descendants.
This was the case with Planning too, but then we got DeleteSharedDescendants.cmd file which can delete all shared member instance from a hierarchy, we even saw OutlineLoad utility getting an Operation field where you can specify Delete Idescendants, Delete Descendants, Delete Level0
This one is for Essbase, you can now perform an automated member delete 🙂
Let’s look at the Delete option
Mention the members and operation in a text file as given below
Tool will then perform a delete operation 🙂
If you use a parent level and Delete Member operation, it’ll not delete it and will ask you to change the operation.
Let’s look at a delete operation on a modified version of Sample Basic.
I did ran a test on my Production system and I was able to delete 820 shared descendants in 10 mins.
I did a delete on 3 different alternate hierarchies.
The tool can be used for rename operation in a similar way, however I did find an issue with rename option, it removes all data from the cube!!!!!
That is one issue which I’m trying to solve and I will be adding the download link once that issue is fixed.