COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: barrysaab on 31 Jan 2013 11:23:03 PM

Title: How to retrive all records in Table C
Post by: barrysaab on 31 Jan 2013 11:23:03 PM
I have table A,B,C in my Framework model and i am pulling Max date from table A by writing filter max(retrieve date) ,this would pull this to table B the latest date but i want all dates in table C. I have relationship   1:1 to 1:n relationships.How to achieve this requirement.Please Help.Thanks
Title: Re: How to retrive all records in Table C
Post by: MFGF on 01 Feb 2013 02:55:52 AM
What relationships exist between the three tables? What item or items are the relationships based on? I'm afraid you haven't provided enough information to allow anyone to help. Can you be a little more specific?

Regards,

MF.