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 ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,

---

how u link universes of same functional domain ?

2 Answers   Business Intelligence Analytics, IBM,

---

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 Answers  

---

Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks

1 Answers  

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

---

---

Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers   HCL,

---

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers   TCS,

---

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

2 Answers  

---

What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,

---

how to overcome overflow of data in a report

6 Answers  

---

how do u resolve contexts ?

6 Answers   Wipro,

---

what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,

---