SCN Wiki upgrade to version 6.13 on Tuesday 19.11.2019 - beginning 07:30 am CET

During upgrade process new content will not be transported to new Wiki version

Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

For a QueryProvider with the technical query name <CompID> an Adhoc query can be used in RSRT for easy analysis of the results, the syntax of the Adhoc Query for the QueryProvider is: @QCompID/!@QCompID.

Sample in Transaction RSRT: properties - checking a query as QueryProvider:

Afterwards, you can check the generated QueryProvider @QNR_QPROV_LOCALC in RSRT and test the results:

Now execute and the initial drilldown of the adhoc query is visible: all key figure structure elements are in the columns while all characteristics are in the free characteristics and would have to be manually added to the drilldown:

In the Info tab of the adhoc template you can see the syntax with the '@Q'  for the QueryProvider and the '!' for the adhoc query:

 

 

 

 

  • No labels