Technical Articles
S/4 Hana : Consume CDS view in Query Browser
In this Blog, we are going discuss on How a CDS view can be consumed in Query Browser for Ad-hoc analytics.
Introduction:
The Query Browser is a Fiori application using which you can quickly and easily search, browse, and tag the analytical queries. This application displays all the analytical queries to which the user has access. You need to assign the Query Browser role to a user. To launch the application, just search the term Query Browser from the search. By default, the content views are pre-organized by the view name.
Basic Config to Activate the Query Browser and Role assignment :
1.Use transaction SICF to activate the following ICF service (with sub-trees):
/default_host/sap/bc/ui5_ui5/sap
use transaction /n/IWFND/MAINT_SERVICE to add OData Service
VDM_CDSVIEW_BROWSER from the Backend system.
2. Assign role SAP_BR_EMPLOYEE to the a user through SU01.
3. Activate ICF Services
Use transaction SICF to activate the following ICF services (with all sub-trees):
/sap/bw/ina
/sap/bw/Mime
/default_host/sap/public/icf_info
You can also refer this link for more Configurations.
Features:
1)Filter views:
Use the Filter option to sort or filter the views. The sorting of views is based on the view name and application component in the system. The filtering is based on the user added tags and application component. The list of application component displays in an hierarchy. Click the Reset button to remove all the filter conditions.
2)Personalize and tag views:
Use this option to create or personalize your own tags to CDS views. Select a view and then click the Add Tag option. Multiple tags can be added for the selected view(s) by separating them using comma. The number of tags to which a view is associated displays as a link. Click the link to manage the tags.
3)Mark as favorites:
Use this option to add or mark views as your favorite. Select the checkbox against a view and click the favorite icon. You can select multiple views and add as favorite. If you select views that are marked as favorites, and click the favorite icon, all the selected views are deselected. To select all views, click the checkbox on the table header.
4)Open in Design Studio:
Pre-requisites:

How to create a Query Browser from CDS View and save the query as Fiori Tile:















Hi Ravi,
Where does this tile get saved to? Do I get to see it designer? If so under what catalog/group?
Would this saved tile be seen by all users or just the user that created the tile?
Thanks
Typically in Dev system you can assign to a Transport and deploy that TR into the Landscape
Hi Ravi,
Thanks for the nice blog. One question here. If the user has access to the Query Browser then can he see all the CDs queries which are with annotation analytics true? If we want to provide access to only specific queries, how do we control that.
With DCL, user can still see the queries, right?
Thanks
Smriti
Query_Browser is for the technical users only as we cannot control the access here
How can i have a different name on column, if i have same data type fields it shows with the same column description. How can i get this changed ?
Also advise me what is the right annotation to get text values like for every dropdown sap will have descriptions right instead adding extra join to *t table can i get text default with annotation ?
Thanks,
Mahesh
Hi.
Additional license required?
Regards