Query SAP Hana Extension 2.0

gabriel_gomez — Thu, 22 Feb 2024 05:15:09 GMT

I am currently creating a 2.0 extension to perform queries.
I am making the extension for sap Hana.
This is the query I am using
SELECT COUNT(VBELN) AS "Quantity", TO_DATE(AUDAT, 'YYYYMMDD') as Datevedia , CURRENT_DATE FROM SAPABAP1.VBAK WHERE ERNAM ='CNX_ERP_CPI' AND AUART ='ZB2C' AND AUDAT >= '20240221' GROUP BY TO_DATE(AUDAT , 'YYYYMMDD') ORDER BY TO_DATE(AUDAT, 'YYYYMMDD');
I have the following problem.
I want to group the results by day.
When the next day passes, the result accumulates and this should not happen. example 11:59 PM is 50 records. The next day should start with 0 records and not 50 from the previous day.
I don't know what I should do to accumulate correctly.

21-02-2024 23:59

22-02-2024 00:10

Re: Query SAP Hana Extension 2.0

Mike_L — Tue, 27 Feb 2024 11:14:06 GMT

Make sure that the metric is of type "gauge" and not "count", and then solve it within your query to return exactly the number you want to report on each execution.

topic Query SAP Hana Extension 2.0 in Extensions

Query SAP Hana Extension 2.0

Re: Query SAP Hana Extension 2.0