SAP Knowledge Base Article - Public

3323541 - Measure based filter selection resets the Table widget to show all the base measures in SAP Analytics Cloud (SAC)

Symptom

  • When creating Restricted Measures either in Story or in Analytical Applications and then using a Measure based filter selection or using a script to filter a Table widget to a certain Restricted Measure, then the Table will also show all the base Measures. 

Environment

  • SAP Analytics Cloud (Enterprise) 
  • Classic Story Design or Classic Analytical Applications

Reproducing the Issue

  1. Create a story - Universal Account Model
  2. Add Table and create a Restricted Measure (RM).
  3. Unselect RM from member selection and choose only base measure.
  4. Save the story.
  5. Open the story and from member selection dialog remove base measure and select only RM and click on OK - Observe that RM filter selection will be removed and will show all the measures in the table.

The same issue can be observed if you are building up an Analytical Application with some scripting possibilities. For instance:

  1. Create an Analytical application and add a table - Universal Account Model
  2. Add one base measure and create two Restricted Measures (RM).
  3. Add one more table and add a base measure. 
  4. Add two buttons add  onClick() script like below.
  5. Click on Button 1 - Observed that Table 1 shows base measure along with two RM's, but table 2 shows only base measure.
  6. Click on Button 2 - Observed that Table 1 shows base measure along with RM, but table 2 shows only base measure.

Button 1: 

var v_measures = ArrayUtils.create(Type.string);
v_measures.push("Name of a measure"); 
v_measures.push("ID of Restricted Measure 1"); //RM1
v_measures.push("ID of Restricted Measure 2"); //RM2

Table_1.getDataSource().setDimensionFilter(Alias.MeasureDimension,v_measures);
Table_2.getDataSource().setDimensionFilter(Alias.MeasureDimension,v_measures);

console.log(v_measures);

Button 2:

var v_measures = ArrayUtils.create(Type.string);
v_measures.push("Name of a Measure"); 
v_measures.push("ID of Restricted Measure 1"); //RM1
// v_measures.push("ID of Restricted Measure 2"); //RM2

Table_1.getDataSource().setDimensionFilter(Alias.MeasureDimension,v_measures);
Table_2.getDataSource().setDimensionFilter(Alias.MeasureDimension,v_measures);

console.log(v_measures);

Cause

The issue is caused by a bug in the product.

Resolution

  • The issue has been fixed in Optimized View Mode (OVM) and Optimized Design Experience (ODE). 
  • The recommendation is to convert the Classic Stories and Analytical Applications to use the OVM and ODE stacks.

See Also

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

Keywords

measure, restricted measure, table, widget, story, analytical application, onclick, button, script, program, filter, selection, rm,  , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0