How to add concatenated column in benchmarking dropdown and filter that column with KPI's and process explorer

Hi Varun,

are you using one of the Celonis starter kits?

No, i am creating knowledge model from scratch, it is not starter kit

Ok, but how far have you come? Were you able to create the dropdown and update variables for filtering?

yes, i have created an attribute in KM with concatenated column and configured that in dropdown but i am not able to use that for filtering as it says column not found

Hi Varun,

You can try to use the concatenated formula directly in filter statement.

Example:

(dimension_benchmark ==="plant" && "AUFK.WERKS ||' - '|| AUFK.DWERK_TEXT")} = '${benchmark_1})

For dropdown columns how should i configure concatenated columns?

Now i have created a new attribute which is not recognized by PQL,it says missing column in that table

Try to use Tablename.AttributeID. if are you having same ID in different tables sometimes it will give an error.

can you guide me how to add concatenated column in custom object for drop down.

in the below code instead of EKPO.BUKRS i need EKPO.BUKRS concatenated with EKPO.BUKRS_TEXT

customObjects:

  - id: dimension

    displayName: dimension

    customAttributes:

      columns:

        - id: EKPO.BUKRS

          displayName: company code

        - id: WERKS

          displayname: Plant

        - id: MATKL

          displayname: Material

1. Create an attribute in EKPO with concatenation of this field (Ex : CompanyCode_CC)
2. Use it in Custom objects CompanyCode_CC
3. Process explorer filter:

${(dimension_benchmark ==="CompanyCode_CC" && "EKPO.BUKRS ||' - '|| EKPO.BUKRS_TEXT")} = '${benchmark_1})

dimension_benchmark : Variable holding benchmark dimension

benchmark_1 : Variable holding benchmark value

I am facing below error.

Process Explorer [id:process-explorer-49fa3908-9a29-4c19-aa05-499de7342f33]: Invalid PQL query. Syntax error near [false] after reading [] at line 1. Please refer to PQL documentation for available syntax., Syntax error near [false] after reading [] at line 1. Please refer to PQL documentation for available syntax. Please review your PQL statements in the Knowledge Model and in the View YAML filters.

id: process-explorer-49fa3908-9a29-4c19-aa05-499de7342f33

type: process-explorer

settings:

  eventLogs:

    - eventLog: EL_CEL_P2P_ACTIVITIES__ACTIVITY_EN

      id: 0edb4e45-4d00-4b05-9465-24c621d5c9eb

      order: 100

  transitions: false

  graphControls: panel

filters:

  - pql: ${(dimension_benchmark ==="companycode_cc" && "EKPO.BUKRS ||' - '||

      EKPO.BUKRS_TEXT")} = '${benchmark_1})

knowledgeModelKey: ptp-km

Hi Varun,

One solution is to add a new column to EKPO in Data Transformation. This worked for me, because then I was able to add just one column to the filter expression in the YAML file.

For Example: Name this column "CompanyCode_CC". Then the filter expression should look like this.

${(dimension_benchmark ==="CompanyCode_CC" && "EKPO.CompanyCode_CC")} = '${benchmark_1})

You missed 'Filter' word

- pql: FILTER ${(dimension_benchmark ==="companycode_cc" && "EKPO.BUKRS ||' - '||

   EKPO.BUKRS_TEXT")} = '${benchmark_1}'

Yes, i was able to resolve the error by adding FILTER.

Would you mind sharing the syntax for adding one more concatenated dimension in the filter statement.

You can add it in same way using || Operator

- pql: FILTER ${(dimension_benchmark ==="companycode_cc" && "EKPO.BUKRS ||' - '||  EKPO.BUKRS_TEXT") || (dimension_benchmark ==="companycode_cc" && "EKPO.BUKRS ||' - '||  EKPO.BUKRS_TEXT" )} = '${benchmark_1}'

Thank you very much. It is working now😊