Hi all,
We want to add a key figure to the InfoCube which is simple and easy task, but it
has 100 millions data and we have to update the existing data also like the below:
Existing data:
Type -- Amount1
X -- 100
Y -- 200
Modified Data:
If Type = X
Amount2 = Amount1 (Moving Amount1 to Amount2)
Amount1 = 0 (Set Amount1 to Zero)
Type -- Amount1 -- Amount2
X -- 0 -- 100
Y -- 200 -- 0
It is one time job to modified the existing data. We could write ABAP program and update the data in E & F Fact tables.
Is there any other better solution, please ? If it is simple to write the ABAP, then can I get sample code, please ?
Thanks,
Venkat.