When one create a flag but wants to use variables in the flag PQL, is it possible to use variables? I get errors when using variables and have to convert the variables to KPI's before it works. Is that the correct approach?

Hi Du Toit,

Variables can be defined at 2 stages, backend and front end, if you want to use a variable within the transformation across multiple data models in that case you need to define them at the Global Jobs so you can use it across the transformation's in all the data models and secondly if you want to use a variable in the front end then it needs to be defined at a use case level and that variable can be interpreted even in the KPI's.

Cheers !!

Thanks this makes sense, appreciate.

Hi Santosh, A follow up question,. Why would it say unable to determine impacted rows?

The ${{STP_TABLE}} is a runtime variable for "o_custom_Payment"."STPStatus"

When I replace the variable with the table named spelled out it works:

I however need to make use of variables in this case.

I created a variable in the knowledge model now and referred to it - now it works.

IS this what you meant in your first reply?

Superb You Got it..

Cheers !!

Thanks for the help