topic Re: Code help for a cube to cube routine in Application Development and Automation Discussions

Code help for a cube to cube routine

Former Member — Tue, 06 May 2008 18:30:47 GMT

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.

Re: Code help for a cube to cube routine

Sm1tje — Tue, 06 May 2008 19:58:09 GMT

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.

Re: Code help for a cube to cube routine

Former Member — Wed, 14 May 2008 20:20:01 GMT

Thanks Micky,

Full points assigned to you.

Re: Code help for a cube to cube routine

Former Member — Sun, 25 May 2008 05:09:45 GMT

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

Re: Code help for a cube to cube routine

Former Member — Thu, 29 May 2008 12:36:49 GMT

Never mind, its resolved.