Max IN-Count
Type
Constant Integer
Since
1.2
Description
The SQL-generator of instantOLAP generates IN-lists to filter dimension-keys. The lists can become quite long and there is a maximum length of IN-lists for each individual database. Generally, IN-lists can have 1000 or more entries, but some databases only allow smaller lists. The default-value for this value is 500, by changing this property you can allow to generate longer or shorter lists. If the number of needed elements in a lists exceeds this value, the SQL-statement will be split into two or more statements by the SQL-generator.
For the most common database-systems this property is already pre-defined and there is no need to change this property.
Examples
Max In-Count = "100"
