Process a mining model

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, process a specific mining model associated with a mining structure or all models associated with the structure.

Use one of the following tools to process a mining model:

  • SQL Server Data Tools

  • SQL Server Management Studio

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

Process a single mining model by using SQL Server Data Tools

  1. On the Mining Models tab of Data Mining Designer, select a mining model in the grid.

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

    If you change the mining structure, redeploy it before processing the model. When prompted, select Yes.

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

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

  4. After processing finishes successfully, select Close in the Process Progress dialog box.

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

This operation processes only the mining structure and the selected mining model.

Process all mining models that are associated with a mining structure

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

  2. If you change the mining structure, redeploy it before processing the models. When prompted, select Yes.

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

  4. Review the model processing details in the Process Progress dialog box.

  5. After processing finishes successfully, select Close in the Process Progress dialog box.

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

This operation processes the mining structure and all associated mining models.

See Also

Mining Model Tasks and How-tos