Process a Mining Structure

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


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.

Before you can browse or work with the mining models that are associated with a mining structure, you have to deploy the SQL Server Analysis Services project and process the mining structure and mining models. Also, if you make a change to the mining structure or mining models, you will be prompted to redeploy and process them. Processing the structure in the Mining Structure tab of Data Mining Designer in SQL Server Data Tools processes all the associated models.

You can process a mining structure by using these tools:

  • SQL Server Data Tools

  • SQL Server Management Studio

  • XMLA: Process command

For information about how to process individual models, see Process a Mining Model.

To process a mining structure and all associated mining models using SQL Server Data Tools

  1. Select Process Mining Structure and All Models from the Mining Model menu item in SQL Server Data Tools.

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

  2. Click Run in the Processing Mining Structure - <structure> dialog box.

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

  3. Click Close in the Process Progress dialog box after the models have completed processing.

  4. Click Close in the Processing Mining Structure - <structure> dialog box.

See Also

Mining Structure Tasks and How-tos