You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to use the Min aggregate function along with group by clause in OTBI analysis

Received Response


I have a requirement to build analysis to fetch all the benefit enrollment data for a participant as well as dependent. I need to fetch the actual enrollment date of a participant & dependent into a plan type. When the employee moves from one plan to the other plans with in the same benefit Plan type (Ex Medical plan) the original enrollment date is updating with the enrollment date of new plan.

Ex: We have 4 medical plans with in the benefit Plan type 'Medical' i.e Medical TP1, Medical TP2, Medical TP3 etc. An employee can switch from TP1 to TP2 any time, I need to report the date when the employee actually started his coverage in the Plan type 'Medical'.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!