Forum Discussion
Helper IAnalysis Service Tabular Model there are ambigous path relationship
Super Userkaushikmakadia , 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
kaushikmakadiaThanks Amit. Can you please more details wih mutiple solution step. Sorry jus wasnt clear in response, thats all. Cheers
- amitchandak
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
Thank you so much Amit. Will check it out