Strategy ONE
Maximum SQL/MDX Size
The Maximum SQL/MDX Size property specifies the SQL size (in bytes) on a pass-by-pass basis. If the limit is exceeded, the report execution is terminated and an error message is returned. The error message usually mentions that a SQL/MDX string is longer than a corresponding limitation. The limit you choose should be based on the size of the SQL string accepted by your ODBC driver.
The table below explains the possible values and their behavior:
| Value | Behavior |
|
0 |
No limit on SQL pass size |
|
Number |
The maximum SQL pass size (in bytes) is limited to the specified number |
|
Default |
By selecting the check box Use default inherited value, the value is set to the default for the database type used for the related database instance. The default size varies depending on the database type. |
Increasing the maximum to a large value can cause the report to fail in the ODBC driver. This is dependent on the database type you are using.
Levels at Which You Can Set This
Database instance only