Forum Discussion

kaushikmakadia's avatar
kaushikmakadia
Helper I
5 years ago

Analysis Service Tabular Model there are ambigous path relationship

Hi there, I have below tabular model SSAS relationship in data model : ActionTable [ActionDate] with M:1 with CalenderDate[FullDate] TicketTable[TicketReportDate] with M:1 with CalenderDate[FullDa...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

kaushikmakadia , As Both Ticket and Action, are Fact. If you need to join Ticket and Action then you need to have a common ticket table. That comes from distinct values from both table.

But If Ticket to Action is 1 -M, means the ticket is also dimension, as well as fact. Add Ticket again  with a new(Ticket_dim)  name and use it only to connect with  Ticket and  Action(1 - M)

kaushikmakadia's avatar
kaushikmakadia
Helper I
5 years ago

Thank you so much Amit. Will check it out

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi, kaushikmakadia 

    Could you please tell me whether your problem has been solved?

    If yes, you could accept the helpful answer as solution. You could also share your own solution here.
    For now, there is no content of description in the thread. If you still need help, please share more details to us.

    Best Regards,
    Community Support Team _ Eason