Operator
Type
Constant String ( '=' or 'BETWEEN' )
Since
2.2.3
Description
With this property you can define the operator which the SQL-generator will use to map the dimension-values with the expression. Usually the SQL-generator uses the operator '=', which is the default value for this property.
You can also use the operator 'BETWEEN' - the generator will then use the lowest and the highest value (alphanumeric order) and create a BETWEEN-clause with them. This can bring better performance, especially when mapping a time-dimension.
Examples
Operator = "'='"
will e.g. generate a SQL-statement like
SELECT ... WHERE F_SALES.YEAR IN ( 2004, 2005, 2006 )
Operator = "'BETWEEN'"
will e.g. generate a SQL-statement like
SELECT ... WHERE F_SALES.YEAR BETWEEN 2004 AND 2006 )
See also
Swap Expressions
