If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filtering-Mulitiple Rows Issue

Started by finaid01, 26 Aug 2009 10:44:29 PM

Previous topic - Next topic

finaid01


I am very new to Cognos, but I enjoy what I have learned thus far. I am working on a report that is giving me some difficulty. I am hoping that someone may have some suggestions.

Context: Financial Aid office does not want to pay a student until one of his or her classes has begun in a term.

I've pulled in the column for student id, name, term, course and course start date. Each course obviously has its own row. If I filter on course start date > today's date, it removes all of rows for courses that have started. Unfortunately, some students who remain also have courses that have already started. The basic filter is filtering specifically on the value of the course date row, not in its relation to the other course date rows for the specific student.

Any ideas how I can "link" the class rows to ID and then filter based on the first class date > todays date. Thanks in advance.

angela

Here's some logic but not the syntax needed.

You could try a filter like:
minimum (class_date for student_id) > today

I'm not sure what your requirement is over years because the above would have a problem when years change.  You might need to add another filter:
year(class_date) = year(today)

Or maybe get a rolling 12 months: class_date > _add_days(today, -365)