MicroStrategy ONE

Link to a prompted report using a list of attribute elements

Before you begin

This is an example of creating manual link URLs to link reports and documents. A link is a connection in a document to another document, a report, or a web page. A link lets an analyst execute another document or report (the target) from a document (the source), and to pass parameters to answer any prompts that are in the target. For basic information on link URLs created manually, see Creating link URLs manually; for an introduction to this example, including prerequisites, see Examples of link URLs created manually.

This method passes a list of attribute elements to the target, which uses the list to answer prompts. The document used in the first example is reused in this example. The dataset does not have any prompts, and it displays the revenue and forecasted revenue by Region. Rather than one link at the bottom of the document, each region attribute is now a link, as shown in the following sample:

Source document: Region (with link), Revenue, Forecast

Each link executes the Revenue vs. Forecast (subtotals) report, which breaks down the values by category and quarter. The list of attribute elements answers the report's prompt on Region, so only the selected Region is included in the target report, as shown in the following sample:

Target report: Region, Category, Q1 02 Revenue & Forecast, totals

The sample displayed above is a composite, allowing you to see that the totals agree.

To create the source document

  1. Copy the Example 1: Document Drilling document, created in Link to a non-prompted report. Rename the copy Example 3: Document Drilling.

  2. Open Example 3: Document Drilling in the Document Editor.

  3. Delete the "Click here" control in the Document Footer, to remove the previous link.

To create a link with a list of attribute elements

  1. Right-click the {Region} control in the Region Header and select Properties.

  2. On the General tab, select the Is hyperlink check box.

  3. Type the following in the Hyperlink box, replacing reportID with the report ID of the Revenue vs. Forecast (subtotals) report:

    • http://localhost/MicroStrategy/asp/Main.aspx?evt=4001&reportID=reportID&elementsPromptAnswers={&Region@GUID};{&Region@ElementID}

    • The auto text code {&Region@ElementID} resolves at run time to the element ID of the attribute element that is clicked on in the document.

  4. Click OK.

  5. Save and close the document.

Run the document in MicroStrategy Web and click the link to execute the prompted report.

Related Topics