MicroStrategy ONE

Data mart editors

Data marting tasks in the context of MicroStrategy entail the use of the Report Editor, the Metric Editor, and the Report Data Mart Setup dialog box, each for a specific purpose. The following list shows the data mart-related functions of these tools.

  • Report Editor: creates or modifies a data mart report.

  • Metric Editor: maps column names in a data mart report to corresponding aliases in a data mart table.

  • Report Data Mart Setup dialog box: specifies properties and performance-related conditions.

Before you use the data marting tools, you should familiarize yourself with:

  • The concepts and purposes of data marting in the context of MicroStrategy

  • The existing schema in the project for which you want to create the data mart table

  • The contents and properties required for a data mart table to meet your purposes

  • How to use the Report Editor to create and modify reports

  • How to use the Metric Editor to create and modify metrics

  • Whether an existing report may be used to meet your data marting needs

Data mart editors layout

For details on the layout of the data mart tools, click the appropriate link:

Accessing the data mart editors

You can access the data mart capabilities of the Metric Editor by selecting Tools, then Advanced Settings, and then Metric Column Options.

You can access the data mart capabilities of the Report Editor/Report Viewer by selecting Data, then Configure Data Mart from the menu bar.

If a report contains any of the following, it cannot be configured as a data mart report:

  • View filter

  • Report Objects that are not included in the template

  • Derived metrics

You can access the Report Data Mart Setup dialog box by opening an existing data mart report and selecting Data, then Configure Data Mart from the menu bar.

Related Topics