I am unable to Create the Relationship between my Date table and Maintenenc Table.

[Manish_Patil]

I am having Table named as the Date which is having Column related the Date Hirarchy and another table is Maintenence table which is having Maintenence date in table as well as datekey in table. This both date are having Same data type in table but stil i am not able to create the realtionship between this two dates. I am creating the relation ate date column for one to many raltionship. suggest me a better way to handle this scenario

[VijayP · Accepted solution]

@Manish_Patil 

While creating such relationship you must make sure that Date(Dimension) Table not  having any duplicates. 

since that table has got duplicates it is causing many to many relationship. 

[VijayP]

@Manish_Patil 

If you find solution , please mark Accept as Solution and share your kudos

[VijayP · Accepted solution]

@Manish_Patil 

While creating such relationship you must make sure that Date(Dimension) Table not  having any duplicates. 

since that table has got duplicates it is causing many to many relationship. 

[Manish_Patil · Accepted solution]

Thanks For Solution I had made some changes and implmented again and it worked.