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.

what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,

---

What is broad cast agent?

5 Answers  

---

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

3 Answers   Collabera,

---

What is scope of analysis ?

3 Answers   L&T,

---

In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,

---

What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,

---

what is diff between webi,deski,infoview

2 Answers  

---

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers  

---

what are the documentations u r created?

2 Answers   Wipro,

---

what is drill down?

5 Answers   TCS,

---

What are universe parameters?

6 Answers  

---

Is it necessary to give joins to the aggrigate tables in the universe?

2 Answers  

---