Forum Discussion

pimsbi's avatar
pimsbi
Frequent Visitor
8 years ago

relationship ambiguity

Hi all

I am probably posting a question already raised by many people.

I am building some sales BI. I have configured:

- 1:N relationship between Owners and Accounts

- 1:N relationship between Accounts and Opportunities

 

However, in my organization, it is possible that an Opportunity belongs to a Owner different from the one owning the opportunity's Account. So when trying to configure a 1:N relationship between Owner and Opportunities I am getting the "ambiguity" error.

 

I understand I could create a duplicate Owners table.  However I would like to be able to list both the owned accounts and the owned opportunites with one selection.

 

Can anybody suggest a strategy to solve this?

Thanks for your help

Need Help

2 Replies

    • pimsbi's avatar
      pimsbi
      Frequent Visitor
      8 years ago

      Hi,

      Thank you.

      I solved the issue by creating dim tables based on the role. now I am able to filter entities according to different perspectives.