MicroStrategy ONE

Creating custom expression qualifications for custom groups

In a custom group, a custom expression qualification allows you to create customized filter expressions. You can use Apply functions and you can create relationship filters.

Prerequisite

By default, the Add an Advanced qualification option is disabled in the Custom Group Editor. You must activate the advanced qualification option to create a custom expression qualification.

To create a custom expression qualification for a custom group

  1. Open the Custom Group Editor. (How?)

  2. Double-click in the Custom Group Definition pane. A new custom group element is created, with the default name Custom Group Element. You can rename the custom group element headers.

  3. Double-click Add Qualification in the Custom Group Definition pane. The Custom Group Options dialog box opens.

  4. Select Add an Advancedqualification and click OK. The Advanced Qualification pane opens.

  5. Select Custom expression from the Option drop-down list.

  6. Add a custom expression in the Custom expression box by one of the following methods:

    • Drag objects from the Object Browser into the Custom expression box. Select the operator buttons to place in your expression.

    • Manually type the custom expression in the Custom expression box.

  7. Click Validate to validate the expression.

  8. Click OK to close the Advanced Qualification pane.

  9. Do one of the following:

    • Add more qualifications to the custom group element. Double-click in the Custom Group Definition pane to open the Custom Group Options pane again. These can be any type of qualification except banding qualifications.

      If you have multiple qualifications, you can change the operator connecting them. To do this, right-click the operator in the Filter definition area, point to Toggle operator, then select the new operator from the list.

    • Change the name of the custom group element header (recommended), if you did not do this in step 2. How?

    • Return to Creating custom groups to format the custom group element, set the display options, and/or add more custom group elements.

    • Save the custom group. (How?)