How can we acheive Correlated sub-query in Designer?
Answer Posted / 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 |
Post New Answer View All Answers
Give some information on report bursting?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
how to create reports on screech?
How to schedule the report in b.o?
Explain about a time when you discovered a more efficient way to do a work task?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How to restrict password to a user while sending a document in .pdf format
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What is difference between webi and infoview?
How many universes can be created in a project?
Explain when we use aggregate awareness function in designer?
Explain what are the steps to be taken to schedule the report?
what is xcelsius architecture?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Can we configure two instances of CMS pointing to two different CMS system databases?