pinki

• Jul 20th, 2006

 

cartesian product is getting  incorrect results.

for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.

ex:-

we have customer,orders,loans classes

orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.

jayjaiswal

• Jul 1st, 2007

 

Check the joins between the tables properly. if required create it manually..

narmadac

 Profile Answers by narmadac 

• Feb 17th, 2010

 

To prevent cartesian product when running a report  initially you can set it in the Universe Parameters.

File ----> Parameters ----> SQL tab ----> two options for Cartesian products 1) Prevent  2) warn (default)      -----> click any one of them and then OK

lionskashif

 Profile Answers by lionskashif 

• Feb 2nd, 2011

 

The Problem is in your schema. Please check your joins, and cardinalities
also check loops.

Whenever cardinalities is not set proper its give you three types of error.
1-->Incompatibility result
2-->Ambigeous result
3-->Cartiesum result