Skip to Content
0
Former Member
May 10, 2010 at 08:46 AM

Group by issue when MAX & MIN functions used

34 Views

Hi All,

I have a requirement like this:

e.g. I have a employee table with following columns (empno, ename, state,date, sal). Here I have to create a dashboard analytic/webi report like this.

1. I have to display employee details (ename,eno,sal,...) with given date i.e start date & end date of any month like dat (single prompt). For start date the sal should be given date - 1. For this I know we can do it To_DATE() but in universe I guess it is not available. How to do it in universe for start date.

My backend database is SQL SERVER.

2.I have to display employee details with the max (sal) and min(sal) for the given period (start date & end date). For this I have created two measure objects in universe (max(sal) and min(sal)) but when I used in query panel w.r.to other dimensions like empno, ename then groupby function is used, which displaying all the data but max(sal) and min(sal) columns are not properly calculated out for the given time period.

Any help is highly appreciated.

Thanks in Advance,

Suresh Aluri.