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.