Viewing 2 posts - 1 through 3 (of 3 total)
OK, one of my coworkers figured it out. The magic word was the aggregate command. This works
with member [Ages].[Age].[Under 18] as aggregate([Ages].[Age].&[0] : [Ages].[Age].&[17])
member...
March 7, 2011 at 1:53 pm
#1295578
That did it! Yes, I had to build out the entire range as in
with member [Ages].[Age].[Under 18] as ([Ages].[Age].&[0] + [Ages].[Age].&[1] + [Ages].[Age].&[2] + [Ages].[Age].&[3] + [Ages].[Age].&[4] + [Ages].[Age].&[5] +...
March 4, 2011 at 1:52 pm
#1294878