Skip to Content
0
Nov 12, 2012 at 06:46 AM

Adding a key figure to Cube & Update existing data in cube

37 Views

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.