Role Playing dimensions

Whats the best way to create role playing aliases for date dimension in db2? Aliases in db2 doesn't allow renaming of columns to a different name compared to the base table. Views can be used to create aliases, but is there a better way to do this?

Just change the name in the fact table. I prefix the normal PK column name with the role. For example, a date dimension has a PK named 'date_key'. If I have an order fact table with a few dates, I would name the columns 'order_date_key', 'requested_ship_date_key', etc...

The database doesn't care. Most modeling tools allow you to specify the role name in the relationship. Any decent BI or reporting tool will add aliases to the SQL as necessary. If you must, you can always define a synonym for each unique role, but that is only necessary if users are coding SQL.

you need not worry about it , any BI tool will do that for you.
But sugested by ngalemmo just make sure you have different different FK's in fact for all the roles