Skip to main content

Filter report and cube instances using metric limits

tip

You can try out this workflow at REST API Playground.

Learn more about MicroStrategy REST API Playground here.

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

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

Metric limits are applied only to metrics, and they are applied after data is aggregated. You can use metric limits with most types of cubes; one exception is MDX cubes with recursive attributes. You must use an Intelligence Server with a version greater than 10.11.

The following topics are designed to help you understand and use metric limits.