Skip to main content

Hi,

I am trying to leverage the existing P2P cockpits for KPIs and Dashboards. There is an KPI which has definition as below -

WHEN ISNULL(<%= VAR_KPI_DELIVERY_TYPE %>) = 1

//         -- Date Selection  

        AND PU_FIRST("EKPO", "<%= VAR_GS_ACTIVITY_TABLE %>"."EVENTTIME", "<%= VAR_GS_ACTIVITY_TABLE %>"."ACTIVITY_EN" = '<%= VAR_ACTNAME_CREATE_POI %>') >  {p1}

        AND PU_FIRST("EKPO", "<%= VAR_GS_ACTIVITY_TABLE %>"."EVENTTIME", "<%= VAR_GS_ACTIVITY_TABLE %>"."ACTIVITY_EN" = '<%= VAR_ACTNAME_CREATE_POI %>') <= {p2}

        THEN NULL

        //

Here there are 2 parameters p1 and p2. The values are blank for those parameters. I am not sure what values to be given for those. Can you please help me here?

Hey Sachin,

 

Could you elaborate a little further and give some context to the KPI. Where in the dashboard is it located, how is the KPI called, what are you expecting it to show? Perhaps, someone can help you more easily then.

 

Kind Regards,

Maurits


Hi, reading the PQL, the PU function will return an EVENTIME, (timestamp) so P1 and P2 should be a timestamp for a condition to work.

 

Usually, this is available in the settings tab for user to fill.


Reply