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