Starting in MicroStrategy 2021 Update 7, you can use REST API requests retrieve, create, and update datamart objects through the Modeling service.
- Retrieve a datamart definition
- Create a datamart from a source report
- Create a datamart from scratch
- Update a datamart definition
- Execute a datamart
This section outlines the important fields in the API response body defined for an Incremental Refresh Report.
Stores the basic information for the datamart including,
For datamart, the
Stores the report type for the source report that datamart is created on top of. The report type is
Specifies the design of datamart, including the units on
table (only if
Contains all the configuration settings of datamart, including:
append: Indicates whether to create a new table or append to the existing table every time a report runs
targetSource: The db instance where the table is placed.
tableName: The name of the table.
placeholderIncluded: The supported placeholders in the table name. You can see more information here.
datamartProperties: The properties that are used to configure the table in warehouse. For example, datamart advanced settings and SQL statement related configurations.
Stores the information for the timezone applied to the source report.
Stores the information of all available advanced properties for the datamart.
Out of scope for 11.3.7
Users can’t create a datamart on top of a Query builder report or get/update a datamart based on query build/mdx type. These report types are not yet supported by the Modeling service.
The normal report of MDX type is not supported to create datamart. This normal report type is not yet supported by the Modeling service.
For more information about the Modeling service, see Configuring the Modeling Service.