Strategy One

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.

A data mart is a data repository where you store the results of a report as a relational table in a data warehouse. After creating a data mart, you can use it as a source table in your projects, and execute reports against it. You can use data marts for the following applications:

  • Create aggregate fact tables to improve the performance of reports that have summarized data.

  • Create tables for use by other applications, such as Microsoft Access.

  • Create tables for off-line analysis using direct SQL queries.

Before you can create a data mart table, you need to create a data mart report, as described below.

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 Strategy 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 from the drop-down list in the toolbar.

  6. In the Table box in the toolbar, enter the table name to use. The View Data button (in the Datamart Definition tab) or Write to Table button (in the toolbar) are enabled once you type a table name.

  7. In the toolbar, select your Refresh Type. The options are:

    • Create (default)

    • Append

  8. If you select Append in Refresh Type, clickView Data to preview the information your datamart object will store.

  9. You can optionally write the information to the data source, by clicking Write to Table in the toolbar.

  10. Click Properties in the toolbar to set the datamart properties. You can define the evaluation order, the prompt order (if the dataset contains prompts), table generation settings such as maximum execution time and a table qualifier, and advanced properties such as joins and indexing.

  11. Click Save .

Convert a Report Into a Datamart Object

  1. Open the Workstation window.

  2. In the Navigation pane, click Reports.

  3. Open the report that to convert into a datamart object.

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

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

  6. Modify the object and click Save .