View Full Version : custom MemberReader

05-08-2002, 10:34 AM
Hello -
I'm trying to create a custom MemberReader to encapsulate some SQL functions within the query.
For example, my db has a dob date field, but the values I'm interested in using are "age" values.
So instead of getting the dob column, I get
EXTRACT( YEAR FROM age("Age"."usr_dob"))
which returns age in years, based on usr_dob.
It seems like CellRequest needs to be modified to handle custom reader for this to work, but I'm not sure where to begin.
Any ideas?

05-14-2002, 10:19 AM
I think a custom member-reader is overkill for this. You could either create a view containing the expression, and base the hierarchy on that view, or you could use the 'sql' attribute of the 'Hierarchy' element (which is an alternative to the 'table' and 'schema' attributes).