Generate Scripts to Create a Parent-Child Relationship Table

From the logical table's Hierarchy tab you can generate SQL scripts to generate and load the parent-child relationship tables into your data source.

After you run the scripts and generate the parent-child relationship table, you add them to the semantic model's physical layer to make them available to use in the parent-child hierarchy.
See About Parent-Child Relationship Tables and Add the Parent-Child Relationship Table to the Semantic Model.
  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Logical Layer Logical layer icon and locate and double-click the logical table with the parent child hierarchy that you want to generate a relationship table for.
  4. In the Logical Table's tabs, click Hierarchy, click the Generate Relationship Table.
  5. In the Generate Relationship Table Scripts dialog, confirm the column name in the Member Column field and in the Parent Column field choose a column. Confirm the other fields in the dialog.
  6. Click Download Script.
  7. Run the downloaded scripts to create the parent-child relationship tables.