COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: dssd on 07 Apr 2013 11:18:27 AM

Title: n to n
Post by: dssd on 07 Apr 2013 11:18:27 AM
I have a scenario at the data level there is a n..n relation between fact and dimension...How would it hurt the results if i have the cardinality as 1..n in the Fm even though at the data level it remains n..n
Title: Re: n to n
Post by: cognostechie on 07 Apr 2013 04:35:22 PM
The purpose of defining the cardinality in FM is to tell FM which table should be treated as a Dimension and which one as a Fact. The table on the 1 side will be treated as a Dimension and the one on N side will be treated as a Fact. It does not have anything to do with the number of rows of one table to be joined to number of rows of another table.

That being said, if you have more than one row in the Dimension that will be joined to the same row of the Fact then you have a serious problem to deal with on the data side. The aggregation would be unpredictable.
Title: Re: n to n
Post by: dssd on 07 Apr 2013 07:45:07 PM
What if there is no aggregation and its purely dimensional. two dimensions getting joined which have n..n in the data
Title: Re: n to n
Post by: blom0344 on 08 Apr 2013 01:09:58 AM
If you do not use any measures from a fact, then Cognos will automatically fetch distinct values from the query. However, you would not normally fetch data from directly related dimensions. So, to answer your question from a different perspective: all combinations generated by the join strategy will be fetched, but duplicates will be removed from the resultset..
Title: Re: n to n
Post by: CAM-AAA on 09 Apr 2013 12:26:52 PM
Fact to Fact relationships can be resolved by implementing a junction table query subject between the two tables.