Skip to main content
Question

Using Parameters in PQL -PU functions

  • February 22, 2023
  • 2 replies
  • 7 views
S
Level 3

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?

    2 replies

    .
    Level 9
    • .146004200
    • Level 9
    • February 23, 2023

    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

    R
    Level 8
    Forum|alt.badge.img+14
    • rio.cinco12
    • Level 8
    • February 24, 2023

    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.

    Community Code of ConductAccessibility statement