Is there an relatively easy way (i.e. that one might instruct an end-user in) to determine the lowest date from a given series? I tried Min in Report Variables, which didn’t work. I gather that there is a LEAST command in SQL, but don’t see anything like it in BusObj. The idea being I want to find the earliest date (in our case, History Status Date in an employment record) later than 9/1/98.
Any thoughts?
Thanks!
Amy Miller
====================================
Amy A. Miller, Data Analyst
University of Pennsylvania ISC
Office of Data Administration
3401 Walnut, Suite 265C /6228
Philadelphia, PA 19104-6228
Phone: 215-898-2171 Fax:215-898-0386
Email: milleraa@isc.upenn.edu
One of the operands available on the Query panel when you build a condition is “Calculation”. There is a wizard that walks you through the necessary steps. The functions available are Average, Count, Count Distinct, Maximum, Minimum and Sum. One of my users has used it to determine a minimum date.
There is an excellent discussion of Calculation in Robert Schmidt’s book Creating Documents with BusinessObjects 4.1.
Barbara Rosen
Database Development & Admin Services
Salomon Smith Barney
Phone: (212) 723-2756
e-mail: barbara.rosen@ssmb.com
Have you tried putting a filter on that column in the report (in your example, values later than 9/1/98) and then sorting the remaining values in that column in ascending order (so the oldest appear first). I think end-users could follow that.
George Baranowski
QuadraMed
Hi there–
Is there an relatively easy way (i.e. that one might instruct an end-user in) to determine the lowest date from a given series? I tried Min in Report Variables, which didn’t work. I gather that there is a LEAST command in SQL, but don’t see anything like it in BusObj. The idea being I want to find the earliest date (in our case, History Status Date in an employment record) later than 9/1/98.
If you’re really only interested in getting a minimum date in the reporter module, you could first format it to a character string that shows century-year-month-day, and then use min(). The result you can reformat to show the date the way you want it to show on the report.
I have created, in the Universe, an object MIN(date). This works well for the users.
Hi there–
Is there an relatively easy way (i.e. that one might instruct an end-user in) to determine the lowest date from a given series? I tried Min in Report Variables, which didn’t work. I gather that there is a LEAST command in SQL, but don’t see anything like it in BusObj. The idea being I want to find the earliest date (in our case, History Status Date in an employment record) later than 9/1/98.