What is Cartesian product?
Answers were Sorted based on User's Feedback
Answer / n.santosh
TAKE ANY TWO NON EMPTY SET. SET A AND SET B. SET A AND SET B
CROSS EACH OTHER IS CALLED CARTESIAN PRODUCT.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kishore
Just relation between the table using for Cartesian Product (Its using for Universe Issues Identifly purpose only)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shiela
Cartesion product is the product where all possible
combination are given .The result of cross join is called
as Cartesin Product.A Cartesian product is a result set
which contains all the
possible combinations of each row in each table included in
a query
| Is This Answer Correct ? | 4 Yes | 6 No |
Answer / sushant deshmukh
Cartesion product is the product where all possible
combination are given . But it is not use in database
because it is time as well as memory consuming.
| Is This Answer Correct ? | 3 Yes | 7 No |
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
Explain how to execute the plsql procedure from the report by clicking with mouse?
what is report tracing in bo
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
what is crosstab reporting,slice and dise and drill mode??
how we improve the performance of report and universe?
What is recurring sheduling and batch scheduling?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
is it possible to export the webi reports to crystal reports?with out using businessview?
can i use stored procedure in webi?
what are the debuggings in the business objects?