Dimension with attribut from multiple tables

[backhandx]

Hi all,

I want to optimize a query generated by cognos.
I will give an exemple:

Let suppose that I have 2 tables: Calendar (idTime_Calendar; ) and Time ( idTime_time ; Date)
the join betwen the two is done on the idtime.

I have two dimensions: Calendar and Time ( businessKey: idTime_time ;  membercaption : Date)
What i want to do is to change the businessKey of the Time dimension from idTime_time to idTime_Calendar. This will allow me to avoid the join between the Time and the Caldendar tables when drag/dropping a member from Time dimesnion
to the report.

Is this a proper way to build a dimension with attributs from two tables?

Thanks for your reply

[Invisi]

Are you actually thinking of making a date-time dimension?