How can we acheive Correlated sub-query in Designer?
- 2 Answers
- 14628 Views
- Infosys, TCCX, Wells Fargo, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prabha
A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the
outer query. This is the main difference between a
correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run
independently of the outer query, and will return a result
set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by
itself.
| Is This Answer Correct ? | 5 Yes | 17 No |
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?
If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.
in sap bi we have wad, then why we go for sap bo
As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.
what is dashboards? what is metrics?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
what is traffic lighting in business objects?
what is isolated joins in check integrity
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
Explain which versions are used in the bo dashboard work?
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
Teradata 
