Month from Date of Birth

[Former Member]

I have birthdate as a navigational attribute in a cube. The user wants to select all records for employees who were born in a certain month. Does anyone know of any tricks to make this happen in Bex? Seems like a simple request...

Thanks for your time!

- jboomgaarden

[Former Member]

Easiest thing seems to be to let users specify the full range (month_start date - month_end date) for the birth_date (not easy for the users though).

or,

Let users specify a date, with the understanding that it will pick all records for the month (for the specified date) and then set the corresponding date range in a customer exit.

If you do not have a month field somewhere, I am not sure there is any way to get a month variable input by users.

You could put the month either as an attribute to birth_date, or, create a hierarchy (date-->Month) and load it, before you use month as a selection.