I have 30,000 members in my accounts dimension and I want to delete 1,000 members from different hierarchies dynamically. I have 1,000 members list with me.
Please let me know if there is any way to delete those 1,000 members dynamically.
can we do this job using rule file or maxl or esscmd anyway?
I want to remove some specific members dynamically.
I don't want to do this job manually.
Please help me out.
Rajendra Prasad Gella.
Currently, it is not possible via an out of the box script, an Enhancement request is raised for this feature to be included.
You need to remove the members in a batch process rather than in Application Manager or EAS. There is not a MaxL or Esscmd to do this specifically like that. You could do this indirectly through a dimension build file. You would need to specify all the members in the dimension to keep and set the option to "Remove Unspecified" (click Options>Dimension Build Settings, Dimension Build Settings tab to set that in the data prep editor).
Another option you may consider is the API. EsbOtlDeleteMember function can be used to remove members from the outline.
The sequence of API calls are as follows:
EsbLogin or EsbAutoLogin
The API reference guide is at http://download.oracle.com/docs/cd/E10530_01/doc/epm.931/html_esb_api/topapilist.htm