SAP Knowledge Base Article - Public

3691872 - Error occurs when attempting to add a calculated dimension with the formula TOTIME in SAP Analytic Cloud (SAC)

Symptom

  • An error occurs when using the function to convert a string into a time format in Story reports. The output format appears incorrect despite following recommended guidelines.
  • Error message: "Formula could not be computed: a property for dimension in function. Please complete or rewrite the formula."
  • The issue occurs when attempting to add a calculated dimension with the formula.

Environment

  • SAP Analytics Cloud Enterprise 2025.21
  • Embedded usage of SAP Analytics Cloud

Reproducing the Issue

  1. Open the relevant story in SAC.
  2. Attempt to add a calculated dimension with the formula: function([dimension], 'hh:mm:dd').
  3. Observe the parse error: "Formula could not be computed: a property for dimension in function. Please complete or rewrite the formula."

Cause

The format of the formula is correct.

Resolution

Change formula to: TOTIME([dimension].[p/ID],'HH:MI:ss').

See Also

Refer to: New Enhancements from SAP Analytics Cloud for Story Reports - April 2025 | SAP Help Portal for the TOTIME() function. 

Keywords

error, story reports, function, time format, string conversion, calculated dimension, parse error, SAP Analytics Cloud, embedded usage, datetime field, substring function. , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

Product

SAP Analytics Cloud 1.0