Attribute Cross Join

[Jodes]

I have 3 tables: A, B & C.

A joins to B & B joins to C. When I pull data from A & B, or B & C, everything works fine, but the moment I pull from all 3 tables, I get a cross join on one table.

Any ideas why the Join suddenly fails?

All the objects are Attributes. The joins are heterogeneous & work fine when only used with one other attribute. It seems to not recognise a Join that previously worked. Anyone out there come across this before?

 

[Jodes]

A fix has been recommended by MicroStrategy (which works perfectly):

The problem is with the Relationship between the tables. When using a Star Schema, the joins need to be Many To Many. Using a 1:Many relationship creates Cross Joins when used in a Star Schema set up.