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.