Essbase Member Operation Utility – Delete Members


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.
Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with β€œIntekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “Essbase Member Operation Utility – Delete Members

  • Anonymous

    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?