Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Datetime parameter in KPI Delete query

Hi Experts,

We have KPI objects in which we need to retain data for some period of time lets say, I want to retain data for the last 24 hrs and delete the remaining KPI data. I have prepared KPI query in delete mode. In Filter Expression field of the query i am passing the expression as

"[TimeStamp] <= to_date ( '01/12/2015' , 'MM/DD/YYYY') "

then i am getting the following error:

SQL error has occurred on query The SQL statement "DELETE FROM MDO11061 WHERE FIELD2 <= to_date ( '01/12/2015' , 'MM/DD/YYYY')" contains the syntax error[s]: - 1:46 - SQL syntax error: the token "(" was not expected here

Is it possible to perform such function in the Delete mode of KPI query. If yes, what am I doing incorrectly ? Has anyone faced similar issue earlier.

I would highly appreciate any hint which could help in solving this problem.

System Information:

NW 7.31 SP 10

Oracle 11.2.0.4

MII 14.0 SP5 patch 7

Regards,
Darshan Sheth

Former Member replied

Hi Darshan,

Try using [Timestamp] > [Param.1]. In the parameters tab specify the parameter and type as timestamp.

Regards,

Anushree

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question