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

Lisa Kruger 60 Reputation points
2023-03-08T13:13:23.07+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,583 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,241 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Muhammad Ahsan Khan 245 Reputation points
    2023-03-27T10:35:40.9133333+00:00

    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.

    0 comments No comments