Creating two joins between fact and dimension tables

Create Alias table for your dimension table in Physical Layer.

Fact.Key1 >--------------Table.Key1 (Orginal Table)
Fact.Key2 >------------- AliasTable.Key1 (Alias Table)

You can't create multple joins for Fact and a Dimension table.

Until Next Post... :)