SAP- How to create custom Analytical Query                                                             S/4 Hana Creating Custom Analytical Query and publish as an app

S/4 Hana Creating Custom Analytical Query is an app used for reporting and analysis. S/4 Hana Creating Custom Analytical Query offers the fields required to design a query. The user can select the required fields and set filters for the query. They can add restricted measures, calculated measures, and preview the query results. After that, following these simple steps, you can create various Custom Analytical Queries. We follow the below steps to create a custom Analytical query

  1. Creating Custom Analytical query
  2. Update display section
  3. Update filter section
  4. Publish as an app

Note: In Conclusion, This blog refers to the CDS view created before please refer to the link below on How to create a CDS view

Create Custom Analytical Query

We can now use the custom CDS view created to create a new custom Analytical query

Graphical user interface, application, Teams Description automatically generated

Specify the name and click on next

Graphical user interface, application Description automatically generated

Go to field selection and select the checkbox and the fields would start showing on the right side “ Free” Section

Graphical user interface, application Description automatically generated

Update display Section

  1. Select the row
  2. choose if you want to display it or not
  3. Which axis it should show up
  4. Sorting is enabled or not
  5. Click on up and down to change the sequence of the fields

A screenshot of a computer Description automatically generated

Update filter section for S/4 Hana Creating Custom Analytical
Query

  1. Click on the filer to define filters
  2. Select the row for the specific fields to make a filter
  3. Check filter options and for now, I have selected user input value as a filter with “selection type” “Interval”

Graphical user interface, application Description automatically generated

After publishing check the query and this is how it looks like with just 1 filter which was added as the storage location

Graphical user interface, application Description automatically generated

Publish custom analytical query as an app

open the view browser app and find your specific query and look for the application ID, Note that however, it may sometime take time to appear if you just published.

Refer below image how it should look like Graphical user interface, text, application Description automatically generated

Now select the Application ID and go to Custom catalog extension and search the using the APP ID and then add to the specific catalog you would like to see it in.

This would add the app to the catalog and it would be shown as an app on the Fiori Launchpad.

Graphical user interface, application, Teams Description automatically generated

Related Posts


SAP Display Material Serial Number app shows Dump

Moreover, The article explains a few helpful tips to overcome the apprehension of how to clear the dump while using SAP Display Material Serial Number.


Read More →


SAP How to create custom CDS view

This Article talks about SAP S/4 Hana- How to create custom CDS view for an application easy for the end-user.


Read More →


SAP Fiori how to Display More rows and columns

Learn how to Increase the S/4 Hana rows and columns limit to display in the SAP Fiori element templates to support the features and settings.


Read More →