Skip to Content
0
Former Member
May 08, 2013 at 08:14 AM

Changes in Master Data Impacted already loaded Transactional Data in Info cube..

31 Views

Hello All,

I’m using a standard info cube 0SD_C01. One month ago, I have loaded master data 1st and then Transaction data into infocube. Afterwards, I loaded Full updated and have been fetching deltas records on weekly bases. Data has populated in millions in Info cube.

Now, Business needs some changes in the Unit of Measure for Material on ERP side about the key figures. Two key figures has been changed..

First Issue: Gross weight & Net Wight were in Gram now changed to KG

2nd Issue: NetWeight and GrossWeight were had the incorrect values 0.66 and 0.70 respectively like, Material number 60000005 TO 60000010 which have been changed in both systems manually in ECC and BW to 1.39 and 1.32

These two above values being used for the calculation for the quantity, that’s why already loaded

data doesn’t effect on these changes.

How can I tackle this scenario and could anybody tell me its solution without deleting/dropping data? Please elaborate your answer!

  1. I know for my next delta records it will fetch new records with changed NetWeight and GrossWeight values and impacting quantity key figure also, but how can I rectify billions of records which I had loaded already into my InfoCube?
  2. Is there any way or solution for modification into InfoCube loaded data?
  3. Can I access and do modification at Database level of BW?
  4. Is there any other way to change without deleting data from info Cube and then reload again in it?
  5. Do I have to do remodeling, if so, then why n how?

Thanks

Arshiyan