Essbase Member Operation Utility – Delete Members 10


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.

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

10 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?

  • Anonymous

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

      • Anonymous

        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.