How do you set an Auto Global Filter

[Former Member]

I have a client who has set a Global Filter within his report. The filter works fine. However, if his query or request changes to include a new field, he has to manually include new field to the Global Filter. Is there away to automate this process? Is there a way to refresh the filter to include the new field?

This issue was sent to SAP-BO but was never resolved.

Thanks.

[Former Member · Accepted solution]

Hello Ty,

If, in deski, you create a filter (global or not) and just select manually the values you want to include in your filter that filter is static. Meaning that those selected values will not change when the query or request changes.

If you want a more dynamic filter then you can use the 'Define' button within the format of filters. This option gives you the ability to define a formula (boolean) which selects the filter values. Now whenever the query is changed as long as the values match the condition in the formula the values will be shown.

Regards,

Harry

[Former Member · Accepted solution]

thanks harry...worked like a charm!!!