BEx Query Designer Variables

[former_member336161]

Hi,

I have a requirement to change the display values in a characteristic variable in a BEx query.

For example, the query has a selection on Value Types of FM 10 - Budget and 35 - Releases (Reserved). The user would like to replace this text with 'Base Budget' and 'Decision Package Budget'.

Would like this replaced with [10] Base Budget, [35] Decision Packages

I created a text variable and using CMOD code which I think will work but the text variable will not let me enter multiple default values.

Any ideas would be greatly appreciated!

Thanks,

Roseanne

[cornelia_lezoch]

Hi Roseanne,

a text variable can only deliver one text and that can only be used in structure element headers or query names - not for selections.

So if you want to have these 2 values as default values for selection - you need to have a characteristic variable.

and if you want to seed ifferent text - you need to change the master data. You could change only one type of text (short/medium/long) and show only that one in your query.

regards

Cornelia

[shasan]

Hey Roseanne,

I would say you must change the master data text of the characteristic FM value types for 10 and 35.

The restrictions for the Value type is being read from database be it key or the text of it.

I dont think you would be able to achieve that by using text variables.

Regards,

Shadab

[former_member336161]

Hello, Me again. I have another related question. I would like to limit the values (in F4) of the variable at query execution to just the Base Budget and Decision Packages. Any ideas on this?

Thanks,

Roseanne

[shasan]

Very late in answering your query. But you can make use of SAP provider Enhancement -RSR_VARIABLE_F4_RESTRICT to restrict your F4 o/p.

Attached is blog for that .

F4 restrict

[former_member336161]

Thank you both. We went with updating the master data text.

[former_member336161]

Thank you Shadab. We have considered this option but 1) are unsure of updating BI Content and 2) the customer would like to see only these values in the selection (Budget and Releases(Reserved). I don't see any way to restrict this without using CMOD. Any other ideas?

Thanks,

Roseanne