How to delete old Data in MbrSheet in automated dimension feed.

Cause – The reason the old data is showing up the dimension feed is because they are in Mbr table.

Remedy –

1 - You can delete the data from the member sheet and process the dimension. This will remove data out of the Mbr table, and it will not show up in the dimension any more.

2 – You can place a property in the dimension called “Keep” or “Delete_Rec” or anything else and give it “Y” for the value of the records you want to keep and “N” for the records you want to delete.
Then in BPMC process Add this field in Step 5(Replace)/Kill&Fill tab.
This should fix the problem