Edit

Process a Mining Model

  • Article

Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Fabric/Power BI Premium

Important

Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.

In the Mining Models tab of Data Mining Designer in SQL Server Data Tools, you can either process a specific mining model that is associated with a mining structure or you can process all the models that are associated with the structure.

You can process a mining model by using the following tools:

  • SQL Server Data Tools

  • SQL Server Management Studio

You can also use an XMLA Process command. For more information, see Tools and Approaches for Processing (Analysis Services).

Process a single mining model using SQL Server Data Tools

  1. On the Mining Models tab of Data Mining Designer, select a mining model from the one or more columns of models in the grid.

  2. On the Mining Model menu, select Process Model.

    If you made changes to the mining structure, you will be prompted to redeploy the structure before processing the model. Click Yes.

  3. In the Processing Mining Model - <model> dialog box, click Run.

    The Process Progress dialog box opens to show the details of model processing.

  4. After the model has successfully completed processing, click Close in the Process Progress dialog box.

  5. Click Close in the Processing Mining Model - <model> dialog box.

Only the mining structure and the selected mining model have been processed.

Process all mining models that are associated with a mining structure

  1. On the Mining Models tab of Data Mining Designer, select Process Mining Structure and All Models from the Mining Model menu.

  2. If you made changes to the mining structure, you will be prompted to redeploy the structure before processing the models. Click Yes.

  3. In the Processing Mining Structure - <structure> dialog box, click Run.

  4. The Process Progress dialog box opens to show the details of model processing.

  5. After the models have successfully completed processing, click Close in the Process Progress dialog box.

  6. Click Close in the Processing <model> dialog box.

The mining structure and all the associated mining models have been processed.

See Also

Mining Model Tasks and How-tos