Excluding 2 values in variable in Query Designer

[Former Member]

Dear all,

I would like to use a variable in the Query Designer that excludes 2 values.

For example:

1 = green

2 = blue

3 = red

4 = yellow

The variable should give the users an optional input, where they can only choose from 1 and 3, and where 2 and 4 are excluded.

How do I do this?

Thanks in advance,

Ralph

[Former Member · Accepted solution]

Ralph,

One way to implement this is using a variable with Authorization processing type, Then in second screen set the field "variable represents" to "selection option" and check the "ready for input" button.

Note that you will need to create a custom authorization object and role and specify in PFCG the values the user will be permitted to see, and assign the role to the relevant users.

I am not sure this will be the simplest way to do that, so i will be looking forward for Bhanu's or other BEX experts feedback.

Regards,

Gili

[Former Member · Accepted solution]

Hi Gilad,

thanks for your quick response. As you already mentioned I do not prefer this solution. We have lots of users, and our userbase is changing often. To much maintenance.

I hope there are other options.

Best regards,

Ralph