In this Blog, we are going discuss on How a CDS view can be consumed in Query Browser for Ad-hoc analytics.
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):
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):
You can also refer this link for more Configurations.
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:
How to create a Query Browser from CDS View and save the query as Fiori Tile: