SAP Knowledge Base Article - Public

2986003 - Restricted measure based on time hierarchy does not work properly in SAP Analytics Cloud (SAC)

Symptom

  • Restricted measure based on time hierarchy does not show the correct value when using dynamic date option for "Current year" in SAP Analytics Cloud (SAC).
  • The problem does not appear if you use the "Select by member" option and manually selecting a certain year.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.11
  • SAP HANA with Live Data Connection

Reproducing the Issue

  1. Logon to SAC.
  2. Create a story based on HANA Live Connection. 
  3. Create a new restricted measure where the dimension is a time hierarchy. 
  4. Restrict the measure to show only a certain period using the dynamic time possibility. 
  5. Use the "Current Year" option to restrict the measure.
  6. Create a chart with the newly created measure. 
  7. Notice that the value is incorrect, it seems the restricted measure calculated the previous year as well. 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

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 , Model, Story Design & Visualizations , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud 1.0