Skip to Content

BPC 10.1 NW Master Data Clean Up


We have a dimension in one of our models that consist of our complete client list. This list is populated from BW. However, it was originally loaded from our old version of BPC (MS 7.5). This dimension has approximately 30,000 members of which 5,000 - 10,000 have no data signed data and can be deleted. That being said, we are having a very hard time identifying those members and deleting them. This large dimension is effecting performance with our logic scripts and we are hoping to improve our user experience. Does anyone know of way to purge unused dimension members from these large dimensions? Any feed back would be appreciated.

Thank you.

Benjamin Gober

Add a comment
10|10000 characters needed characters exceeded

  • Hello Benjamin,

    I'd think there is an easier option - just delete all members in that Dimension. BPC will delete only those that don't have any transaction data, not used in authorization, BPF, etc.

    I'd suggest trying it out on a copy of your Environment first because it can delete new members that don't have TD yet.



  • Hi Gersh,

    As far as I remember if you try to delete all members from BPC web interface the delete will stop on the first error...

    Anyway preparing the list for deletion and using property to sort looks like a safe method...


Related questions

2 Answers

  • Best Answer
    Posted on Dec 21, 2016 at 08:55 PM

    1. Eliminate zero records to ensure that there are no records for unused members (Light optimize with zero elimination etc...)

    2. Create a property in this dimension like DELETE

    3. Create a report to get a list of empty members

    4. Based on this report create an import file to update property DELETE with Y for empty members.

    5. Update property by import from file

    6. In dimension administration sort by this property

    7. Delete records with Y (select sorted lines)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2016 at 05:54 AM

    Also you need to have such property/flag in BW infoobject too... So that the next time load happens all those deleted Id's are not loaded again.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.