3688840 - Incorrect Totals When Using Restricted Measures with Constant Selection in BW Import Models in SAC

• The Totals row in an SAP Analytics Cloud table displays incorrect or inconsistent values when multiple Restricted Measures are used.
• The issue occurs when one of the Restricted Measures applies a filter on a dimension (such as Date) using Constant Selection, while the table itself is filtered by a different value of the same dimension.
• Under this configuration, totals for other measures may also become incorrect, even when they are not restricted by the Constant Selection context.
• The behavior is reproducible in stories based on BW Import models, where Constant Selection is used within a Restricted Measure.

SAP Analytics Cloud 2025.22.1 

1. Log in to SAC
2. Create or open a story based on a BW Import model.
3. Add a table and include multiple Restricted Measures.
4. In one of the Restricted Measures, open the Calculation Editor and enable “Constant Selection” on a dimension (such as Date).
5. Apply a story or table filter on the same dimension using a different value than the one fixed in the Constant Selection.
6. Observe the Totals row:
   • the Restricted Measure with Constant Selection shows incorrect totals
   • other measures in the table may also display incorrect totals
7. Removing the measure with Constant Selection restores the correct total values

• The behavior occurs due to how the story calculation engine evaluates Restricted Measures when Constant Selection is enabled.
• Constant Selection fixes the calculation context for the selected dimension and may override or ignore filters applied at the story or table level.
• When the Version dimension is not explicitly fixed as part of the Constant Dimensions in the Restricted Measure definition, the evaluation context can vary depending on the filters applied, which may result in inconsistent totals.

• The observed result is related to how calculations are evaluated in the story calculation layer and does not indicate a product defect.
• To ensure consistent totals when using Restricted Measures with Constant Selection in Planning scenarios, include the Version dimension as part of the Constant Dimensions in the Restricted Measure definition.
• This ensures that the calculation context remains fixed and prevents totals from varying when filters are applied in the story.
• This is consistent with the intended design of Constant Selection in SAP Analytics Cloud.

• KBA 3061508 - No Data displayed when creating restricted measure calculation using “Version” in combination with version filters in SAP Analytics Cloud
• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

SAP Analytics Cloud, SAC, BW Import, SAP BW, SAP BW/4HANA, Restricted Measure, Constant Selection, Incorrect Totals, Totals Row, Aggregation Issue, Story Calculation, Calculation Editor, Measure Inconsistency, Table Aggregation, Not Supported Feature, Support Matrix, Import Connection, BW Import Limitation , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem