Multiple fields in fact table referring to one dimension

[#1]

Dear Qlik-Community,

I have the following situation and don't know how to handle this issue. I hope you know how to solve solve this problem.

I have a fact table with two different fields, which represent employees, and want to connect them to one dimension.

Here an example:

Fact-Table:

Article, ResponsiblePersonPurchasing, ResponsiblePersonSales

1, 20, 30,

2, 10, 30

3, 10, 20

etc.

DiM_Employees:

10, Mr. Maier

20, Mrs. Mueller

30, Mr. Max

Now i want to link the fields ResponsiblePersonPurchasing and ResponsiblePesonSales with DIM_Employee without using two dimensional tables.

Any ideas?

[#2]

Thanks for your reply, this might be a solution, but as you said it is not a elegant solution.

With that approach you need to add different roles in your data model - it is not possible to list different responsible employees in one record (e.g. article, project, etc.).

It seems, that that issue is quite complicated.