Symptom
- Manually added/imported models appear correctly in the Modeler, but they cannot be used in stories any more.
- Previously created stories are not fetching data and stay in "loading" mode.
- All the models based on Live HANA views or Live BW are working correctly.
- When adding a chart into the story, the builder shows: "This chart can no longer retrieve data from datasource".
- After adding a table, you'll observe error like: "EPM model 272500 of query source "TENANT_9"."/t.1M/<MODELNAME>_qs" is not available".
- An input control cannot be added with Filter by Range based on a time hierarchy because error "Failed to initialize" appears.
Environment
- SAP Analytics Cloud 2017.11.2
Reproducing the Issue
- Log into your SAP Analytics Cloud tenant.
- Create a new story, use canvas page.
- Add an import data model.
- Add chart into the page and observe in the builder that: "This chart can no longer retrieve data from datasource"
- Add table and try adding dimensions, you'll observe error like: "EPM model 272500 of query source "TENANT_9"."/t.1M/<MODELNAME>_qs" is not available"
- Add input control Filter by RANGE based on a time hierarchy and you'll get a popup with an error message "Failed to initialize"
Cause
Expired EPM license caused the inconsistencies of the EPM models in the HANA backend.
Resolution
If you ecounter the above issue please open a support case using LOD-ANA-BI component to request our Operations team to update the EPM license.
Workaround:
The issue with the models/stories could be solved by doing an export/import of the affected models.
This action will perform an model regeneration.
See Also
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening cases with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
Your feedback is important to help us improve our knowledge base.
Keywords
acquired, 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, SBOC, SAC , 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