KB11765: Is it possible to define dynamic default answers for attribute prompts in MicroStrategy?

Often, the default prompt answers made available to end users change dynamically. For example, users may have a report which is prompted on Month but administrators want the end user to be presented with a default answer of "Current Month" when the report is executed. The steps below describe one method of implementing this.
Note, however, that the implementation of this requirement will depend strongly on the user's particular data model. Additionally, the syntax of the custom expression is specific to Microsoft SQL Server and may need to be amended for other database types:

1. Open the Prompt Editor and select the 'Qualify on an attribute' option. Choose Month.
    
   
2. Select the 'Choose default prompt answers' option on this screen.
    
   
3. Click Next and for the Select Default Prompt Qualifications, click the Add button.
    
   
4. When this qualification appears, double-click to add a qualification, and select ID for Qualify On. For the Operator, select Exactly, and then from the drop-down to the left of the text box, select Custom:
    
   
5. Insert the following custom expression:
    
   ApplySimple("month(getdate())",0)
   
6. Save and close.
    
   

A report containing this prompt should present the default prompt answer as the Current Month based on the system clock's current month, as shown below:

 
 
Third Party Product Disclaimer
WARNING:
The third-party product(s) discussed in this article is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.