Text Variable or similar function for characteristics?

[Former Member]

Hi BW experts,

it is known it is possible to use <b>text variable</b> to give KF description a special flavor dynamically at runtime of the query.

I am wondering if there is any <u>similar function available for characteristics</u>.

We get the requirement to display characteristics in dynamic way based on certain conditions.

What I could imagine: add additional characteristics in the cube and make the manipulation in the update rule, afterwards the original characteristics will be replaced in the query.

I hope someone out there could have good idea and help me.

Your feedback and inputs are highly appreciated and rewarded.

Regards,

Sally

[Former Member · Accepted solution]

Hi Sally,

First check in SE38 for ZXRSRU01.

You can code your logic or conditions for a user selection. Say for example user selects Year 2006 and you want to display One char as PLANT and for 2007 the same as Manufacturing Unit, this kind of logic can be written here for a text variable in that exit.

Like this you can populate the records you want using user entry as criteria .

With CMOD you can create your own project, then hit create. In the Enhancement screen specify the name RSR00001 and then in the component screen you can see EXIT_SAPLRRS0_001. If you double click that you can see the Include ZXRSRU01 in it.

Hope this helps.

Raja

[Former Member · Accepted solution]

Hi Raja,

many thanks for your feedback.

If I understand correctly, the approach (text variable) you mentioned below is for key figure.

I didn't find this function for characteristics actually. Could you please advise more?

Thanks.

Sally

[Former Member · Accepted solution]

Hi Shelly,

You could do the coding for char also on the Bex exit and mention your conditions. The same logic holds good for Key figure and characteristic, as it is more to do with the change of description.

Cheers

Raja

[Former Member · Accepted solution]

Hi Raja,

thank you so much for your help.

I am sorry that I am bit slow. I am wondering how can I use the text variable for a characteristic. In BEx. it is only possible to display Key and/or Text.

I'd like to share more information in my example:

<u>Row area:</u>

Sales qty, sales $, FY

<u>Column area:</u>

Sales Org, Customer, Product

<u>The requirement is:</u>

If Sales Org. is <b>US01</b>, display as <b>'ZZ01 bla bla bla'</b>, which is neither the key nor text for Sales Org US01. There is rules customer defined and might be hard coded I am afraid.

Thanks and best regards,

Sally