Esri Maps for MicroStrategy (v2.0.2 Archive)

In this topic
  1. Modify or create a filter
  2. Considerations for filters
  3. Trigger interactions

This is an archive related to a previous version of Esri Maps for MicroStrategy. If you need the current version go to http://doc.arcgis.com/en/maps-for-microstrategy/.

Apply a filter

In Esri Maps for MicroStrategy, you can apply filters to layers in the map to present a focused view of your data. By limiting the visibility of features in a layer, patterns can more easily be revealed. For example, a filter might be applied to a layer showing retailer locations so that only the retailers with a yearly revenue of at least $15,000 are displayed on the map.

You can also use the Filter tool to trigger interactions configured by the designer. Press Trigger interactions after applying your filter; the filtered features are selected, and configured selectors and links that are enabled for automatic interactions are triggered by the selection.

Modify or create a filter

You can apply a filter to feature service layers or dynamic map service layers from ArcGIS.

  1. Press the Show map contents button to display the Contents pane.
  2. On the Contents pane, press the arrow to the right of the layer for which you want to modify or create a filter.
  3. Choose Filter layer.
  4. Modify or create a new filter expression.
    • You can create one expression, multiple expressions (press Add another expression), or one or more sets of expressions (press Add a set). A set is a grouping of expressions, for example, Retailer_type = department_store and Revenue <= 10,000.
    • If you have more than one expression, use AND or OR to display features in the layer that match all or any of your expressions. AND requires that all of the criteria you have specified must be true. OR means that any of your expressions must be true for the features to display.
    • For the field part of the expression, choose the field you want to query against from the Field drop-down menu.
    • For the operator part of the expression, choose an operator from the Operators drop-down menu.
    • If you want to filter based on a specific value, choose Value and enter a value in the field. The input box varies depending on the field type.
    • If you want to compare the value in one field to the value in another field, choose the field for your expression from the Field drop-down menu.
    • If you want to filter based on a specific value in the field you've chosen for your expression, choose Unique and choose a unique value from your field. Unique value filters require an ArcGIS 10.1 or later map service. The Unique option does not appear if you are creating a filter on an ArcGIS 10.0 or earlier service.
    • To delete an expression or set in the filter, press the Delete (X) button to the right of your expression or set.
    • To add an expression to a set, press the Add an expression to this set (+) button to the right of the set.
  5. When you are finished modifying or creating your filter expression, press Apply to apply the filter to the layer.

    The map updates to display the new filtered view.

  6. Press the Close button to close the Filter tool.

Considerations for filters

  • Do not add special characters to your values unless those special characters are part of the value. For example, City = "New York" doesn't find a feature named New York. In this example, use City = New York instead.
  • If your field includes coded values, the Values list shows all coded values defined by the service for the field. This may include values that do not exist as features in the layer. The Unique list shows all the features in the layer (which may be a subset of the values in the service).
  • The Unique option requires an ArcGIS 10.1 or later map service. The option does not appear if you are filtering an ArcGIS 10.0 or earlier map service.
  • If you have multiple expressions, your results vary depending on how and whether you group them in sets. For example, if you create a filter where all of the following expressions must be true: Investment_class = Balanced Fund OR Investment_class = Mortgage Fund (this is a set) AND Client_sales is >= 30,000 (this is a single expression), the filter selects Balanced Fund investment branches and Mortgage Fund investment branches with client sales greater than or equal to $30,000.

    If you instead create your filter where the following must be true: Investment_class = Balanced Fund AND Client_sales >= 30,000 (now this is your set) OR Investment_class = Mortgage Fund (this is a single expression), your filter selects Balanced Fund investment branches with client sales greater than or equal to $30,000 and all Mortgage Fund investment branches.

Trigger interactions

After applying a filter, you can easily select the filtered features and trigger any configured interactions.

  1. Apply the filter you want to the layer.
  2. Press Trigger interactions.

    Features intersected by the filtered features are selected.

    Based on the selection, configured selectors or links that are enabled for automatic interactions are triggered.