Where
Type
Constant String
Since
2.2
Description
If any Where-condition is defined in this property, it will be added to the generated SQL-statement whenever this dimension-mapping is used.
Where-condition are very useful in combination with single mapped keys because this allows to map different where-conditions to different keys of a dimension. E.g. you could map a condition "SALES.AMOUNT >= 1000000" to a key "BigCustomers" and another condition "SALES.AMOUNT < 1000000" to a key "SmallCustomers". Then the user had the possibility to filter his reports by this categories.
Examples
Where = "SALES.AMOUNT >= 1000000"
See also
Key
