The Query Browser

The query browser is a default design studio that is available in the standard Fiori content. No additional installation is required as this application is shipped with the standard Fiori content.

The Query Browser allows the end-user ad-hoc reporting based on CDS Query views.

The Query Browser is a Fiori application. To be able to start it, you first need to start the Fiori launchpad. The Fiori launchpad can be started using a browser.

The view details are displayed. The header shows the name, application component, tags, and description.

The definition tab shows the technical details like Column Name, Data element, Description, Data type, and length of all columns.

On the Annotation tab, you will see additional details on access control, VDM view type, Analytical query, End-user label, and the ABAP catalog view name. The CDS in-front of the ABAP catalog view name means it is a CDS view.

To open this query in the Design Studio, click Open in Design studio.

The resulting screen shows the selected data in a table and pie chart. The look and feel of this result page can be customized. The query can also be saved as a Fiori title by clicking the Actions button on the bottom right and then select Save as Tile. In the Save as Title pop-up, you can specify the Title and subtitle to be displayed in the Fiori launchpad.

The design studio tile is saved under the My Homegroup for easy access.

Analytics-related Annotations

Analytics-specific annotations in the CDS View influence the way the Ad-hoc is generated.

Here are a few examples:

• Annotation @Analytics.query:true defines this view as a query
• Annotation @AnalyticsDetails.query.axis: preselects afield as row or column
• Annotation @Consumption.filter: allows /restricts filter setting on this field

CDS Views need to fulfill some basic requirements in order to be available in the Query Browser.