‎2008 May 06 7:30 PM
Hello friends,
I am a BW person and needed some help with writing a small code on the BI side.
This is what i have
Hello,
i need to write a code when the data is going from the Cube to another cube which says if type is in range of 5000 - 5200 its 'Service' if its in range of 6000 - 6500 then its 'Rent'.
Do i need to define each number or can i give a blanket range of 5000 to 5200 'Service' and 6000 60 6500 is 'Rent'.please assist with the routine and show me if i want to write the range then how is it possible.
Points shall be assigned.
Thanks.
‎2008 May 06 8:58 PM
Are you going to do this in a start routine? I only have limited experience with BW programming, hence my question.
Let's say you have a DATA_PACKAGE over which you are going to loop.
FIELD-SYMBOLS: <line_of_package> type DATA_PACKAGE (or structure of data_package).
LOOP AT DATA_PACKAGE ASSIGNING <line_of_package>-
IF <line_of_package>-fielda BETWEEN 5000 AND 5200.
<line_of_package>--fieldb = 'SERVICE'.
ELSEIF <line_of_package>-fieldb BETWEEN 6000 AND 6500.
<line_of_package>--fieldb = 'RENT'.
ENDLOOP.
Hope this is what you are looking for.
‎2008 May 06 8:58 PM
Are you going to do this in a start routine? I only have limited experience with BW programming, hence my question.
Let's say you have a DATA_PACKAGE over which you are going to loop.
FIELD-SYMBOLS: <line_of_package> type DATA_PACKAGE (or structure of data_package).
LOOP AT DATA_PACKAGE ASSIGNING <line_of_package>-
IF <line_of_package>-fielda BETWEEN 5000 AND 5200.
<line_of_package>--fieldb = 'SERVICE'.
ELSEIF <line_of_package>-fieldb BETWEEN 6000 AND 6500.
<line_of_package>--fieldb = 'RENT'.
ENDLOOP.
Hope this is what you are looking for.
‎2008 May 14 9:20 PM
‎2008 May 25 6:09 AM
Hello Micky,
I have anothr question for you, can you take a look at my post in the BI forum 'RSDRI_INFOPROV_READ doesnt read data from
source at all' Link: [|], its written in the Start Routine but its not getting any data for me may be the logic,but if you can please check it for me.
Points shall be assigned
Your help will be greatly appreciated.
Thanks
‎2008 May 29 1:36 PM