• You mean this?:

    And then join DimID with the dimension ID? I already considered doing this, but it's not possible. In the real fact table there are more foreign keys, the most typical being Date. As you can see Account 2 and Account 3 values are duplicated, so when filtering by date in the cube I get wrong values.