Strategy ONE

Importing the model into MicroStrategy

After you have created the predictive model, either by using a native MicroStrategy training function or a third-party data mining application, you are ready to import it into your MicroStrategy project using the procedure below.

In addition to importing predictive models directly into your MicroStrategy project, you can also import predictive models into the MDX cubes you have integrated into MicroStrategy, as described in Importing predictive models for MDX cubes.

Prerequisites

Before the Import Data Mining Model option is available:

  • You must have the following user privileges: Use Metric Editor (Developer) and Create Application Objects (Common Privileges)

  • You must be logged into a project.

  • You have created a dataset report, which is the first step in creating a predictive model. For information on this process, see Creating a dataset for data mining.

  • You have created and trained a predictive model from the dataset, using MicroStrategy or a third-party application.

To import the model

  1. In MicroStrategy Developer, from the Tools menu select Import Data Mining Model. The Import Data Mining Model dialog box opens.

  2. Click ... (the browse button) to locate the Data Mining Model to import. Once you select the file, the fields in the table at the bottom of the dialog box are automatically populated.

  3. In the Predictor Type column, select or clear the type of predictive metrics to be created. By default, all outputs defined by the model you chose above are selected. If outputs are not defined in the selected PMML model, then MicroStrategy offers the predicted value (or score) and probability (or confidence) outputs where applicable.

  4. In the Name column, change the default names provided for each predictive metric if you want.

  5. In the Aggregation Function column, specify the desired aggregation functions for the selected predictive metric types, if you want to change from the default functions.

  6. Click OK.

  7. Select an existing or create a new destination folder for the predictive metrics. All predictive metrics will be created in this folder.

  8. Click OK.

  9. The model is imported, which may take a few minutes depending on the size of the model and the number of predictive metrics selected.

    If a predictive metric already exists in the metadata with the same name, you are prompted whether to overwrite it. If you choose not to, you are returned to the Import Data Mining Model dialog box to rename the predictive metric.

Importing the model into MicroStrategy results in the creation of a predictive metric. This metric contains the imported PMML model, and an expression that invokes the appropriate MicroStrategy function to execute the model. The next step is to use the predictive metric in reports.

Related Topics