Child pages
  • OT-QPROV-ADHOC
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