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