Create Datamart Objects

Starting in MicroStrategy 2021 Update 9 May monthly release, this feature is shipped out-of-the-box.

MicroStrategy 2021 Update 9 introduces a preview feature that allows you to create datamart objects.

• Create a Datamart Object

• Convert a Report Into a Datamart Object

Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features in MicroStrategy Workstation, you can access these features and use them as you would any other functionality. The official versions of preview features are included in subsequent releases.

Create a Datamart Object

1. Open the Workstation window.

2. Choose File > New Datamart.

3. Select an environment and project.

4. In the left panel, choose the objects to add to your datamart object.

   

5. Select the Data Source and enter the Table Name you want to use.

6. Select your Refresh Type. The View Data or Write to Table buttons are enabled once you type a table name.

   

7. If you select Append in Refresh Type, click View Data to preview the information your datamart object will store.

   

8. Optionally, click Write to Table to write the information to the data source.

9. Click Properties to set datamart properties.

   

10. Click Save .

Convert a Report Into a Datamart Object

1. Open a report that you want to convert into a datamart object.

2. In the upper-right corner of the Report Editor, click Create Datamart to convert your report into a datamart object.

3. A new Object Editor appears for the datamart with all attributes and metrics transferred from the original report.

4. Modify the object and click Save .