Add a Nested Table to a Mining Structure

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

Use Data Mining Designer to add a nested table to a mining structure after it has been created by the Data Mining Wizard.

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.

To add a nested table to a mining structure

  1. Select the Mining Structure tab in Data Mining Designer.

  2. Right-click the mining structure to which you want to add a table column.

  3. Select Add a Nested Table.

    The Select a Nested Table Key Column dialog box opens.

  4. Under Nested table, select the table that you want to nest in the mining structure.

  5. Under Source column, select the key column for the nested table.

  6. Click OK.

    A new table column that contains the key column is added to the mining structure. For information about how to add additional columns, see Add Columns to a Mining Structure.

See Also

Mining Structure Tasks and How-tos