Skip to main content

Return the attribute-based view filter criteria applied prior to aggregation

A view filter specifies a set of attribute or metric-based filtering criteria. In dashboards, a view filter is applied to a visualization-level dataset before metrics are aggregated. Because view filters are applied at the visualization-level, they can dynamically restrict the data being displayed without re-executing the underlying dataset against the warehouse.

You create an attribute-based view filter by selecting the attributes that you want to use as filters in the Filter Editor. Attribute-based view filters are one of three kinds of filters that can be applied to visualizations before metrics are aggregated; the other two are metric-based view filters and template limits. There is one kind of filter that can be applied after metrics are aggregated—metric limits.

tip

Drilling is treated as a view filter. If you set drilling, you will get the drill content in the view filter summary.

You use the following REST API endpoint to return information about the view filters that were applied before metric aggregation.

  • GET /api/dossiers/{dossierId}/instances/{instanceId}/chapters/{chapterKey/visualizations/{visualizationKey}

An example of the JSON data that is returned for view filters is shown below. If you applied multiple view filters, all of the filter criteria is combined, using the logical operators that you specified when you created the filters.

{
  "key": "W110",
  "name": "Visualization 1",
  "result": {
    "definition": {
      // view filter definition
      "viewFilterSummary": "(Category = Books, Electronics) And (Profit > 11111)"
    }
  }
}

Attribute-based view filters can be applied in a number of ways. For example, they can be applied in Workstation as follows:

  1. Choose Edit Filter from the dropdown in the top right corner of the visualization panel.
  2. On the Advanced Filter Editor dialog, clickAdd New Qualification.
  3. On the New Qualification dialog:
    1. In Based On, choose one or more attribute.
    2. Click OK.
    3. Click Save.

Refer to the MicroStrategy product manuals for a detailed explanation of attribute-based view filters and how they can be applied.