<Condition>column1 = value1</Condition>
<Condition>column1 = value2</Condition>
<Condition>column1 = value3</Condition>
The default MaxElementDepth Property for an MSXML DOM object that is used by Analysis Services to build the XML document is 256 in MSXML 6.0.
Therefore, when the MaxROLAPOrConditions configuration is increased, the generated XML document can exceed this maximum depth.
As the number of OR conditions increases, the complexity of the SQL statement that is generated may exceed the capacity of the relational database server, causing new error conditions.
The following are examples of conditions that may cause new errors:
- Exceeding the maximum number of parameters in a statement
- Exceeding the maximum number of conditions in a where clause
- Errors in parsing the SQL query string
- Exceeding the maximum size of an SQL query string
Therefore, we recommend that any adjustments to the MaxROLAPOrConditions configuration value be made with caution.