Answer / vamsi

Use Nested Derived Table

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.

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

2 Answers   Accenture,

---

What is the Drill filter and it's usage?

2 Answers  

---

Draw the architecture of traps?

3 Answers   Wipro,

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

6 Answers  

---

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,

---

Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....

2 Answers  

---

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers   Wipro,

---

why we are using derived tables ?how it will help?

2 Answers  

---

What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,

---

what r the types of joins universe supports

3 Answers  

---

What task is 98% of the required work of a business analyst?

0 Answers  

---

Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

3 Answers   PWC,

---