Suppose if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Submitted by: AdministratorCartesian 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.
Submitted by:
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.
Submitted by:
Read Online Executive Business Development Job Interview Questions And Answers
Top Executive Business Development Questions
| ☺ | Explain bo repository? |
| ☺ | Explain the difference between ZABO and webi? |
| ☺ | Described about report template in B.O? |
| ☺ | Explain difference between union and group? |
| ☺ | List the steps to do to use Alerts in BO? |
Top Analysis Categories
| ☺ | GIS Interview Questions. |
| ☺ | Statistics Interview Questions. |
| ☺ | Financial Analyst Interview Questions. |
| ☺ | GIS Analysis Interview Questions. |
| ☺ | Data Analyst Interview Questions. |
