COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: karthik12345 on 13 Apr 2016 06:40:00 AM

Title: multiple joins between two tables
Post by: karthik12345 on 13 Apr 2016 06:40:00 AM
Hi all,
   
    I gave the multiple joins between two tables.
  Entries and messages tables
     Entry-id <-> message id-1
     Entry-id <-> message id-2
    Entry-id <-> message id-3
    Entry-id <-> message id-4
     I created 3 shortcuts of messages table and taken message id-1 from messages table, message id-2 from shortcut -1, message id-3      from shortcut-2 and message id-4 from shortcut-3
    Which I followed is correct way or is there any other way to do this.

Thanks,
Karthee
Title: Re: multiple joins between two tables
Post by: HalfBloodPrince on 13 Apr 2016 07:14:02 AM
I guess you have to create alias shortcut.