Upgrading From Pre-9.0.x Versions of MicroStrategy

The default option for the SQL Global Optimization VLDB property changed in MicroStrategy 9.0.0. In pre-9.0.x versions of MicroStrategy, the default option for this VLDB property was Level 2: Level 1 + Merge Passes with different SELECT. Starting with MicroStrategy 9.0.0, the default option for this VLDB property is Level 4: Level 2 + Merge All Passes with Different WHERE.

When projects are upgraded to 9.0.x, if you have defined this VLDB property to use the default setting, this new default is applied. This change improves performance for the majority of reporting scenarios. However, the new default can cause certain reports to become unresponsive or fail with time-out errors. For example, reports that contain custom groups or a large number of conditional metrics may encounter performance issues with this new default.

You can use Integrity Manager to determine any changes in performance that your reports may encounter due to upgrading your MicroStrategy projects. This allows you to determine which reports may encounter performance issues due to this VLDB property modification.

To resolve this issue for a report, after completing an upgrade, modify the SQL Global Optimization VLDB property for the report to use the option Level 2: Level 1 + Merge Passes with different SELECT.

Levels at Which You Can Set This

Database instance, report, and template