There is count measure in the cube. I need to create a dimension that
should list the range of values based on that count values:
Exp:

0-99
100-199
200-399
....
.....
...
and so on.
User wants to pick the any range level in the dimension and cube should
show corresponding cell values of count measure which would fall into
range of the dimension level value.
For example:
if user picks up level 100-199 then cube would filter cell values of
measure that has a value between 100 and 199 within 12 month range. So,
it would be year to date value of the measure. My problem is how go
about creating Dimension that based on measure in the cube and
dimension should have level with range of measure values.
Any hint would be appreciated greatly.
Thank You.

This post from Chris Webb's blog addresses a similar problem (but pl.
note that CreatePropertySet() is no longer avilable in AS 2005):

http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!
133.entry

Bucketisation
...
By this I mean the ability to run queries in MDX whereby you can count
(or sum, or whatever) the members that fall within dynamically defined
ranges.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***