BPC 10.1 NW Master Data Clean Up

[benjamin_gober2]

Hello,

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

[Former Member]

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.

Regards,

Gersh

[former_member186338]

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...

Vadim

[former_member186338 · Accepted solution]

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)

[Former Member]

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.

JP

[former_member186338]

But "it was originally loaded from our old version of BPC (MS 7.5)" - nothing in BW...

[Former Member]

I think....it was previously on BPC 7.5 MS and migrated to BPC 10 or 10.1 NW currently.""This list is populated from BW. However, it was originally loaded from our old version of BPC (MS 7.5).""

[former_member186338]

To my mind it's currently updated from BW to add new members. But old members are only in BPC...