SAP BLOG Query Browser

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,308
Tepki puanı
6
Puanları
6
Dear SAP Friends,

Welcome to another interesting topic, in Analytical area.

web-marketing-analytics.jpg


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

q1-1.png


  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

q2.png


  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
    q3.png
  3. Once opened in the left-hand side we can see 2 lines
  • Dimensions
  • Column + Rows

q4.png


  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

q5-1.png


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

q6-1.png


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

q7.png


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

q8-1.png


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

q9.png


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

q10.png


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

q11.png




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


Okumaya devam et...
 
Üst