problem in applying Max functionality in a Sub query

building reports webintelligence
1

Using BO XIr3.1, WEBI (Rich Client)

Hello,

how can i apply MAX or MIN function in the Query Panel of WEBI without creating object/predefined condition in the Universe?

situation: I have a table EMP with cols - EMPID, NAME, SALARY.

I want to execute

Who is the highest paid employee in the company? using sub query
Ans:
select emp.fname
from emp
where emp.sal = (
select max(emp.sal)
from emp
); in MSSQL

I want to display the name of the emp in the report??? I know its possible to make an object in the Universe with the Select statment

max(EMP.SAL) however i want to be able to do this on WEBI only,

and then apply a sub query such that
sal Equal to maxsal

plz tell me my question is unclear…

thanks in advance
sandra

sandra911 (BOB member since 2010-02-01)

2

and no free hand sql plz, my company is currently analyzing various reporting tools and thats we want to check the limitations of WEBI, its a good tool without any doubt :slight_smile: but every tool has limitations.

cheers.

sandra911 (BOB member since 2010-02-01)

3

Hi,
You can have that in the condition object which acts as a sub query.
Just put the sub query in the universe and you can have it on the report.

Also please wiat for sometime before posting another reply to your own post. You could have edited your old post to have only one post.

Omkar Paranjpe :us: (BOB member since 2006-02-13)