To add attributes from the Dependent table to the "EmployeeDimension", you need to follow these steps:
- In the dimension designer, right-click on the "Employee" dimension and select "New Attribute".
- In the "Attribute Relationship" dialog box, select "Related Dimension" and click "Next".
- Select the "Dependent" dimension from the dropdown list and click "Next".
- Select the attribute(s) you want to add from the "Dependent" dimension and click "Next".
- Choose a name for the new attribute(s) and click "Finish".
After following these steps, the new attribute(s) from the "Dependent" table will be added to the "Employee" dimension. You may need to adjust the relationship between the two dimensions if necessary.