Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ruthvik_Chowdary
Active Contributor
46,456
Dear SAP Friends,

Welcome to another interesting topic, in Analytical area.



In this blog will see how to design our own report Via Query Browser by using SAP delivered Analytical Queries

In 1809 standard Analytical Queries are 588 in 1909 number has increased to 753.

Introduction

The Query Browser is a Fiori application using which we can quickly and easily search, browse, and tag the analytical queries. This application displays all the analytical queries to which the user has access. We need to assign the Query Browser role to a user. (Fiori Role:- SAP_BR_EMPLOYEE)

  1. Open Query Browser App




  1. Select any Analytical Queries as per requirement which you wanted to develop a Report below are some of the Analytical Queries related to Manufacturing



  • C_MFGORDCOMPEXCSCONSMPTQRY

  • C_MFGORDEROPEXECDURNQRY

  • C_MFGORDOPERATIONSCRAPQRY




  1. Once you selected Analytical Queries in bottom click on open for Analysis, it will open in Design Studio

  2. Based on the Query we selected the selection Parameters will vary select as per your requirement

  3. Once opened in the left-hand side we can see 2 lines



  • Dimensions

  • Column + Rows




  1. Which fields we want in the report we can simply drag and drop in either column or row.

  2. I have added fields as shown below




8. As per the selection of fields will get the report



9. This report we can download to excel and change the graphical presentation



10. Above are the option to make report useful for presentation



Different type of chats

By using Action Icon in Query Bowser, Save as Tile we can directly send Mail or save as tile to save time



Directly if we select tile report will open no need to search for analytical query, drag and drop and all not required.



Also, we can choose in launchpad to which group this tile need to be added



 

Please share, Like and Comment anything else you want to share or add points.

Thanks & Regards

Ruthvik Chowdary

SME – S/4 HANA Manufacturing & Procurement

SAP Ariba P2P

 

 
31 Comments
Labels in this area