Skip to Content
0
Former Member
Dec 11, 2006 at 09:24 PM

update routine help

20 Views

Hi Experts,

I have 'record type' and Revenue(KF) in my cube. I am generating another ODS and loading the

ODS with my cube data. I need to populate one new keyfigure and chars.

The new key figure 'amount' will be populated by the value of 'revenue' from the cube.

and the new char 'Segment' will be populated by the value of 'record type' from cube.

Any help on ABAP code is appreciated.

Where REvenue <> 0

Where Record type = 1

AMOUNT = REVENUE

SEGMENT = “100”

Where Record type = 2

AMOUNT = REVENUE

SEGMENT = “110”

Where Record type = 3

AMOUNT = REVENUE

SEGMENT = “120”

Where Record type = 4

AMOUNT = REVENUE

SEGMENT = “130”

Where Record type = 5

AMOUNT = REVENUE

SEGMENT = “140”

Where Record type = 7

AMOUNT = REVENUE

SEGMENT = “150”