3298003 - The Restricted Measure which contains dynamic restriction "Previous Year" on Date dimension shows incorrect total value on Date hierarchy node in SAP Analytics Cloud (SAC)

• Define a restricted measure calculation which contains the dynamic restriction "Previous Year" on Date dimension in a story in SAC
• Add an input control based on the Date dimension and select several months, and observe that:
  -When not expanding the hierarchy, this restricted measure on Year level will show the value of the total year instead of the sum of the selected months
  -When expanding the hierarchy to Month level, this restricted measure could only show values on Month level and no value would show on Year level

• SAP Analytics Cloud 2022

1. Log on to SAC
2. Create a story based on the model with New Model type
3. Add a restricted measure calculation to this story which contains the dynamic restriction "Previous Year" on Date dimension (NAVIGATION - >Previous (shift previous value)->Year)
4. Go back to story, add an input control based on the Date dimension and select several months (such as May and August)
5. Observe that:
   -When not expanding the hierarchy, this restricted measure on Year level will show the value of the total year instead of the sum of the selected months
   -When expanding the hierarchy to Month level, this restricted measure could only show values on Month level and no value would show on Year level

• This is by design behaviour as of SAP Analytics Cloud
• As per the Current Design for Previous Year, Previous Month, Previous Quarter it calculates the previous values for the specified drill level only. Currently there is no option to display all the values for the specified time calculations.

There is already an enhancement request for this function Improvement Request Details - Customer Influence (sap.com). Please vote for it if you also would expect it to be added into our product.

• 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 a case for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.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 > Learning > Data Connections
• Need More Help? Contact Support or visit the solution finder today!

Your feedback is important to help us improve our knowledge base

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem