SAP Knowledge Base Article - Public

2388600 - Formula could not be computed: Error: Object is unknown: [Time].[].. Try rewriting the formula in SAP Analytics Cloud

Symptom

The following error occurs when you are in the Modeler and you try to save a formula:

  • ResultLookup([H111100], [d/OPERATING_INCOME_Time] = "2017")
  • Formula could not be computed: Error: Object is unknown: [Time].[].. Try rewriting the formula.

ResultLookupError.jpg

Environment

  • SAP Analytics Cloud 2016.21

Reproducing the Issue

Create a new formula referencing a dimension member or dimension property.

Cause

The "Content Namespace" is missing in the dimension reference in the formula.

Resolution

Add the "Content Namespace" (i.e. t.8) to the dimension reference in the formula, defined in the System Administration Menu >> System Configuration screen:

  • ResultLookup([H111100], [d/t.8:OPERATING_INCOME_Time] = "2017")

System_Content_Namespace.jpg

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0