This list contains constructs and templates that can be used to create an expression. Templates combine multiple functions into a group. For example, the search case template includes the case, when, else, and end functions.
if then else
This construct is the template for an if...then...else statement. This construct appears in the Top 10 Retailers for 2005 sample report in the GO Data Warehouse (analysis) package.
in_range
This is the template for an in_range expression.
search case
This construct is the template for a search case, including the CASE, WHEN, ELSE, and END functions.
simple case
This construct is the template for a simple case, including the CASE, WHEN, ELSE, and END functions.