Skip to main content

Filter report and cube instances

tip

You can try these workflows with REST API Playground.

Learn more about MicroStrategy REST API Playground here.

You can filter data that is returned by the following REST API requests when you create an instance of a report or cube:

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

    Reports must have attributes on rows and metrics on columns. Otherwise, filtering is not applied.

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

    You can filter all types of cubes — normal cubes, DDA cubes, and MDX cubes.

You define how the results will be filtered in the body parameter of the request.

  • Using view filters

    With view filters, you can apply both attribute and metric filtering criteria. View filters are applied before data aggregation.

  • Using metric limits

    With metric limits, you can apply only metric filtering criteria. Metric limits are applied after data aggregation.

  • Using requestedObjects

    With requestedObjects, you specify exactly which attributes and metrics you want to include in the report or cube instance.