How can we acheive Correlated sub-query in Designer?

Question Posted / guest

2 Answers
15952 Views
Infosys, TCCX, Wells Fargo, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we acheive Correlated sub-query in Designer?..

Answer / vamsi

Use Nested Derived Table

Is This Answer Correct ?

0 Yes

0 No

How can we acheive Correlated sub-query in Designer?..

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

Post New Answer

More Business Objects Interview Questions

what is Scope of Analysis

8 Answers TCS,

1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?

1 Answers IBM,

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 Answers

What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers Accenture,

How many universes will run maximum in single project

1 Answers HP,

How to schedule the report in b.o?

0 Answers

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers Wipro,

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers TCS,

What is the definition of derived table ?

2 Answers JPMorgan Chase,

1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 Answers

Give some information on report bursting?

0 Answers

What is a Set?

1 Answers

For more Business Objects Interview Questions Click Here