Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Icon for Helper IV rankHelper IV
10 years ago

one to one relationship in SSAS Tabular Model

Hi,

Can anyone tell me ho to implement 1:1 relationship in Tabular model. When i create relationship using diagramtic view in Tabular model, it creates only 1:m or m:1 relationship.

 

Thank you

 

3 Replies

    • vickyprudhvi's avatar
      vickyprudhvi
      Icon for Helper IV rankHelper IV

      we are using 2012 version. is there a round about way.

      • MattAllington's avatar
        MattAllington
        Icon for Community Champion rankCommunity Champion

        The relationship must be 1 to many, but the many side of the relationship can still be unique (aka 1:1). What are you trying to achieve with this specific relationship?