Skip to Content
0
Former Member
Apr 14, 2010 at 10:41 AM

Old & New Master Data

37 Views

Hi all,

We have got some master data which is already in use in my cube. Object ID is the key in my case and my MD InfoObject is not time dependant.

Example:

Object ID Name

P0001 User001

P0002 User002

We now have a change in the master data like

Object ID Name

P0999 User001

P0002 User002

My old transactional data has got some records for P0001. I have loaded the new data. This now gives me

Object ID Name

P0001 User001

P0002 User002

P0999 User001

My current report is showing 'User001' (text) and 'P0001' (key) but I want the report to show 'User001' (text) and 'P0999' (key). How can I get my old data moved to the new key i.e. P0999. Please ask if the above is not clear.

Thanks

S. N.