Using Parametrised KPIs
This example shows how to:
Call a KPI from inside another KPI.
Create a parametrized KPI and call it from inside another KPI.
kpis: - id: TOTAL_INVOICE_VALUE displayName: Total Invoice Value description: "" pql: SUM(CASE WHEN "BKPF"."BELNR" IN ('9330002454','9330001796','9330002109') THEN "BSEG"."WRBTR_CONVERTED" * 0.3 WHEN MONTH("BKPF"."CPUDT") = 4 THEN "BSEG"."WRBTR_CONVERTED" * 3.1 ELSE "BSEG"."WRBTR_CONVERTED" END) unit: "" format: "" #kpi calling the previous one - id: "TOTAL_INVOICE_VALUE_CALL" displayName: "Total Invoice Value Call" description: "" pql: KPI(TOTAL_INVOICE_VALUE) # kpi defined with a parameter - id: TOTAL_INVOICE_VALUE_Param displayName: Total Invoice Value_Param description: "" pql: SUM("BSEG"."WRBTR_CONVERTED" * {p1} ) parameters: - id: Factor displayName: Factor Value defaultValue: 10 # calling the KPI with parameter value - id: TOTAL_INVOICE_VALUE_Param_Use displayName: Total Invoice Value_Param description: "" pql: KPI(TOTAL_INVOICE_VALUE_Param, 50)
This example shows a snippet of a KPI List that is used to set KPI parameters from Views.
- show: true kpi: TOTAL_INVOICE_VALUE_Param order: 100 kpiParams: - id: Factor # This ID must match KPI parameter ID defined in KM value: "50"