SQL Analysis Services - Dimension attributes with a "many" cardinality
- by MonkeyBrother
I am creating a cube with the following tables:
Customer
CustomerID,
Name
Customer Rep
CustomerID,
RepID
Rep
RepID,
Name
The important thing here is that there is a many to many relationship between Reps and Customers. I want to be able to ask the question "How much sales for customers working with rep 'A'?" In the data source view i set up the relationships between both customerid columns and both repid columns. I set up the rep attribute in the dimension builder and when I try to build the cube I get this error:
Errors in the high-level relationship engine. the 'Rep' table that is required for a join cannot be reached based on the relationships in the data source view.
