What is the difference between Sychronisatio and join?
- 2 Answers
- 6417 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / karthik
At web I level, when the Query designed by BO, these two
options (join / Synchronization).
Join happens when "Multiple SQL allowed for each Measure" is
checked in BO universe.
Synchronization Normally happens due to the selected object
is out of the selected context.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sagarika
join : join is giving a relationship between 2 tables in a
universe.
example: customer table and department table.
linking these two table is called join.
Synchronisation : retrieving data from two dataproviders
with common column and then synchronise to get the result.
| Is This Answer Correct ? | 4 Yes | 4 No |
how do u resolve contexts ?
what is dashboards? what is metrics?
I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Is it necessary to give joins to the aggrigate tables in the universe?
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 the functional & architectural differences between business objects and web intelligence reports?
How to change font color of values in hyperlinked columns?
What is the drill up , drill down, drill by , drill trough ?
What is the difference between master-detail and Breaks?
How to hide the table s in webi?can any one tell me plzzzzzzzz
Teradata 
