Hi,

I have a measure in a facttable where I would like to have a dimension
group based on.

like <25 , 25-50, 50-75 and 75-100.

There are a lot os possibilities like 20,002, 20,01 etc.

I can make very easy a dimension based on all values.

But I want a dimension or measure with groups based on above example.

What is the between mdx code to make such measure:

iff(measure is between ??, )

Regards, Marco

Turn the measure into a dimension. Even though it is a numeric column,
you can use this a s a Dimension/ You will need another table to map
the unique values to a grouping, or you could use a view if you do not
want to store the data in another table.

the other option is the automated grouping in a dimension - this is
usually only used in a large dimension where the number of members is
getting close to the 64000 child member limit. I use it in one cube
where the groups are not important, grouping a journal number dimension
- works fine and I don't have to do any work on the sql side to achive
a grouping.

hope this helps