SAP Knowledge Base Article - Public

3417892 - SAC AD : Filters in Table View not working properly (Analytics Designer LOD-ANA-AD)

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 (Enterprise) 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-INF , Analytics Designer Infrastructure , Problem

Product

SAP Analytics Cloud all versions