Concatenates the specified dimensions.
Syntax
CONCAT(arg1, arg2, ….)
Example
CONCAT([orderNumber],[status])
Returns a substring from a given string.
Syntax
SUBSTRING ([dimname], start, length)
SUBSTRING('abcdef', 2, 3);
Performs logical tests and return appropriate values, as is used to search for a match to an expression. But a CASE function can always be rewritten as an IF function, although the CASE function will generally be more concise.
Syntax
CASE expression value1 CASE expression value2 CASE expression value3
case([requiredDate]-[shippeddate]<1)'Delayed' case([requiredDate]-[shippeddate]>1)'AdvDelivery' case([requiredDate]-[shippeddate]=1)'OnTimeDelivery'