We have requirement from client to calculate age group on fly. Is not like calculated member from Data source view.
i.e. User drag measures and dimension agegroup (in this case calculate agegroup based on current date).
if he/she is viewing data for year 2003 then age should be based on year 2003 not she/he has today.
Early to see more solutions.