SAP Analytics Cloud Variable Prompt

[andrewbarlow1]

Hi,

I have a variable prompt from a live BEX query with multiple variables on it.

One of the variables (Business Unit) is pre loaded.

Other variable values below this should be restricted by Business Unit but they seem to be showing all the members. Obviously on a normal SAC filter we can sort this with only showing posted values however in the prompt it looks like by default that is already set to show only posted values but it shows all values?

The Production Line and Work Centre variables do not seem to be filtered by the plant variable.

This should only show "1" here.

Any help appreciated

[Ivan_C · Accepted solution]

Hi,

What you are seeing is the standard behaviour for ‘F4’ help in BEx queries. This is governed by the backend in BW. In order to have ‘cascading’ variables you would need to implement the BADI RSR_VARIABLE_F4_RESTRICT in BW. See https://community.sap.com/t5/technology-q-a/bex-cascading-variable/qaq-p/11895992 for example. 
Cheers, Ivan. 

[andrewbarlow1 · Accepted solution]

Thanks Ivan - I will investigate this further.