MicroStrategy ONE
Creating a link URL to specify page-by, report view, layout, or grouping for the target
The Link Editor provides a quick and easy way to link to documents and reports. For steps to create a link using the Link Editor, see Creating a link for a mobile document.
For a document on an iPhone or iPad, you can specify a report's page-by or report view, or a document's layout or grouping. For a document on an Android device, you can specify a report's report view. (The report view is whether a report is displayed as a grid, a graph, or both a grid and graph.) To specify these parameters, use the hyperlink properties and create the link URLs manually, by using the object ID and link syntax, as described below.
Prerequisites
Before creating links, create any target documents and reports, and use the following procedure to obtain their IDs:
-
Navigate to the folder location of the report or document.
-
Right-click the report or document, and select Properties. The Properties dialog box is displayed, with the object's ID displayed in the ID field. You can highlight and copy this ID to use in a link URL.
To create a link using a manual URL
-
In MicroStrategy Web, open the document in Design Mode or Editable Mode.
-
To use a text field for the hyperlink, complete the following steps (if you are adding an image, skip this step):
-
From the Insert menu, select Text.
-
Click in the section of the document where you want to place the text field. If you click and drag in the section, you can size the text field.
-
Type the text to be displayed to users into the text field. You can add static text, dynamic text (in the form of data fields and auto text codes), or a combination to the text field:
-
To add static text, type the static text into the text field.
-
To add a data field, drag and drop a dataset object from the Dataset Objects panel into the text field.
-
To add an auto text code, from the Insert menu, select Auto-text, then select the code to insert.
-
To use an image for the hyperlink, complete the following steps:
-
From the Insert menu, select Image.
-
Click in the section of the document where you want to place the image. If you click and drag in the section, you can size the image. The Properties and Formatting dialog box opens.
-
Type the address of the image file to insert in the Source field.
-
Click OK. The image appears in the document.
-
Right-click the image or text field, and select Properties and Formatting. The Properties and Formatting dialog box opens.
-
From the left, click General, then select the Is Hyperlink check box.
-
Type the link URL in the Hyperlink field:
-
To have the link execute a document, use the syntax:
-
To have the link execute a report, use the syntax:
-
To add additional parameters to the URL, such as providing answers for the target document's prompts, see Using links to display document layouts and group data, and run reports and documents on other servers and projects.
-
Click OK to return to the document.
To ensure that the area of a link is large enough to recognize a user selecting it, make sure it has a height and width of at least 40 pixels.
For background information about adding data fields and auto-text codes to documents, see the Document Creation Help.
To ensure that the area of a link is large enough to recognize a user selecting it, make sure it has a height and width of at least 40 pixels.
For background information about adding images to documents, see the Document Creation Help.
http://
MSTRMobileURL
?&src=
source
&evt=2048001¤tViewMedia=2&documentID=
objectID
http://
MSTRMobileURL
?&src=
source
&evt=4001&reportViewMode=
view
&reportID=
objectID
Replace the italicized variables, as listed in the following table:
Variable |
Replace With |
||||||||||||
|
To use an absolute path to your Mobile Server, use one of the following:
Replace To use a relative path to your Mobile Server, use |
||||||||||||
|
The page component that should handle the action and the event:
|
||||||||||||
|
Report view mode:
|
||||||||||||
|
The object ID of the target document or report |
Using links to display document layouts and group data, and run reports and documents on other servers and projects
Once you have created a link to run a report or a document on an iPhone or iPad, you can add parameters to the URL to perform additional tasks, such as providing answers for prompts in the linked document, or specifying the layout to display when a document is run.
For Android and iOS devices, you can run reports or documents from a different project or server. The project or server that you link to must be defined in the mobile configuration for the device.
The table below lists the tasks you can perform, and the syntax for the link parameters to perform them. You can add these parameters to a link URL by separating each parameter with an ampersand (&
). The link parameters are case sensitive. For example, the following URL contains parameters to display the first layout in a document:
Main.aspx?evt=2048001¤tViewMedia=2&documentID=E8663E7A4D8CDF05C060129D0061692&layoutIndex=0
Task |
Syntax |
|||||||||
Run a report or document from a different project or server |
Replace By default, if the URL does not specify a server and project, the current server and project are used. You can specify these parameters, called session parameters, to execute a report or document in a different server or project, and provide the appropriate login name and password. For more information on session parameters, see the Customizing MicroStrategy Web section in the Web SDK help, which is available from the SDK page in MicroStrategy Community. |
|||||||||
Display a specific layout in a document |
Replace |
|||||||||
Specify the group-by element in a document |
Replace the italicized variables with the following:
You can specify multiple group-by elements by separating each set of group-by parameters with a caret (^), as follows:
|
|||||||||
Specify the page-by element in a report |
Replace the italicized variables with the following:
You can specify multiple page-by elements by separating each set of page-by parameters with a caret (^), as follows:
For information about finding the ID of an individual attribute element, see To obtain the ID of a specific attribute element in a document. |
To obtain the ID of a specific attribute element in a document
-
To obtain the ID of a specific element in an attribute, you must first obtain the ID of the attribute. Navigate to the folder location of the attribute.
-
Right-click the attribute, then select Properties. The Properties dialog box is displayed, with the attribute's ID displayed in the ID field.
-
Highlight the ID, then copy it to the clipboard.
-
Open the document that contains the attribute in Editable Mode.
-
Right-click the header of the attribute in the Grid/Graph, then point to Attribute Forms, and select ID. The ID of each element in the attribute is displayed.
-
The full attribute element ID is the ID of the element's attribute, followed by a colon (:) and the ID of the element displayed in the grid. For example:
8D679D4B11D3E4981000E787EC6DE8A4:2