Skip to Content
Technical Articles

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.

For example:

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!

 

Be the first to leave a comment
You must be Logged on to comment or reply to a post.