SAP Knowledge Base Article - Public

2571225 - [ABC] is invalid because it depends on invalid calculation [XYZ] error in SAP Analytics Cloud

Symptom

The following chart error occurs in SAP Analytics Cloud:

  • [ABC] is invalid because it depends on invalid calculation [XYZ]
    28-Nov-17 5-23-47 PM.png

If you select the the invalid calculation [XYZ] (which is a restricted measure) the following chart error occurs:

  • Time calculations do not support having a story/page/group filter and a chart filter defined on the Time dimension at the same time.
    28-Nov-17 5-15-22 PM.png

If you remove the story/page/group filter or chart filter, this error may also occur:

    • The Time dimension must be drilled to Fiscal Period or a lower level for [XYZ] to appear.

    Environment

    • SAP Analytics Cloud 2017.23

    Cause

    A restricted measure with a dynamic time calculation (TO DATE - Month/Fiscal Period to Date) was being used.

    Resolution

    Choose a valid Time dimension member drilled to the correct level or lower (based on the error message) for the correct value to appear in the chart.

    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, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

    Product

    SAP Analytics Cloud 1.0