We have once again started the discussion of comparing one of our current BI tools with WebFocus and I was wondering if anybody had information regarding techniques for returning max effective dated rows (and other interim rows in the effective dated "stack") from a PeopleSoft relational database? Everything currently used to access our relational system data (PS/Query, Brio, SQR) is SQL based so it is fairly simple matter to create sub-queries. I'm curious what techniques would be used to accomplish this in FOCUS. Thanks for your thoughts.

This message has been edited. Last edited by: cbm,

If I remember my Peoplesoft work... it's been a while...

An example with an employee based table, looking for the highest effective date less than or equal to today's date...

BY employee_id
BY HIGHEST 1 EFFECT_DATE
WHERE EFFECT_DATE LE '&YYMD'