Dynamic filtet in WEBI based on BEx

[former_member604692]

Hi everyone,

I've created Webi report based on BEx-query which has input ready parameters, for example, "date_from - date_to". Now I want to schedule this report. I need to define values for my parameters. It seems to me that I can only use a constant value, because in parameter window of my query I see only option to choose from a list of values. But I need this value to change dynamycally, like "today-2 days - today-1 day"

Is there any option to avoid this restriction? Maybe I can use some variable...?

I've tryied to perform steps from this link https://blogs.sap.com/2016/03/09/how-to-restrict-webi-report-data-by-default-to-previous-day/ . It worked but I think it could affect perfomance since firstly it executes a filter from BEx and secondly that one that I've created

If you have any solution, please share.

Thanks,

Hristina

[amitrathi239]

you can handle this type of request through customer exits in BEx.

https://wiki.scn.sap.com/wiki/display/BI/Customer+Exit+Variables+in+SAP+BI