How can we acheive Correlated sub-query in Designer?

Question Posted / guest

2 Answers
15922 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

In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 Answers

how to hide the prompts?

7 Answers TCS,

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers

Can any please explain FOR EACH AND FOR ALL?

2 Answers HCL, Infosys, TCS,

What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

7 Answers TCS,

what is optional prompt in boxi r2

4 Answers Mind Tree,

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers

What is the difference between the Webintelligence and desktopintelligence?

2 Answers IBM,

Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx

4 Answers

1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?

1 Answers iGate,

Can we configure two instances of CMS pointing to two different CMS system databases?

0 Answers

What is drill across ? can anybody explain me in detail?

1 Answers

For more Business Objects Interview Questions Click Here