3446720 - Formula could not be computed error happens when creating calculated measure in SAP Analytics Cloud (SAC)

Formula could not be computed error happens when creating calculated measure in SAP Analytics Cloud (SAC)

• SAP Analytics Cloud 2024.2.8 (SAC)

1. Login to SAC system.
2. Go to Modeler, create a new empty model.
3. Create a sample measure called TEST.
4. Click on Date dimension to view the hierarchy.
5. Change the Date member management setting to User managed.
6. Set the Year, Half-Year, Quarter, Month as default hierarchy.
7. Go to calculation of the model, create a calculated measure and in formula section write below formula
   

   LOOKUP([TEST] ,[d/Date] =ToPeriod("Half-Year"))

   ==>Got error:
   Formula could not be computed: The level "Half-Year" was not found the current default time hierarchy YHQM. Please select another level or change the default hierarchy. Please complete or rewrite the formula.; When using dynamic time navigation functions with Lookup or Restrict, consider adding the date dimension to the list of required dimensions so that a story builder can add the date dimension to the drill. 

• The issue is under investigation by development team.

• The issue is under investigation by development team.

• 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 case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in 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 Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• 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, formula, calculation, year, hierarchy, half year, computed , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem