MicroStrategy ONE

Linking to the dataset reports of Grid/Graphs

A Grid/Graph can be linked to its dataset report, allowing MicroStrategy Web users to execute the dataset report. The dataset report is the source of the data displayed on the Grid/Graph, although the Grid/Graph may not display all of the data contained on the dataset report.

For example, a Grid/Graph provides revenue data for regions. Its dataset report contains revenue at the country and call center levels, as well as revenue forecasts at all levels. A user can click a link on the Grid/Graph to see the additional information contained in the dataset. For another example, see the Grid/Graphs chapter of the Document Creation Help.

The dataset report opens in a new window, keeping the document open in the original window. You can instead specify that the dataset report opens in the same browser window as the document, replacing the document. Links to datasets are functional in all modes in MicroStrategy Web except Design Mode.

The link to the dataset can run only the dataset report of the related Grid/Graph. To insert a link that displays a Web page, executes a different report, or passes prompt parameters to the target report, create a link instead.

Prerequisite

This procedure assumes that the document contains a Grid/Graph. For instructions on adding Grid/Graphs, see Displaying reports in documents: Grid/Graphs.

To add a link to the dataset report of a Grid/Graph

  1. Open the document in the Document Editor. How?

  2. Right-click the Grid/Graph and select Insert Link to Dataset.

    • A text field is created at the upper right corner of the Grid/Graph, although you can move it. The text field displays the dataset name from the Grid/Graph.

  3. By default, when the link to the dataset report is clicked in MicroStrategy Web, the dataset report opens in a new window and keeps the document open. To have the dataset report open in the same browser window as the document, replacing it:

    1. Select the text field containing the link to the Grid/Graph's dataset report.

    2. In the Property List: Navigation section, set Open in new window to False.