Correalted Query in Report Studio

[meenatikare]

Hi,

Can somebody please let me know how can we implement correlated query in report studio.

Ex: how to implement below query in Cognos.

SELECT EMP_NAME,
(SELECT SUM(SAL) FROM EMP MGR WHERE MGR.EMP_ID = EMP1.MANAGER_ID)
FROM EMP EMP1

Thanks in advance,
Meenakshi

 

[mfgf]

Hi,

The short answer is you would need to code this query yourself, but to be honest that's not really best practice in Report Studio. Why do you need a correlated query - a derived table (which you get by default) would probably be just as efficient, and could easily be modelled in Framework Manager.

Regards,

MF.