COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: naveen.odi@gmail.com on 18 Mar 2015 08:40:17 PM

Title: Relationships
Post by: naveen.odi@gmail.com on 18 Mar 2015 08:40:17 PM
Hi All, what is the relationship between dimension to dimension & Dimension to facts??
Title: Re: Relationships
Post by: MFGF on 20 Mar 2015 05:46:13 AM
Quote from: naveen.odi@gmail.com on 18 Mar 2015 08:40:17 PM
Hi All, what is the relationship between dimension to dimension & Dimension to facts??

Hi,

Can you explain what you're looking for here? You're asking a very vague question, and we need to understand more about your situation to know what sort of answer you're looking for.

MF.
Title: Re: Relationships
Post by: naveen.odi@gmail.com on 22 Mar 2015 12:26:20 AM
Hi, I need the relationship in schemas like 1-1, 1-m, m-m .....

Can you explain the relationships in star & Snowflake schemas

dimension to dimension
dimension to fact
fact to dimension

i hope you will understand....
Title: Re: Relationships
Post by: nishant.thakar on 23 Mar 2015 01:30:31 AM
Hi Naveen,
I think you are hunting out for information on cardinality.
I hope below link would help you to understand the scenario;

http://www.learn.geekinterview.com/data-warehouse/data-structure/what-is-data-cardinality.html (http://www.learn.geekinterview.com/data-warehouse/data-structure/what-is-data-cardinality.html)

Regards.