How to resolve Redundancy and Loop issue exists in FM?

[yogeswari]

Hi,

I am getting the below error when i try to publish the package:

"BMT-MD-2010 This package will publish 'Query Subject' '[Application Layer].[FRow]', which has the following warnings.
BMT-MD-2017 This 'Query Subject' and 'Query Subject' '[Application Layer].[FData]' have the following multiple relationships, or relationship shortcuts, defined between them: 'Relationship' '[Application Layer].[FData and FRow]' and 'Relationship' '[Application Layer].[FData and FRow(RownNo)]'. Based on the relationship cardinalities, this is both a redundancy and a loop."


I have 2 tables: FData and FRow.  These 2 tables are joined by 2 columns. (Cd and RowNo).  So 2 relationships are created between these 2 tables.  Also i believe FData is Fact table and FRow is Dimensions table.

Please suggest to resolve the above issue and i consider ur help as very great.

Thanks.

[MFGF]

...These 2 tables are joined by 2 columns. (Cd and RowNo).  So 2 relationships are created between these 2 tables...

Nope. That's your mistake right there. You need to have *one* relationship between the two query subjects, and have this one relationship based on two items. In the relationship dialog there is a "New Link" button at the top that allows you to add extra items within the same relationship.

Delete one of the two relationships, then modify the other to be based on both items.

Cheers!

MF.

[charlie]

Yogeswari,
It looks like you have created 2 joins between these 2 tables. Remove one of the joins and modify the other to use both columns in the same join.

Usually, alias shortcuts are helpful in resolving "loops".

[charlie]

You beat me to it MF  :)

[MFGF]

You beat me to it MF  :)

Lol. Makes a change for me to be ahead of the game :)

[yogeswari]

Hi,

Great Thanks for your inputs and it is working fine now. 
Thanks again dude. :):) :) :) :)