we are doing our first steps in SAC.
We have got a SAP BW Query which is connected by Live Connection.
In this query the Calday is set in the filter default values to the previous day through non input ready customer exit variable.
Now I have the problem, that I couldn't clear this filter for Charts. In tables I can clear this filter via three dots menu. But this is not very comfortable.
Is there an option how I can clear this filter? Or is it necessary to do a redesign of this query?
Thanks for your help in advance.
you can change variable settings for charts too (click on chart - three dots - more options - variables & change from story to diagram variables).
you can also set/change variable values per scripting. Best starting point is the developer handbook (5.10.3 setting variable values). Have also a look at 5.10.4 Getting variable values where it is described how to cast different type of variables => necessary step.
if you have to change your query or not depends on what you would like to achieve with your story. One important step is to decide if BW or SAC will be responsible for your date/date range logic.
Maybe you could give some more information about your query (1 or 2 structure query) and navigation logic of your story.