To understand when the data in the Pricing Dashboard was last updated, a dedicated BW query with below information is also feeding the Pricing Dashboard.
- Source query name
- Source query description
- Main Infoprovider
- Part provider
- Date and Time of the last refresh in BW
A BW query can be built on several providers, gathered in a Multiprovider, a Composite Provider or any other virtual object.
Therefore the choice is made for a single query to get the latest request loaded in time, whatever the part provider is.
Query technical information
Query technical name : QV_BW_QRY_CPCOPC00_0001
Composite Provider : CPCOPC00
HANA view : CV_FMCO_TECH_TIMESTAMP
Query design
There is only one Infoobject used in the query (0BWAPPLNM) to allow the use of a selection variable on it (V_APPLNM).
Other objects are simple fields to display the data.
Query selections
The input variable V_APPLNM must be populated with the list of Query technical names to analyze.
Query result
The list of queries in input is displayed, with the relevant information in lines.
The refresh date and time is a Timestamp format yyyymmdd hhmmss.
Composite Provider
The Composite Provider CPCOPC00 is the source of the Refresh Query.
It is built on the HANA Calculation View CV_FMCO_TECH_TIMESTAMP.
Infoobject 0BWAPPLNM is assigned to the Input Parameter IP_QUERIES in order to propagate the query selection into the lower layer of the CV.
HANA Calculation View
The Calculation View CV_FMCO_TECH_TIMESTAMP is extracting the refresh information for each query to analyze.
