Relationships Not Working - Multiple Tables

[Nangys]

Hi All,

I have created this model:

The objective is to link Table 1,2 and 3 tables to table 4.

Vendor_Key table contains the unique Vendor Numbers of table 1,2 and 3. The only table that has unique values is the Vendor_Key table.

However, I can't get the relationships to work:

PowerPivot can't identify the relationship either.

Nonetheless, the relationships between Vendor_Key and Table_4 works correctly, but it doesn't when I add a field from another table.

Please advise.

Thanks

Regards,

Fernando

 

[NARAYANK991]

Hi Fernando ,

Can you see if these two links help ?

http://www.powerpivotpro.com/2013/0...i-already-have-a-relationship-whats-going-on/

http://www.powerpivotpro.com/2013/0...-relationship-or-why-boaring-movies-are-best/

Narayan

 

[Nangys]

Hi Fernando ,

Can you see if these two links help ?

http://www.powerpivotpro.com/2013/0...i-already-have-a-relationship-whats-going-on/

http://www.powerpivotpro.com/2013/0...-relationship-or-why-boaring-movies-are-best/

Narayan

Hi Narayan,

I had seemed those, and additionally this one too:

http://www.powerpivotpro.com/2012/11/a-mystifying-and-awesome-solution-for-many-2-many/

However, I haven't been able to figure it out.

Regards,

Fernando

 

[NARAYANK991]

Hi Fernando ,

In which case , can you upload your workbook ? Are you using Excel 2010 or 2013 ?

I don't have Excel 2013.

Narayan

 

[Nangys]

2010... workbook attached. thanks

 

[Somendra Misra]

Hi,

See your file.

Regards,

 

[Nangys]

Hi,

See your file.

Regards,

Hi Somendra,

Thanks for the reply. However, it doesn't fix the issue:

Regards,

Fernando

 

[Somendra Misra]

@Nangys

Why not create a data table for all the vendors with all the details and than link that table to Main table?

Is there a problem in that, as I can see there are duplicate vendor # in C1, C2 & C3.

Regards,

 

[Nangys]

@Nangys

Why not create a data table for all the vendors with all the details and than link that table to Main table?

Is there a problem in that, as I can see there are duplicate vendor # in C1, C2 & C3.

Regards,

Hi Somendra,

The issue is that each company/vendor may have multiple addresses, divisions or telephone numbers.

I created the Vendor_Key table with only the unique vendors ID's in order to link those table to the main table.

BTW, I see my Main_Table as a Fact table, the Vendor_Key table as a dimensional table... however, I'm not sure how to classify the other 3 tables.

Regards,

Fernando