Data Modeling Two Tables 1 to many

Hi everyone,

I'm struggling with the following issue:

I have two tables:

- dimension table with unique combination employeenumber-cost centre, employeenumber and cost centre

- fact table with unique employeenumber-cost centre, employee number, cost centre, weeknumber and number of classhours

The relationship between the two tables is one to many (unique combination employeenumber-cost centre is key)

One row from the fact table is shown below:

When I'm putting the employeenumber from the dim table together with classhours from the fact table it just shows up like this:

That's fine. 

When I want to add the costcentre, it's turning empty:

That's weird, because this employee has classhours in a certain cost centre..

It's neither showing up when I just add the unique combination of employeenumber/costcentre

Does anyone know why this is not showing up?

Thanks!