Cartesian Product

[dbomrrsm]

I have a universe where there are two tables that join together with a straight forward join.

In Webi I can generate a simple query with a dimension from one table and a measure from the other and the sql is produced correctly with the relevant join condition in the where clause.

However, creating exactly the same query in full client reporter gives a cartesian product warning and when I view the sql there is no where clause so no join between the tables.

Can anyone hazard a guess as to wjy this might be happening ?

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[skrandel]

I would suggest finding and deleting all versions of the universe off of your local desktop. The universe that the client is using is not the right one.

Steve Krandel
Intuit