Add Lines Using Filter By Member ("Select All" scenario)

[filipe_zeuch]

Hi everyone,

I have noticed many incidents sent to Analysis for Office team in SAP where the scenario is related to the functionality "Add Lines Using Filter By Member" and the "select all" option.

The issue reported is that when selecting all members, the values are not being sent to the prompt and in case of a mandatory variable, it is not possible to select all members.

This is by design. When pushing the "Add Lines Using Filter By Member" it is possible to select several members. When checking "Select All" and closing this dialog the prompt screen shows an empty field.

This is because an empty field means that this variable shows all members (empty == Select All).

In case of a mandatory variable it's not possible to close the prompt screen when having chosen "Select All" / empty field. In this case the design of the query forces you to not display all values but restrict the result set.

If you want to be able to "Select All" members, you have to set the variable as optional in your query definition, and not mandatory.

Regards,

Filipe

[former_member534160]

Hi Filipe,

we find when clicking "Add Lines Using Filter By Member" and select value from file, only values already existing in the prompt can be selected if value exists in prompt, and all values are selected when no value in prompt, we would like to set prompt from values in file, could you tell is it possible?

Regards,

Shidong