Skip to Content
0
Former Member
Jan 12, 2012 at 03:51 PM

Master data deletion

74 Views

Hi experts

I'm dealing with a master data issue, and I need your expertise

I had to reload my cube, from a updated environment (updated with a copy of production). This generated a inconsitence for some master data.

Example:

Before reloading cost center A was associated with controling area 111.

After the production copy, cost center A was associated with controlling area 222

So, when i reloaded the master data into BW i got to a situation where i get 2 records for cost center A - one with controlling area 111 and another with controlling area 222.

I want to delete record cost center A, with controlling area 111.

When I when I look at data in the cubes/ODS all records that cointain cost center A are associated with controlling area 222 and not 111

I've tried to delete data from all cubes and DSO that have cost center, and then delete the master data, but it keeps giving warning that data is not deleted because is being used.

Does anybody knows what I'm missing? Is there any workarround to delete only one record of master data in this situation?

Many thanks

Joana