How can we acheive Correlated sub-query in Designer?

Question Posted / guest

2 Answers
15945 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 drill across ? can anybody explain me in detail?

1 Answers

who r the users in B.O.XIR2?

2 Answers PCS,

Explain the BO Developer WORK FLOW?

3 Answers TCS,

What are the advantages of Xcelsius & Crystal reports over Infoview?

1 Answers Reliance,

Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?

2 Answers

when we go for snow flake schema rather than star schema ?

5 Answers TCS,

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

0 Answers Arkema pte Ltd,

Can we use unconnected lookup as dynamic lookup?

1 Answers TCL,

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

0 Answers Polaris,

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

0 Answers TCS,

what is diff between webi,deski,infoview

2 Answers

Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski

1 Answers

For more Business Objects Interview Questions Click Here