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
Select the Mining Structure tab in Data Mining Designer.
Right-click the mining structure to which you want to add a table column.
Select Add a Nested Table.
The Select a Nested Table Key Column dialog box opens.
Under Nested table, select the table that you want to nest in the mining structure.
Under Source column, select the key column for the nested table.
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.