MicroStrategy ONE

Answer Value Prompts  in iOS (valuePromptAnswers)

The following parameters and values are used to pass value prompt answers for executing a report or a document using the mobile URL API.

Parameter Value

evt

4001 - runReport

Executes the report specified by either the reportID or reportName parameter

2048001 -  executeRWDocument

Executes the document specified by the documentID parameter

reportID

ID of the report to be executed

reportName

Name of the report to be executed

documentID

ID of the document to be executed

reportViewMode

Mode in which the report will be viewed:

  1 = Grid mode

  2 = Graph mode

  3 = Grid and graph mode

valuePromptAnswers

Specifies the answer to a single value prompt or multiple value prompts in the form of a string value.  When there are multiple value prompt answers, each individual answer is separated by "%5e", a percent encoded caret ("^") character.

The caret ("^") is not a valid URL character and must be percent encoded if you follow the recommendations of the IETF. This is one of the "unsafe" characters defined in RFC1738 (which was updated by RFC3986). Previously, the caret character would not cause a problem, but many browsers will no longer allow its use.

Because value prompt answers do not have an identifier that allows them to be matched with the actual prompts, the order of the prompt answers is very important. It determines the order in which prompts are answered. If you want to skip an object prompt answer when there are multiple object prompts, simply use the percent encoded caret character ("%5e"), without anything else, to signify an unfurnished prompt answer. An unfurnished prompt answer for the first prompt would be represented by a single percent encoded caret character ("%5e"), while an unfurnished prompt answer for subsequent prompts would be represented by two percent encoded caret characters ("%5e%5e")—one delimiting the previous furnished prompt answer and one delimiting the unfurnished prompt answer.

The prompt answers, and their order, in this parameter pertain only to value prompts. So, for example, if the first value prompt for a report is preceded by an element prompt, you would notsignify an unfurnished answer to this element prompt; instead, the first prompt answer would be the one for the first value prompt.

Because of the convention for signifying unanswered prompts, you are not able to answer a value prompt with an empty string through the URL.

The sample URLs below show how to pass value prompt answers to a report from inside your custom mobile application. To pass answers to a document, use the documentID parameter. MicroStrategyMobileServer is the name of your MicroStrategy Mobile Server.

Sample URL for passing value prompt answers to a report in a .NET environment

Copy
Main.aspx?evt=4001&reportID=4CF6D88A4588097466A4B7B8851A161F&reportViewMode=1&valuePromptAnswers=1/1/2009

Sample URL for passing value prompt answers to a report in a J2EE environment

Copy
mstrweb?evt=4001&reportID=4CF6D88A4588097466A4B7B8851A161F&reportViewMode=1&valuePromptAnswers=1/1/2009

Sample URL for passing value prompt answers to a report from outside MicroStrategy Mobile

Copy
mstr://evt=4001&reportID=4CF6D88A4588097466A4B7B8851A161F&reportViewMode=1&valuePromptAnswers=1/1/2009

When you have multiple projects configured in MicroStrategy Mobile, you can use URL parameters to execute a report in a specific Intelligence Server and project. In the absence of these parameters (server and project), the report execution is performed on the first available project in the list of projects on the Settings screen for MicroStrategy Mobile.