PDA

View Full Version : custom MemberReader



tysonnorris
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?
thanks
tyson

jhyde
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).