MicroStrategy ONE

How to Display the Query View for a Visualization

A query view displays the SQL or CSI queries executed against a visualization's data source. Use the query view to troubleshoot data discrepancies or fine-tune the underlying queries to increase performance.

Open the Query View

  1. Click More at the top right of a visualization.

  2. Choose Query Details.

    The query run against the data source appears on the Query Details dialog.

  3. Click Copy to Clipboard.
  4. Paste the query into a text editor or IDE to identify issues, while referring to the visualization for reference.

Query does not capture the following:

  • Smart calculation steps, such as metric limits from metric selectors, smart metric calculations, calculation elements, and subtotals.
  • Details about dataset execution.
  • Data blending instructions for new derived elements, derived attributes, and similar calculations that are part of document setup.