BexAnalyzer - Selection variable on "mandatory"

[former_member238061]

Hello,

I have a simple question:

I created a query and put a selection variable into the filter.

The variable works but is mandatory.

I checked the properties of the variable and the flag "mandatory" is set as expected.

However, I cannot change it to "optional".

What can I do here (is it because I put it into the filter and not as part of the normal result columns)?

Thanks for any hint.

Thomas

[MartinMaruskin · Accepted solution]

I believe setting like this related to variable behavior are not changeable anymore once variable is created. You need ot deteel the variable and re-create it again with desired type (optional).

cheers

m./

[former_member199945]

Hi,

Created  Char  variable can be changed to mandatory to optional possible in query level itself.

Thanks.

[dhrubojyoit_saha]

If you are sure about this variable not being used elsewhere you can try and edit the RSZGLOBV table entry for this variable and change it.

[former_member199945]

Hi,

Either you put created variable of type mandatory in filters pane or default values pane(Row)

at selection screen it will behave same i.e mandatory (* need to enter ).

Try to create new variable with optional for the same char , if you don't want to modify existing variable (might be used in other queries).

Thanks.