Hi.

I have a Commodity dimension:

CommodityGroup
Commodity

The caption of the Commodity level members is "Name" + ' ' + "Commodity_Nr"
The key is "Commodity_Nr"
The level is ordered by name (alphabetical).
The problem is that my users want to select ranges of commodity numbers to
display: SELECT [Commodity].&[100]:[Commodity].&[1000]...
New commodities are added into these ranges and they need to be displayed
too. I cannot solve this by adding a level that groups commodities by
numeric groups (group 100-1000, 1000-1200 etc).
So: Is there any way to select members by the range of its key and not how
its ordered in the level?

Any help appreciated,

Peter

Hello Peter,
you could add a virtual dimension based on member keys.

Or you filter by Key
(Properties are always stored as strings).

HTH
Jörg

Try this in MDX Sample App:

with member measures.CustKey as 'customers.currentmember.properties("key")'

Select

Filter(customers.[name].members,clng(measures.CustKey) >= 1000 AND
clng(measures.CustKey)< 1100 )

on 0 from sales

where(measures.CustKey)

"Peter Koller" wrote: