Correlated subquery-universe soln

building reports webintelligence
1

Hi All,
As I understand it, in WebI creating a correlated subquery at the report level is not possible. Is it possible to create a universe object or condition that will help me create a correlated subquery without editting the SQL

Th reqd is I have a table where i need to first find the duplicates(I use count>1) and among the resultant rows find where a column value repeats.

Eg
S.No Name Status
100 abc x
100 abc y
100 ghi x

I need to report
S.No Name Status
100 abc x
100 abc y

Any way out without editting SQL

Thanks
Meena

meenaj (BOB member since 2005-01-12)

2

What kind of question are you trying to answer? You should be able to do this in a derived table with in the universe.

The key to correlated sub query is to include a reference to the outer query within the inner query…kinda like this:

select empnum, name from employee as a
where salary > (select avg(salary) from employee where department=a.department)

where a.department is the reference to the “outer” query within the “inner” query.

SteveBickerton :canada: (BOB member since 2002-08-15)