Forum Discussion
Analysis Service Tabular Model there are ambigous path relationship
kaushikmakadia , Please create a common ticket Table. As both are already joined with Calendar in 1-M and now consider as facts. If the ticket is both fact and dimension. Take one more copy of the ticket and use that as a dimension , do no join with date
Thanks Amit. Can you please more details wih mutiple solution step. Sorry jus wasnt clear in response, thats all. Cheers
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)
Thank you so much Amit. Will check it out
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
