When we r going for Short_cut join & It's Resolution???
Plz provide one scenario??
Answers were Sorted based on User's Feedback
Answer / kishore babu
if we have 3 tables A,B,C. our requirement is A->B->C &A->C
That means we make three joins. the referential integrity says
joins must be no.of tables-1.so the join A->c join make as a
short cut join.more than 3 tables we dont go for short cut
join.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / kumar
we have fourtables that is a,b,c,d. normally tables are connected a->b->c->d.I want to data like a->d at that time by using short cut join we can perform.A directly connected to D.
| Is This Answer Correct ? | 10 Yes | 2 No |
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
Explain about Short cut join?
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
How can we use multiple data providers in a single report in business objects?
Can We customize the Business Object infoview in BO?
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:)
what is static filter and dynamic filter
1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?
10.why we are going to data warehouse?
Is it necessary to give joins to the aggrigate tables in the universe?
What is batch processing in Business Objects?