relationship ambiguity

[pimsbi]

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

[Ashish_Mathur]

Hi,

Show your data and more importantly the expected result.

[pimsbi]

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.