SYMPTOM:
When executing a Strategy 9.4.x and 10.x report, with a rank condition in the Report Limit, against a Sybase IQ warehouse database, a row-by-row insert is performed into the temporary tables. The expected behavior is that the entire dataset, in bulk, is inserted into the temporary tables. As a result of each row from the dataset being inserted by a separate SQL statement the report execution slows down.
Each row of the dataset being inserted by a separate SQL statement.
Rank condition in Report Limit section
Note: If the filtering condition is moved from the Report Limit to the Report Filter the entire insert is correctly performed as a single bulk statement and the execution time performs as expected.
CAUSE:
One cause for this issue is that the database type/version, specified under the 'Database connection type', for the warehouse Database Instance is incorrectly set. The type of database specified dictates the logic of the SQL engine and how it interacts with the various objects and VLDB properties in the report. Choosing an incorrect database connection type can result in unexpected behavior.
ACTION:
Set the correct database type and version in the warehouse database instance object.
