Summary: calculating age using person date of birth and the effective date variable based on a date entered in the prompt. content (required): i need to calculate age using the person date of birth with an effective date variable based on the date a user enters in the prompt please see screen shots below. any help with this is much appreciated. I'm guessing the idea was it would be easier to base age on a static date. in the subject area i need to use now it's common for criteria to contain different time period data, which could possibly complicate calculations based on different joins.

We need to report grade distribution per age category. i have created otbi report with as of date parameter but struggling to get age calculation working with the parameter. 1. on our database, i can perfectly calculate the age as trunc (months between (birth date, reporting date) 12). i simply want obiee to be able to call this same function 2. users can select any valid date in the "reporting date" dimension to report against. this dimension is at the day level and has 10 years of history. 3. Hello, i'm trying to calculate employee's age as of 01 01 20xx, using ps query manager. i am able to get their age as of sysdate using this expression: months between(sysdate, b.birthdate) 12. Hi, how to calculate age between two dates excluding saturday and sunday in obiee 11g report, used below but getting wrong values.

Hello, i'm trying to calculate employee's age as of 01 01 20xx, using ps query manager. i am able to get their age as of sysdate using this expression: months between(sysdate, b.birthdate) 12. Hi, how to calculate age between two dates excluding saturday and sunday in obiee 11g report, used below but getting wrong values. Summary what is the formula needed to calculate age within a bi analysis? content i am trying to complete a report to calculate the age levels of employees. i pulled in headcount, and date of birth 3 times. in the second date of birth column, i changed the expression to reflect the current date. in the third date of birth column i tried to create the formula as i would in excel: int ( (current. I tried calculating the age of the customer under validating and defaulting tab but since the formula needs summary i created a saved search and pulled those values into a custom field in the customer record using before load user event script. Summary need help on determination formula to calculate age and years of service as of termination date content hi! has anybody tried using ff for determination rule to be as of termination date? i am trying to create an eligibility profile for a benefit plan that involves derived factors on age and years of service. but the eligiblity depends on age and years of service of employees on their. I want to modify an age determination ff we have. there are 2 conditions, for some life events, i want the date to be the 'occurred date' and for other life events, i want the date to be 'first of the calendar year'.

Summary what is the formula needed to calculate age within a bi analysis? content i am trying to complete a report to calculate the age levels of employees. i pulled in headcount, and date of birth 3 times. in the second date of birth column, i changed the expression to reflect the current date. in the third date of birth column i tried to create the formula as i would in excel: int ( (current. I tried calculating the age of the customer under validating and defaulting tab but since the formula needs summary i created a saved search and pulled those values into a custom field in the customer record using before load user event script. Summary need help on determination formula to calculate age and years of service as of termination date content hi! has anybody tried using ff for determination rule to be as of termination date? i am trying to create an eligibility profile for a benefit plan that involves derived factors on age and years of service. but the eligiblity depends on age and years of service of employees on their. I want to modify an age determination ff we have. there are 2 conditions, for some life events, i want the date to be the 'occurred date' and for other life events, i want the date to be 'first of the calendar year'.