Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select within the Select Clause in BO

Need to create a BO Report which will have the select statement implemented within the select clause ( enclosed in paranthesis)

For Eg :

select Employee_Name,

(select Address from Geog where Geog.AddrID = Emp.AddrID) Employee_Address,

Emp.Sal Salary

from Employee Emp

Is there any way to define the objects in Universe so as to acheive this?

( Here the SQL needs to be automatically generated, and not to be overriden at WebI level)

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question