Data flow
BIND
Description: Binds values from one table to another table within the data model using existing relationships.
Syntax: BIND ( target_table , value )
Example:
TABLE( PU_MAX("caseTable", BIND("OrderPos", "productTable"."price")) AS "Max Product Price by Case" )
CASE WHEN
Description: Evaluates conditions and returns different values depending on which condition is met.
Syntax: CASE WHEN condition THEN result [ WHEN condition THEN result ]* [ ELSE result ] END
Example:
TABLE( CASE WHEN "Orders"."GrossValue" > 1000 THEN 'High' ELSE 'Low' END AS "Bucket" )
COALESCE
Description: Returns the first non-NULL value from a list of expressions.
Syntax: COALESCE ( expr1 , expr2 [ , ... ] )
Example:
TABLE( COALESCE("T"."Sales", "T"."Forecast", 0) AS "SalesOrForecast" )
FILTER
Description: Applies a filtering condition to restrict the dataset used in calculations.
Syntax: FILTER [FORCED] condition ;
Example:
FILTER "Orders"."Country" IN ('DE','US');
TABLE( COUNT("Orders"."OrderID") )