Strategy ONE

Enable Mismatch Log in SQL View

Enable Mismatch Log in SQL View is an advanced VLDB property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The mismatch log helps determine why a report that can use dynamic sourcing cannot connect to a specific Intelligent Cube. By default, the mismatch log can only be viewed using the MicroStrategy Diagnostics and Performance Logging tool. You can also allow this log to be viewed in the SQL View of a report.

This VLDB property has the following options:

  • Disable Mismatch Log in SQL View (default): This option allows the mismatch log to only be viewed using the MicroStrategy Diagnostics and Performance Logging tool.
  • Enable Mismatch Log in SQL View: Select this option to allow the mismatch log to be viewed in the SQL View of a report. This information can help determine why a report that can use dynamic sourcing cannot connect to a specific Intelligent Cube.

Levels at Which You Can Set This

Report, template, and project