SAP Knowledge Base Article - Public

3068823 - Unable to dynamically select value used for a restricted measure date filter in SAP Analytics Cloud (SAC)


When creating a restricted measure you can set an offset of a specific time period such as "previous year".   However if you want to dynamically set the starting point for the offset that doesn't work currently.


Option 1:

  • Create an input control and set the offset amount for the input control to look back 1.  However when you view the values it shows the values from the current year rather than offset one year back.

Option 2:

  • Create an input control with a fixed value (no offset) and the display the values from the restricted measure (which is a hierarchy).  However, when you view the values it shows the summary from the top level of the hierarchy instead of the values from each level of the hierarchy.


  • SAP Analytics Cloud (Enterprise) 2021.10.5

Reproducing the Issue

  1. Create a story that has a date hierarchy
  2. Create a restricted measure and specify an offset of "previous year"
  3. Try to specify a dynamic initial value for the year.


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0