How do I add new attributes to a dimension, from a related table

Question

Hi All,

I have created a dimension "Employee" with EmployeeKey, EmployeeId,EmployeeName,EmployeeStatus as Attributes. Recently I have a requirement to add the dependents. The Dependent table and the Employee have a relationship set in the DSV, but now I want to add the attributes from the Dependent table to the "EmployeeDimnsion" and I do not see an option to add them. Can someone please point me in the right direction?

Note: The DependentKey does not exist in the FACT table, the FACT table has only the EmployeeId as FK

Thanks

Answer 1

To add attributes from the Dependent table to the "EmployeeDimension", you need to follow these steps:

1. In the dimension designer, right-click on the "Employee" dimension and select "New Attribute".
2. In the "Attribute Relationship" dialog box, select "Related Dimension" and click "Next".
3. Select the "Dependent" dimension from the dropdown list and click "Next".
4. Select the attribute(s) you want to add from the "Dependent" dimension and click "Next".
5. 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.