Guest_imported
New member
- Jan 1, 1970
- 0
Given someone's date of birth, how can I create a dimension based on the person's agerange?
Is this something I can do as a calculated member or do I need to link it to an agerange table with a view that checks for the current date?
This confuses me because people get older everyday but archived data does not! So how can I always calculate the age range?
A very simple example would be beyond helpful to me.
TABLE
----------------------------------
Person_ID, PersonName, DateOfBirth
QUERY
------------------------------------
Show me all PersonName fields where DateOfBirth is >=90 Years
The dimension would be:
Age Ranges
----------
90+ Years
80-89 Years
70-79 Years
etc...
Thank you!
Is this something I can do as a calculated member or do I need to link it to an agerange table with a view that checks for the current date?
This confuses me because people get older everyday but archived data does not! So how can I always calculate the age range?
A very simple example would be beyond helpful to me.
TABLE
----------------------------------
Person_ID, PersonName, DateOfBirth
QUERY
------------------------------------
Show me all PersonName fields where DateOfBirth is >=90 Years
The dimension would be:
Age Ranges
----------
90+ Years
80-89 Years
70-79 Years
etc...
Thank you!