MicroStrategy ONE

Steps to create qualifications in Query Builder

  1. Open the Query Builder Editor. (How?)

  2. Click in the Conditions pane (the middle pane on the right) to start a new qualification.

    • To remove all existing qualifications, click Clear first.

    • To add another qualification to existing qualifications, click New first.

  3. Click Field to open a drop-down list of Query Builder columns and features. Select one of the following options:

    • Type Expression: This option allows you to type in your own column expression to use in the qualification.

    • Browse columns by tables: A list of the tables used in your Query Builder definition is displayed. You can include a column from one of the tables by pointing to the table, and then selecting the column. The column is included in the qualification.

    • Browse column selections: A list of columns included in the Selections pane is displayed. Any column expressions that are aggregated are displayed with their column alias. You can include a column in your qualification by selecting it from this list.

    • Simple aggregation: A list of simple aggregation functions is displayed. You can point to a simple aggregation function, and then select a column selection or a table column to perform the simple aggregation on. A simple aggregation of the column selected is included in the qualification. For more information on simple aggregations, see Simple aggregation on Query Builder columns.

  4. Click Operator and select the operator (In list, Exactly, Greater than, Is null, and so on).

  5. Click Value and select one of the following options:

    • Type a value: This option allows you to type a value or list of values in.

    • Type expression: This option allows you to type in your own expression to use in the qualification.

    • Select Prompt: You can select an existing prompt to include in the qualification. The operator of the qualification determines what type of prompt you can use in the qualification.

    • Element list prompt: Element list prompts can be used with columns that are mapped to project attributes. Selecting the operators In List or Not in List allows you to select an element list prompt for the value of the qualification.

    • Value prompt: Value prompts can be used with any columns that are mapped to any attribute or metric, regardless of whether the attribute or metric is a project object or managed object. All the available operators except for In List and Not in List allow you to select a value prompt for the value of the qualification.

    • Prompt Elements: This option opens the Prompt Generation Wizard, which helps you create a new element list prompt. This option is available if the operator for the qualification is In List or Not in List.

    • Prompt a Value: This option opens the Prompt Generation Wizard, which helps you create a new value prompt. This option is available for all the available operators except for In List and Not in List.

    • Depending on the operator selected for the qualification, you can select from the other following options:

    • Browse columns by tables: A list of the tables used in your Query Builder definition is displayed. You can include a column from one of the tables by pointing to the table, and then selecting the column. The column is included in the qualification.

    • Browse column selections: A list of columns included in the Selections pane is displayed. Any column expressions that are aggregated are displayed with their column alias. You can include a column in your qualification by selecting it from this list.

    • Simple aggregation: A list of simple aggregation functions is displayed. You can point to a simple aggregation function, and then select a column selection or a table column to perform the simple aggregation on. A simple aggregation of the column selected is included in the qualification. For more information on simple aggregations, see Simple aggregation on Query Builder columns.

Related Topics