Manage Value Prompts and Attribute Element Prompts in MicroStrategy

Eagle uses MicroStrategy Value Prompts and Attribute Element Prompts to send input parameters to MicroStrategy while running reports.

A MicroStrategy report can contain no prompts, single, or multiple prompts. Reports containing single prompts use MicroStrategy Value prompts. Reports containing multiple prompts use MicroStrategy Attribute Element prompts.

A Value prompt allows you to pass a single value as in input to a MicroStrategy Report. When using a Value prompt, you first set up the prompt, and then set up a filter to use the Value prompt.

Create a Value Prompt

To create a Value prompt from the MicroStrategy desktop:

  1. From the MicroStrategy Desktop, right click and select Prompt from the New menu.
    You see the Prompt Generation Wizard.

  2. Select the prompt type and click Next.
    You see the second Prompt Generation Wizard dialog box.

    Prompt Generation Wizard Select a Prompt
  3. Select a value prompt type and click Next. Prompt types include:
    Date prompt. Allows users to filter for data related to a specific date or a range of dates.
    Numeric prompt. Allows users to filter numeric data.
    Text prompt. Allows users to filter text data.
    Big Decimal prompt. Allows users to filter data based on a big decimal value for a metric.
    You see the third Prompt Generation Wizard dialog box.

    Prompt Generation Wizard Select a Value Prompt Type
  4. Enter a prompt title in the Title field. Enter instructions for the prompt in the Instructions field.

  5. Select the Prompt answer required checkbox and click Next.

  6. Optionally, specify a default value and click Finish.
    You see the Save As dialog box.

  7. Enter an Object Name and click Save.

Use Value Prompts in the Filter

To create a filter based on the value prompt from the MicroStrategy desktop:

  1. From the MicroStrategy Desktop, right click and select Filter from the New menu.
    You see the New Filter dialog box.

  2. Click OK to continue.
    You see the Filter Editor window.

  3. Select the attribute in the left part of the window on which you want to create a Filter.

  4. Double click the selected attribute.
    You see the Attribute Qualification dialog box.

    Attribute Qualification Dialog Box
  5. Make sure the appropriate prompt is selected in the left window. In the Qualify On field, select ID. In the Operator field, select Exactly.

  6. Click OK.
    You see the Filter window, displaying the resulting filter.

  7. Click Save and Close.
    You see the Save As Filter dialog box.

  8. Enter a name for the object in the Object Name field, and click Save.

Manage Attribute Element Prompts

An Attribute Element prompt allows you to send an input to a MicroStrategy report consisting of multiple values. When you use an Attribute Element prompt, you first create a null filter, then create an Attribute Element prompt based on the null filter.

Create a Null Filter

You create a null filter and then create an Attribute Element prompt based on the null filler.

To create a null filter from the MicroStrategy desktop:

  1. From the MicroStrategy Desktop, right click and select Filter from the New menu.
    You see the New Filter dialog box.

  2. In the/New Filter dialog box, select Empty Filter and click OK.
    You see the Attribute Qualification dialog box.

  3. Select an Attribute from the Attribute list, and double-click it.

  4. In the Qualify On field, select ID. In the Operator field, select Is Null. Leave the Element List section empty. Click OK and then click Save and Close.
    You see the Save Filter As dialog box.

  5. Enter a name in the Object Name field. This example uses Entity ID as the Object Name. Click Save.

Next, complete the following procedure to create an Attribute Element prompt based on the Null Entity ID filter.

Create an Attribute Element Prompt Based on the Null Entity ID Filter

After you create a null filter, you create an Attribute Element prompt based on that filter.

To create an Attribute Element prompt from the MicroStrategy desktop:

  1. From the MicroStrategy Desktop, right click and select Prompt from the New menu.
    You see the Prompt Generation Wizard dialog box.

    Prompt Generation Wizard Dialog Box
  2. In the Filter definition prompt section, select Choose from an attribute element list and click Next.
    You see the Second Prompt Generation dialog box.

  3. In the Attribute field, select the attribute and click Next.
    You see the Third Prompt Generation dialog box.

  4. Select Use a filter to reduce the number. Click the button to select a filter. Select Null Entity ID from the list of available filters that is displayed.

  5. Click OK and then click Next.
    You see the Fourth Prompt Generation dialog box.

  6. Enter a title in the Title field. Enter any instructions in the Instructions field. The Instruction field text is displayed in MicroStrategy when you run the report.

  7. Click Next.
    You see the last Prompt Generation Wizard dialog box.

  8. Optionally, add default prompt names, and click Finish.
    You see the Save As dialog box.

  9. Enter a prompt name and click Save.