Symptom
The following chart error occurs in SAP Analytics Cloud:
- [ABC] is invalid because it depends on invalid calculation [XYZ]
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.
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
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
- SAP Community WIKI
- Improvement requests (on the SAP Customer Influence portal)
- Video tutorials
- Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
- Training events
- Past event recordings
- New user handbook
- Roadmap
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem