SAP Knowledge Base Article - Public

2966638 - Query Browser: Open for Analysis shows the error: The data source query has no measures

Symptom

It is not possible to open a query without a measure in Data Analyzer (Open query in Query Browser -> Open for Analysis). There is error message: The data source query has no measures.

Environment

S/4HANA Cloud

Reproducing the Issue

1. Open app Query Browser 

2. Open a query (which does not have a measure added to it) and click on Open for Analysis

3. The Data Analyzer on SAC is opened, and there is error message "The data source query has no measures."

Cause

From S/4HANA 2005 onwards, the Open for Analysis in Query Browser will open the query in Data Analyzer, instead of Design Studio.

The Data Analyzer reports are currently not possible to preview/analyze queries without a measure.

Resolution

We will have the Web Dynpro based analysis report using which you will be able to visualize the queries without measures. This will be available from S4HANA Cloud 2105 release.

For now, you may consider to add a measure to the query OR try to access and analyze the queries in Design Studio.

You can access the query in Design Studio by changing the target mapping in the url: After you click on the Open for Analysis in Query Browser, change the opened URL from https://my123456.s4hana.ondemand.com/ui#AnalyticQuery-view?PreviewMode=true&XQUERY=2CYY1_ABC_DEF

to

https://my123456.s4hana.ondemand.com/ui#AnalyticQuery-analyze?PreviewMode=true&XQUERY=2CYY1_ABC_DEF

Or you can still use app Custom Analytical Queries -> open the query -> Preview, this will open the query in Design Studio.

See Also

Data Analyzer Reports - SAP Help Portal

Keywords

design studio, Custom Analytical Queries, SAP Analytics Cloud , KBA , CA-GTF-SB-S4H-SAC , SAP S4H embedded SAC UI integration , CA-GTF-VDM-QB , Query Browser , Problem

Product

SAP S/4HANA Cloud all versions