SAP How to create custom Analytical Query
The article provides an insight on S/4 Hana Creating Custom Analytical Query for reporting and analysis by following these easy steps.
S/4 Hana Creating Custom Analytical Query and publish as an app
S/4 Hana Creating Custom Analytical Query is a an app used for reporting and analysis Moreover, 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 hereafter following these simple steps, you can create various Custom Analytical Queries.We follow the below steps to create custom Analytical query
- Creating Custom Analytical query
- Update display section
- Update filter section
- Publish as an app
Note that this blog refers the CDS view created before please refer to the link below on How to create CDS view
Create Custom Analytical Query
We can now use the custom CDS view created to create a new custom Analytical query
Specify the name and click on next
Go to field selection and select the checkbox and the fields would start showing on the right side “ Free” Section
Update display Section
- Select the row
- Then choose if you want to display it or not
- Which axis it should show up
- Sorting is enabled or not
- Then click on up and down to change the sequence of the fields
Update filter section for S/4 Hana Creating Custom Analytical
Query
- Click on the filer to define filters
- Select the row for the specific fields to make a filter
- Then Check filter options and for now, I have selected user input value as a filter with “selection type” “Interval”
After publishing check the query then this is how it looks like with just 1 filter which was added as the storage location
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 it may sometime take time to appear if you just published.
Hereafter refer below image how it should look like
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 then it would be shown as an app on the Fiori Launchpad.
Drop a Message
Email Us
Fill up your details
Get Custom Solutions, Recommendations,
Estimates.
What's next?
One of our Account Managers will contact you
shortly
Related Post
SAP Integration | Application Connectivity | Transport Management: Seamless Solutions
SAP Integration | Application Connectivity | Transport Management: Seamless Solutions
Ensure SAP Integration | Application Connectivity | Transport Management with secure API access, seamless transport requests, and smooth deployments.
SAP Integration | Secure Access | Auth0 for 3rd Party APIs
SAP Integration | Secure Access | Auth0 for 3rd Party APIs
Ensure seamless SAP Integration | Secure Access | Auth0 with third-party APIs. Secure authentication & smooth data exchange for your business
SAP CAL System Setup: Cost optimization | SAP Trial system
SAP CAL System Setup: Cost optimization | SAP Trial system
Cost optimization | SAP Trial system – Set up your SAP CAL system efficiently. Learn about trial costs, licensing, and tips to optimize your expenses.
SAP Trial Systems | CAL Systems: Setup & Best Practices
SAP Trial Systems | CAL Systems: Setup & Best Practices
SAP Trial Systems | CAL Systems simplify SAP deployment in the cloud, enabling quick setup of demo environments with minimal effort.