Symptom
When trying to create a model based on a query which does not have measures the following error message appears in SAP Analytics Cloud:
"The data source query has no measures."
Environment
- SAP Analytics Cloud
- Live Data Connection
Reproducing the Issue
- Logon to SAC.
- Create a Live Data Connection (e.g: S4/HANA).
- Create a model based on a query which does not contain measure.
- Notice the error message.
Cause
This is a by design behavior.
Resolution
The query must contain a measure in order to be able to create a model in SAC.
See Also
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
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, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, unable, cannot, build, create, key figure , 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