I found out in a weird way that the MDX range operator ( apparently does
not work when a dimension's storage mode is set to ROLAP. I was able to
reproduce this very easily using the FoodMart 2000 database. By changing the
storage mode to ROLAP for dimension "Education Level" the following query:

select
{[Time].&[1997]} on columns,
{[Education Level].[All Education Level].&[Graduate Degree]:[Education
Level].[All Education Level].&[Partial High School]} on rows
from [Sales]

fails with a "Cells cannot be created for this cellset because one of the
axes contains no positions".

Is anybody aware of this problem? Is there a way around this?
Note that, since my real life app generates MDX, just creating another MDX
is only an option if there is information available through ODBO, which I
haven't found yet, to base this decision on.

Any info related to this problem would be very much appreciated.

Thanks,

Hubert