Custom Member Grouping in Analysis Services Dimension

[bnicosia]

I am fairly new to Analysis Services, and I am trying to generate a cube with several dimensions. One of the dimensions I would like to group the results of one level in bins (values from 0-10, 10-20, 20-30, etc...) that are fixed. I understand how to set the Grouping property on a member to automatic to have it create an automatic set of groupings, but how do a specify a set list of groupings.

There must be something I'm missing. Please let me know if you have any thoughts. Thanks in advance,

Brian

 

[BKhanna]

One way to do this would be to add a column to your dimension table that specifies the bin that each member belongs to. Then use a parent-child dimension to create your dimension, with the parent being the bin column.

BK