SAP Knowledge Base Article - Public

3417892 - SAC AD : Filters in Table View not working properly

Symptom

  • When trying to setup values to input control by script and apply values filters from table view, we are not getting the correct filter value in Table.
  • There is difference between what we selected and what is actually get filtered.
    For example : Applying filter on Timeline for “P04(MTD)”, in Filter Line, it is showing correctly “P04(MTD)”, but the table is showing “P03(MTD)” visible 

    Filter_issue_01.jpg

Environment

  • SAP Analytics Cloud - 2023.8.8

Cause

The widget level variable will affect the member description of dimension, but for the general case, only application level member description is considered. Different "DP_B_PPER_O" variable value will affect 'TimeLine' dimension member description.

Resolution

Workaround to trigger variable updated after setDimensionFilter :

== Code sample ==

BU_Report.getDataSource().setDimensionFilter("00O2TGC4WLDES5JWI7Q5Y414Z",timeline_monthly);

// add the following code

var variableVal =BU_Report.getDataSource().getVariableValues("DP_B_PPER_O");
BU_Report.getDataSource().setVariableValue("DP_B_PPER_O", variableVal );

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

getVariableValues, setVariableValue, setDimensionFilter, getDataSource , KBA , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud all versions