Rule Details in Transformation

[Former Member]

Hi experts,

                Could please explain about how to create formula for function RIGHT [Last N chars] in Rule Details in SAP BW.

give me any example.

[Former Member]

Right  function displays the last N chars. For ex. If you want to displays last 4 chars of Operating system then

RIGHT( Operating system, 4 )

Hope it helps you.

Thanks

Riyez

[Former Member]

Hi Riyez,

                      my info object have CD01,CE01,CF03 values .I have to pass the value CD series only to DSO in Transformation.Then How to use Right function for this case.

[ranganath_korata]

Hi,

Can you please explain your requirement with an example as I find the statement contradictory. "CD" is to the left in the value given, then may I know why you would like to use the right function ? If you want to load records only for values that begin with "CD", then please write a Start routine as given below.

DELETE SOURCE_PACKAGE WHERE field_name+0(2) NE 'CD'.

Thanks.

[former_member186082]

Hi Sivakumar,

As per your requirement, you have to use LEFT and not RIGHT

As Ranganath said, use routine as your DSO has data other than CD* also

Regards

Chandu

[jagadeesh_mandepudi2]

Hi

Select Rule details and change rule type is Formula there you double click RIGHT it will ask you for Infoobject that which you want right characters and no of right char u want i.e. example:  

RIGHT( 0MATERIAL, 4 )

Jagadeesh

[Former Member]

Hi jadedness,

                      my info object have CD01,CE01,CF03 values .I have to pass the value CD series only to DSO in Transformation.Then How to use Right function for this case.

[jagadeesh_mandepudi2]

Hi

Use small routine to delete records where Obejct+0(2) NE 'CD'.

Jagadeesh