Print Page - Dimension with attribut from multiple tables

Title: Dimension with attribut from multiple tables
Post by: backhandx on 03 Mar 2017 10:47:02 AM

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

Title: Re: Dimension with attribut from multiple tables
Post by: Invisi on 13 Mar 2017 08:35:43 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: backhandx on 03 Mar 2017 10:47:02 AM