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
- Create a story - Universal Account Model
- Add Table and create a Restricted Measure (RM).
- Unselect RM from member selection and choose only base measure.
- Save the story.
- 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:
- Create an Analytical application and add a table - Universal Account Model
- Add one base measure and create two Restricted Measures (RM).
- Add one more table and add a base measure.
- Add two buttons add onClick() script like below.
- Click on Button 1 - Observed that Table 1 shows base measure along with two RM's, but table 2 shows only base measure.
- 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
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
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