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

• According to the official SAP Analytics Cloud documentation (Support Matrix for Importing Data from SAP NetWeaver BW and SAP BW/4HANA), the Constant Selection functionality is not supported for BW Import connections.
• Although the SAC UI currently allows enabling Constant Selection in the Calculation Editor, the backend processing for BW Import models does not support this feature, which results in inconsistent totals.

This behavior is due to a non-supported configuration, not a product defect.
To avoid inconsistent totals:

• Do not use Constant Selection in stories based on BW Import models,
  OR
• Use a BW Live connection, where Constant Selection is officially supported (as noted in the SAC Support Matrix for Live Connectivity).

If Constant Selection is required for the business scenario, switching to BW Live is recommended.

Below is an optional workaround that may stabilize the totals in certain BW Import scenarios, even though Constant Selection is not officially supported:

1. Open the story and edit the affected table.

2. In Builder - Columns - Measures, open the Set Filters for Measures dialog.

3. Remove the Restricted Measures involved in the issue.

4. Add a base measure from the model (for example, “Value”) and confirm.

   • This forces SAP Analytics Cloud to refresh the measure context and restore internal axis dimensions (such as Version).

5. Reopen the Set Filters for Measures dialog and add the Restricted Measures back (do not remove the base measure).

6. Edit the Restricted Measure that uses Constant Selection:

   • Temporarily disable the “Enable Constant Selection” option and confirm.

7. Edit the same calculation again and re-enable “Enable Constant Selection.”

8. Confirm the changes and verify the totals.
   
   Note: If the Version dimension is manually removed from the table axis afterward, totals may change again.

• Refer to: Support for Importing Data from SAP NetWeaver BW and SAP BW/4HANA
• Refer to: Support for Live Connectivity to SAP NetWeaver BW and SAP BW/4HANA

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