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-Multiple Row Issue

Started by finaid01, 26 Aug 2009 10:46:17 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.