Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attribute Cross Join

Status
Not open for further replies.

Jodes

Technical User
Jan 10, 2006
6
GB
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top