KB12588: How to display a prompted value into a Report Services document in MicroStrategy Developer 9.4.x-10.x?

In Strategy Developer 9.4.x-10.x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. However, since a text prompt cannot be directly incorporated in a report object, it must be embedded in a metric.
 
Follow the steps below to display text that is dynamically entered at run-time by the user in a Report Services document in Strategy Desktop 8.x:
 

• Create a value prompt that will prompt the user on the text to be entered in the document, as shown below:
  

• Specify the type of value prompt to be used (in this example, a text prompt is used) as shown below:
  

• It is recommended to choose a default value. If the user wishes not to display any value in the prompt and leave the prompt blank, a blank space needs to be inserted in the 'Default value' field to avoid possible SQL errors, as shown below:
  

• Select the option 'Prompt answer required' as shown below:
  

• Once finished with prompt creation, embed the prompt in a metric using the following ApplySimple statement in the formula bar of the metric editor:
  

  
  ApplySimple("max(#0)", ?, Revenue)

  
  
• Where P1 is the name of the prompt just created, and Revenue is a metric. Any metric can be used in place of Revenue. This statement is shown below:
   
  

• Once the metric is created, it should be incorporated in the report. If OLAP Services are available, then it is sufficient to have the metric present in the Report Objects window; otherwise the metric must be placed on the grid.
• Use this report as a dataset for the Report Services document being created.
• To display the prompt values in the report services document, call the prompt using the following statement in the text box shown in the image below: {&Promptn&}
  

Where n is the order of occurrence of the value prompt when the report is executed. In the example shown, the value prompt is the first to be prompted, and so n = 1.
 
Once this is done and the Report Services document is executed, the prompt will be called, displaying the text entered by the user at run-time, as shown below: