SAP Knowledge Base Article - Public

3467382 - Measure filter follows linked Analysis for a table widget doesn't work correctly

Symptom

When you have a table as the Linked Analysis receiver widget in a story, using script to change account or measure selection of the driver widget won’t take effect on the receiver table.

Environment

SAP Analytics Cloud 1.0;

Reproducing the Issue

  1. Create a Story with 2 tables on same model.
  2. Use Link Analysis between them.
  3. Create a button or something with a script (API setDimensionFilter) to change measure filter on the driver table.
  4. Click the button to run the script.

Cause

The root cause is related to how the Linked Analysis (LA) filter behaves differently for charts and tables when Account or Measures filters are applied. For tables, there is a limitation when the Account or Measure LA filter is applied .Refer to SAP Note 3464937.

 When the setDimensionFilter() function is called on the driver widget, it propagates the Linked Analysis filter to the receiver widgets. However, in this specific case, when the LA filter is applied to the Account or Measures dimension for a table, the table will not take effect.

Unfortunately, there does not seem to be a straightforward solution to work around this limitation. 

Resolution

Please be aware of this behavior and the associated limitation when using LA filters on measures for tables.

For the Table widget in Optimized mode, the only way to set a Linked Analysis filter is either with the Filter/Exclude Member contextual menu, or via data point selection.

Keywords

KBA , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud 1.0