Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Age groups based on difference - Date slicer Rate Topic Display Mode Topic Options
Author
 Message
 Posted Tuesday, November 5, 2013 9:49 AM
 Valued Member Group: General Forum Members Last Login: Monday, February 22, 2016 4:22 AM Points: 74, Visits: 262
 Hello,I have a cube I'm working with that has a dimension called Employees.In the dimension table contains a Birthdate.What I need to do in a query is count the amount of Employees However, I also have to put them into age groups using the Birthdate. Below is an example of the dimension table:`Employee Birthdate1 1951-04-042 1987-05-053 1986-11-044 1977-10-10`So, for simplicity, lets say three age groups;Under 22;22 to 34; Over 35I have no idea how I will achieve this as I need to use a Date slicer. The way this would have to work is whatever dates in the Date slicer (MDX WHERE), would have to evaluate the date difference between the birthdate and the selected date. and then add them to the predefined groups so the example below could be shown.` <22 22-34 35>EmployeeCount 15 40 70`Is there a way/function/MDX what I can create these groups and then group each of the employee? How would I store the birthdate for this to work; member property? attribute?Any help would go a long way.Thanks in advance
Post #1511545
 Posted Tuesday, November 5, 2013 1:00 PM
 Ten Centuries Group: General Forum Members Last Login: Monday, November 28, 2016 2:19 PM Points: 1,290, Visits: 1,394
 Couldn't you do this in a calculated member and use the DateDiff() function to get the number of years. Then use IIF() to put in groups?Just thinking out loud here.HTH,Rob
Post #1511601
 Posted Tuesday, November 5, 2013 3:28 PM
 Valued Member Group: General Forum Members Last Login: Monday, February 22, 2016 4:22 AM Points: 74, Visits: 262
 robert.gerald.taylor (11/5/2013)Couldn't you do this in a calculated member and use the DateDiff() function to get the number of years. Then use IIF() to put in groups?Just thinking out loud here.HTH,RobThanks for responding Rob. I can certainly look into it. The first thing I thought was DateDiff. Because I'm using the selected date, which is the slice, I'm not really sure how I'd use Datediff. If you have a simple example, I'd really appreciate it. then I'd need to put this logic into a function to reuse. My MDX skills aren't the strongest.I'll go away and look at IIF() for groups.
Post #1511656

 Permissions