MicroStrategy ONE

Training Metric Wizard

The Training Metric Wizard tool guides you through the creation of a training metric. Utilizing the Automatic Creation of Predictive Metrics feature, training metrics created with the Training Metric Wizard can be set up to automatically generate predictive metrics when run in a report. A user must have metric creation privileges in order to access the Training Metric Wizard tool.

Training metrics can be created and saved in the following ways:

  • Standalone training metrics: Standalone training metrics exist in metadata and are the standard type of training metric that can be used on any report. You can use metrics and attributes within the project as inputs to create standalone training metrics.

  • Derived training metrics: Derived training metrics are training metrics that are created using the derived metrics feature. You must have the MicroStrategy OLAP Services product to create derived metrics. Derived training metrics also have the same requirements and restrictions as derived metrics, which are discussed in Best practices for creating derived metrics.

    In addition to using metrics and attributes within the project as inputs, derived training metrics can also use any attributes and metrics on a report as inputs.

    Derived training metrics can be used to create derived predictive metrics, which are predictive metrics that exist only in the context of a report. This capability is particularly useful during the exploratory phase of the data mining process, during which many different variables are tried in a variety of modeling configurations. It is a common practice to test many variables and create a large variety of models. The knowledge gained from each test is included in the next one. Since derived metrics can operate against Intelligent Cubes, these tests can be done more quickly since the data for analysis is already available and in-memory. When a model worthy of deployment is found, it can be saved as a standalone predictive metric and used in the traditional fashion.

  • MDX cube training metrics: If you integrate MDX cube sources into MicroStrategy as MDX cubes, you can create training metrics based off of the MDX cube data. You can use metrics and attributes within the MDX cube as inputs to create MDX cube training metrics.

Accessing the Training Metric Wizard tool to create a training metric

Prerequisites

You must have the Use metric editor and Create application objects privileges before the Training Metric Wizard option is available.

  1. In MicroStrategy Developer, log in to a MicroStrategy project.

  2. From the Tools menu, select Training Metric Wizard. The Training Metric Wizard opens.

Accessing the Training Metric Wizard tool to create a derived training metric

Prerequisites

  • You must have the Use metric editor and Create application objects privileges before the Training Metric Wizard option is available.

  • You must have the MicroStrategy OLAP Services product to create derived metrics.

  1. In MicroStrategy Developer, log in to a MicroStrategy project.

  2. Navigate to a report, right-click the report, and select Run. The Report Editor opens.

  3. From the Insert menu, select New Training Metric. The Training Metric Wizard opens.

Accessing the Training Metric Wizard tool to create a derived training metric within a document

Prerequisites

  • You must have the Use metric editor and Create application objects privileges before the Training Metric Wizard option is available.

  • You must have the MicroStrategy OLAP Services product to create derived metrics.

  • You must add a dataset report as a Grid/Graph on the document.

  1. In MicroStrategy Developer, log in to a MicroStrategy project.

  2. Navigate to a document, right-click the document, and select Edit. The Document Editor opens.

  3. Right-click a Grid/Graph on the document and select Edit Grid.

  4. From the Insert menu, select New Training Metric. The Training Metric Wizard opens.

Accessing the Training Metric Wizard tool to create an MDX cube training metric

Prerequisites

  • You must have the Use metric editor and Create application objects privileges before the Training Metric Wizard option is available.

  • You must have imported an MDX cube into your MicroStrategy project.

  1. In MicroStrategy Developer, log in to a MicroStrategy project that is connected to an MDX cube source.

  2. If you are using read only mode for the project, from the Schema menu, clear the Read Only Mode option to switch to edit mode.

    Only one user can be editing a project at a given time. Therefore, if someone else is modifying the project, you cannot use the MDX Cube Catalog.

  3. From the Schema menu, select MDX Cube Catalog.

    • If you have a single MDX cube source database instance created for the project, the MDX Cube Catalog opens.

    • If you have multiple MDX cube source database instances created for the project, a Database Instance dialog box opens. Select a valid MDX cube source database instance, click OK, and the MDX Cube Catalog opens.

  4. Click the Cube Mapping tab.

  5. From the Catalog\Cube drop-down list, select the MDX cube to create training metrics for.

  6. From the Edit menu, select Training Metric Wizard. The Training Metric Wizard opens.

The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: