Skip to main content
Question

Using Parameters in PQL -PU functions

  • Feb 22, 2023 11:41 AM UTC
  • 2 replies
  • 81 views
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
    • Feb 23, 2023 8:10 AM UTC

    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

    Level 8
    Forum|alt.badge.img+14
    • rio.cinco12
    • Level 8
    • Feb 24, 2023 8:16 AM UTC

    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