Comparisons across member dimensions

[antya76]

I am working with a Multi-Dimensional model and need help in filtering data where a member in one dimension equals a member in another dimension. The best way to explain what I am trying to do is to use an example.

I have 3 member dimensions, each with individual members

• Buying Company
• Selling Company
• Product Name

I also have a measure for Quantity.

I would like to filter out those Products where the 'Buying Company' is the same as the 'Selling Company'. For example, ABC Company is a member in the Buying Company Dimension and ABC Company is a member in the Selling Company Dimension. I want to be able to determine the number of each product that ABC Company purchased and then Sold. Since the 2 members are in different dimensions, I am having trouble getting the members in Product to filter correctly.

Any help you all can provide would be much appreciated.

Thanks