Using the Max( ) function in the results

building reports desktopintelligence
1

I am trying to fetch the maximum value of a particular object E.g. the most recent order date .
I tried using the subquery tool but I did not get good data.

I was wondering if anyone out there knew a way of doing this.

Any help will be greatly appreciated

Venu
Dunn Systems Inc

Listserv Archives (BOB member since 2002-06-25)

2

I had the same problem. I tried a lot working with correlated sub query but never could get around it. The solution i found is i created a view with ex: object, and max date for that object and then try to join with the view in my universe.

Thank you.

Radhika

Listserv Archives (BOB member since 2002-06-25)

3

I don’t particularly recommend this method but our company does use it. We have an Oracle view set up which, in addition to selecting a certain subset of records, also selects by using the MAX(date) function in Oracle to get the most recent status record.
Roger Poole
rpoole@nswc.navy.mil

I am trying to fetch the maximum value of a particular object E.g. the most recent order date .
I tried using the subquery tool but I did not get good data.

I was wondering if anyone out there knew a way of doing this.

Any help will be greatly appreciated

Venu
Dunn Systems Inc

Listserv Archives (BOB member since 2002-06-25)