How to mass delete obsolete members in BPC dimension
Let’s assume the following scenario: due to business requirements the hierarchy in BPC dimension was significantly changed (or even removed in case of multiple hierarchies). As a result, a lot of nodes are obsolete and has to be deleted. There is no DM package to delete members and the job has to be done in BPC Web interface. And it’s not an easy job to do it one by one!
The proposed idea is to use some property to mark members for deletion and then filter by this property in BPC Web interface.
Let’s assume that we have text file with the list of members to be deleted (obsolete nodes) UNUSED.txt (each line contain only member ID, first line contain field name – ID):
ID N1_1 N1_2 N1_3 N1_4
And let’s use property SCALING property (any property can be used).
Now we create very simple transformation file for master data load from text file:
*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = TAB AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT= ROUNDAMOUNT= SPECIFICMAPPING = YES *MAPPING ID=ID SCALING=*STR(D) *CONVERSION
For each member ID set SCALING property to D (assuming that no other member has “D” in this property.
We upload text file UNUSED.TXT to the server and import it to the required dimension using created transformation file (in update mode). Standard DM package: Import Master Data Attrib and Hier Flat File (chain /CPMB/IMPORT_MASTER).
After import we open BPC Web administration – dimension management for the required dimension and filter members having “D” in property SCALING. We have a list of members to be deleted.
Select first line, scroll to the last line, Shift + select the last line – all lines will be selected.
Press Delete menu item and process dimension!