How can we acheive Correlated sub-query in Designer?

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 DSS?? (Defination of DSS)

2 Answers  


Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.

2 Answers   TCS, Wipro,


We can have two separate installations of BOE XI 3.1 on a single server?

2 Answers  


explain merge dimensions with real time in DWH?

1 Answers   IBM,


What is the functional & architectural differences between business objects and web intelligence reports?

0 Answers  






What are the Users and Usergroups?

1 Answers  


How to change English language to Chinese in BO Desiner (Universe)?

5 Answers   iGate,


1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  


what is merged imension in 6.5 and webi

1 Answers  


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers  


How to restrict password to a user while sending a document in .pdf format

0 Answers   Mphasis,


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,


Categories