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
Format is
Member,Operation
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 created a file with Delete Shared Descendants option.
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.
Hey Celvin,
Did you end up getting a fix for this?
Yes the latest version has a fix for this.
Hey Celvin,
Thanks for the reply. I've got the following error.
"com.essbase.api.base.EssException: Cannot find member. Object not found.
at com.essbase.api.metadata.EssCubeOutline.findMember(Unknown Source)
at com.cera.hyputils.EsbMbrOperation.EsbMbrOperation.mbrquery(EsbMbrOperation.java:250)
at com.cera.hyputils.EsbMbrOperation.EsbMbrOperation.main(EsbMbrOperation.java:170)"
I have triple check that the member i am deleting in my ASO exists but the error seems to point to the member not existing. The following is in my DeleteMbrList.txt file stored under E:temp folder.
CE_Unallocated,Delete Member
TestDel,Delete Shared Descendants
And here is the ESBMBROPTS line
SET ESBMBROPTS=-u=admin -p={commented out} -S={commented out} -App={commented out} -Db={commented out} -file=E:tempDeleteMbrList.txt -delete
Is there something that i am missing?
You might have executed that twice and now that CE_Unallocated is deleted it is complaining about it.
Hi Celvin
I have been able to set up the utility as suggested. I am now trying to delete a single level 0 member (Account1000) in a test database. Whilst the log seems to be showing that the utility is running correctly, it just does not seem to be deleting the member in the outline. Am i missing something?
2017 Jun 26 12:29:00 **** Start Member operations in Essbase.
Jun 26, 2017 12:29:05 PM Admin Connected to EssServerxxxx.
Jun 26, 2017 12:29:05 PM Database Test.Test set as active.
Jun 26, 2017 12:29:06 PM Opened Test.Test for editing.
Jun 26, 2017 12:29:06 PM Member Name: Account1000, Operation is Delete Member
Jun 26, 2017 12:29:11 PM Restructuring Test.otl completed.
Jun 26, 2017 12:29:11 PM Closed connection and disconnected from demo11123.
2017 Jun 26 12:29:00 **** End of Member operations.
Press any key to continue . . .
It should delete the member, are you still seeing the member in the outline?
Yes, i am still seeing the members in the outline.
It connects to the server, sets the database as Active, opens the database for editing, and then when it comes to the deleting:
FEB, 01, 2018 10:46:38 AM Member Name : 17000000, Operation is Delete Member
Then restructures and disconnests from the databases and server. But the account in question is still there, as well as its shared members.
Is that a parent? Did you try to delete the descendants?
No, these are level zero members, with shared members in alternative hierarchies.