SSAS Tabular Model - Multiple Relationship between the Objects

Santosh Kumar 61 Reputation points
2021-10-07T07:52:42.783+00:00

Hi Friends,

In SSAS Tabular Model, i have 2 objects. We need to setup a relationship between these objects 2 times based on the surrogate key in order to get the Date related fields from the Date Dimension Table.

  1. Account Fact Table
  2. Date Dimension Table

138462-image.png

Relationships:
Datekey - StartDateKey
Datekey - EndDatekey

But I was getting below error while trying to create a 2nd relationship.
138408-image.png

Can you please help me on this issue.

Thanks in advance.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-10-08T03:23:24.95+00:00

    Hi @Santosh Kumar ,

    Thanks for your posting.

    In SSAS tabular model, you can only have one physical relationship between two tables active at a time. It depends on how the end user wants to interact with the data but one option is to duplicate your master table. You could set one relationship to inactive. For more information, please refer to Requirements for relationships.

    138709-relationship.png

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful