SAP Knowledge Base Article - Public

2633777 - "The data source query has no measures." error message appears in SAP Analytics Cloud

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

  1. Logon to SAC. 
  2. Create a Live Data Connection (e.g: S4/HANA).
  3. Create a model based on a query which does not contain measure.
  4. 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

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

Product

SAP Analytics Cloud 1.0