3582269 - Result of restricted measure defined in story is not correct in an optimized story in SAP Analytics Cloud (SAC)

• Restricted measure defined in story could not be calculated properly in an optimized story in SAC

• SAP Analytics Cloud 2025.1.8

1. Log onto SAC
2. Create an optimized story based on the import data connection model
3. Add a table into this story
4. Define a restricted measure calculation and add this restricted measure into this story
5. Go back to the table
   => Observe that the value of underlying measure used in this calculation is A, for example
   => Also observe that value of this restricted measure would show as 0

• This is currently a by designed behaviour.
• In HANA Analytical Engine (MDS), we have the rule formula>selections regardless of solve order.  Always the formula will take the precedence over the selections. This is also explained in sap help document(first "Note" section): https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/68871a3ebaa24943a397686502d6f8c3.html 

This is currently a by designed behaviour.

• 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
• Getting Started with SAP Analytics Cloud
• Need More Help? Contact Support or visit the solution finder today!

sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, Story, story, Stories, stories, Story 2.0, story 2.0, Optimized Design Experience mode, ODE, ode, Optimized View mode, OVM, ovm, calculation , KBA , LOD-ANA-ML-CAL , Calculation Management , Problem