COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: caa on 26 Jan 2012 06:34:50 AM

Title: Join between two facts in the framework
Post by: caa on 26 Jan 2012 06:34:50 AM
hello

I have two facts that have a connecting field between them
(1-1  join  1-n)

is it possible to connect them with a join in the frame work?
Title: Re: Join between two facts in the framework
Post by: blom0344 on 26 Jan 2012 08:28:04 AM
Yes, but you will only get proper results from the 1:1 side even you can and do define a unique determinant for the subject. Otherwise measures from the 1:1 side will be inflated