MicroStrategy ONE

Finding values

Whenever you want to quickly locate a specific data value in a grid report, or you want to jump to a section of a large report, use the Find feature. You can also use the Find feature to locate a string in the SQL syntax, when viewing a report in SQL View. (For steps to look at a report in Grid View or SQL View, see Report types.)

You can also narrow your searches if you need to, by defining specific requirements for your search.

In MicroStrategy Web, use the browser's Find feature to locate values or other data in a report. For example, in Internet Explorer, from the Edit menu, select Find on this page.

To find a value in a report in Developer

  1. Open a grid report.

  2. From the View menu, display the report in the appropriate view, depending on what you want to find:

    • Grid View or Grid Graph View, to find a value in the report
    • SQL View to find a string in the SQL syntax

    The Find feature is not available in Graph view.

  3. From the Edit menu, select Find.
  4. Enter the value to search for and click Find Next. The first instance of the value is highlighted if the value is found.
  5. Click Find Next again to search for additional instances of the value in the report.

Each cell in a grid report is treated as a string value. This means that, for example, if a grid report contains data that includes the numbers 50 and 500, both cells are found when you search for 50. To change this behavior, see Narrowing a search for report data.