I have a role playing dimension and need to run a query that will select the intersection of members that are common on a single attribute... So Dim1 and Dim2, they both have the attribute [Name] (though the fact table has two different
foreing keys mapping to the single primary key on the dimension table)
I need to select the members where both foreign keys on the fact table map to the same member in the dimension table
so for example, Dim1.Name = 'John Smith' and Dim2.Name = 'John Smith'
View Complete Post