Version 2021

Filter Report and Cube Instances Using View Filters

When you create a MicroStrategy report or cube instance using the following REST API endpoints, you can use a parameter called viewFilter in the body parameter of the request to filter the data that is returned:

  • POST /cubes/{cubeId}/instances
  • POST /reports/{reportId}/instances

Because the filter is applied to a report or cube instance, it is not persisted.

View filters can have both metric and attribute qualifications. They are applied before data is aggregated.

The following topics are designed to help you understand and use view filters.