3.5.3.2 Creating Expressions
You can define an expression in the Expression Builder to combine two selected tables.
The expression builder includes the following sections:
- Entities - consists of the Entities folder with the list of tables that you selected from the Entity Groups folder. Double-click the Entities folder to view the selected dimension tables (Product and Segment tables).
- Functions – The 2 types of functions are,
- Database Functions - consists of functions that are specific to databases.
- User Defined Functions - use these functions along with Operators to specify the join condition.
- Operators - Consists of the function operators categorized into folders.
The various types of operators are,
- Arithmetic - +, -, %, * and /
- Comparison - '=', '!=', '< >', '>', '<', >=, <=,'IN', 'NOT IN', 'ANY', 'BETWEEN', 'LIKE', 'IS NULL', and 'IS NOT NULL'.
- Logical - 'NOT', 'AND' and 'OR'
- Set - UNION, UNION ALL, INTERSECT and MINUS
- Other - The Other operators are 'PRIOR', '(+)', '(' and ')'.
To specify the join condition: