SAC Live Data Model with Filter Default Values in SAP BW Query

[nina_l]

Hi,

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.

Nina

[eeddggaarr]

Hi Nina,

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.
br
edgar

[nina_l]

Hi Edgar,

thanks for your answer.

Now I can remove this variable. But in the coding I do not see this customer exit variable, may be because this is a non input variable.

And other question, is there a possibility that the input variables from edit design mode will not be set when I execute the story.

Thanks fpr your help.

br Nina

[eeddggaarr]

Hi Nina,
I overread that your variable is not input ready - one of SACs current limitation with live models is that in order to get variable values with scripting the variable needs to be set to input ready. You might want to vote for improvement request: Read values of non input ready variables. You can't even use non-input ready variables for dynamic texts yet.

concerning your other question: as long as you have that variable in your query it will be executed whenever SAC connects to that query.
So you might consider to

• delete that variable from your query as long as it is not needed at all in your story and use SACs own date logic if that is sufficient.
• if the original query must not be changed: copy that query and use the copy to make your adjustments
• change the variable to input ready (you can prevent end users to change variable values if you want in SAC)

as SAC supports BW step_1 and step_2 variables you also might consider using one "dummy" step_1 variable and derive needed step_2 variables.

the main question here is: how do you want to get needed dates for your story and if end users should be able to change them.
is it only one date or a date range (or several date ranges for e.g. MTD, YTD, 12mth rolling,...).

br
edgar