Apart from filters in Tableau, users can also use prompt answering option in MicroStrategy using BI Connector Web Data Connector. 


Following are the different types of Prompts in MicroStrategy

  1. Value Prompts
    • Date Value Prompts
    • Text Value Prompts
    • Numeric Value Prompts
  2. Element Prompts
  3. Object Prompts
    • Attribute Object Prompts
    • Metric Object Prompts
    • Filter Object Prompts
  4. Qualification Prompts
    • Attribute Qualification Prompts
    • Metric Qualification Prompts
    • Hierarchy Qualification Prompts


Below are the detailed procedure for answering each and every type of prompts.


Value Prompts


To answer value prompts, user needs to enter the values in the text box for given attributes/metrics based on which the report data needs to be filtered. 


For Date value prompt, date picker will be available. There will be certain criterion like Required/Optional prompts, Minimum/Maximum values to enter the input. User needs to answer the prompt satisfying all the conditions.



Input the appropriate values for each prompt based on the conditions and click on "Run Report" button to execute the report.


Element Prompts


To answer element prompts, user needs to select the value for given attributes based on which the report data needed to be filtered. 


The selection box can be either Drop down box, Check box, List box, Dual list box or Radio buttons as per the prompts style saved in MicroStrategy.



Select the appropriate values for each prompt based on the conditions and click on "Run Report" button to execute the report.


Object Prompts


To answer object prompts, user needs to select the object (which can be either an attribute or metric or any filter) based on which the report data needed to be filtered. 


The selection box can be either Drop down box, Check box, List box, Dual list box or Radio buttons as per the prompts saved in MicroStrategy.



Select the appropriate values for each prompt based on the conditions and click on "Run Report" button to execute the report.


For filter object prompt, selection of any value will again redirect the page to answer second level prompts based on filter selection. User needs to answer new set of prompts and then click "Run Report" button.


Qualification Prompts


To answer qualification prompts, user needs to select the object (which can be either an attribute or metric) and form an expression based on which the report data needed to be filtered.


  1. For Attribute Qualification Prompts, choose the following values to form an expression.
    • An attribute
    • Expression type – either Select or Qualify
    • Form type (e.g. ID, DESC, DATE) – This is applicable only for Qualify expression
    • Condition
    • Attribute’s value
  2. For Metric Qualification Prompts, choose the following values to form an expression.
    • A metric
    • Condition
    • Metric’s value
    • Qualify at level – either at Default level or at Metric level or at Report level
  3. Hierarchy Qualification Prompts is similar to attribute qualification prompt, except that attributes will be displayed in the tree form for selection along with their parents and children.



If you still have trouble answering the prompts for the report, please contact us at support@biconnector.com or file a ticket at support portal.  We will follow-up with you to help you through the prompt answering.