Having trouble sorting numerical data from SQL analysis cube

I've built a cube with a numerical dimension in SQL 2000 analysis
services. When I add that dimension as a column, it sorts as follows

1
10
100
2
20

instead of
1
2
10
20
100

I've tried doing a sort in Excel 2003 and 2000, even setting the type as
Number. In Analysis services, I've tried setting the properties for that
dimension to quantative. Any suggestions on what to do next?


--

*************************************************
Andy S.
[email protected]

Please remove "noreply" before replying.



*************************************************

Very common, Andy. This should help:
http://www.officearticles.com/excel/...soft_excel.htm
See "Data isn't recognized..."
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Andy S." <[email protected]> wrote in message
news:%[email protected]...
> I've built a cube with a numerical dimension in SQL 2000 analysis
> services. When I add that dimension as a column, it sorts as follows
>
> 1
> 10
> 100
> 2
> 20
>
> instead of
> 1
> 2
> 10
> 20
> 100
>
> I've tried doing a sort in Excel 2003 and 2000, even setting the type as
> Number. In Analysis services, I've tried setting the properties for that
> dimension to quantative. Any suggestions on what to do next?
>
>
> --
>
> *************************************************
> Andy S.
> [email protected]
>
> Please remove "noreply" before replying.
>
>
>
> *************************************************
>
>

in your dimension.
you have to setup the order property to "member key" instead-of "member
name".
the names are allways strings in a dimension.
also, you can add a property for the level, and use this property to sort
the dimension members.


"Andy S." <[email protected]> wrote in message
news:%[email protected]...
> I've built a cube with a numerical dimension in SQL 2000 analysis
> services. When I add that dimension as a column, it sorts as follows
>
> 1
> 10
> 100
> 2
> 20
>
> instead of
> 1
> 2
> 10
> 20
> 100
>
> I've tried doing a sort in Excel 2003 and 2000, even setting the type as
> Number. In Analysis services, I've tried setting the properties for that
> dimension to quantative. Any suggestions on what to do next?
>
>
> --
>
> *************************************************
> Andy S.
> [email protected]
>
> Please remove "noreply" before replying.
>
>
>
> *************************************************
>
>

Thank you, it works great.
"Jéjé" <[email protected]> wrote in message
news:[email protected]...
> in your dimension.
> you have to setup the order property to "member key" instead-of "member
> name".
> the names are allways strings in a dimension.
> also, you can add a property for the level, and use this property to sort
> the dimension members.
>
>
> "Andy S." <[email protected]> wrote in message
> news:%[email protected]...
>> I've built a cube with a numerical dimension in SQL 2000 analysis
>> services. When I add that dimension as a column, it sorts as follows
>>
>> 1
>> 10
>> 100
>> 2
>> 20
>>
>> instead of
>> 1
>> 2
>> 10
>> 20
>> 100
>>
>> I've tried doing a sort in Excel 2003 and 2000, even setting the type as
>> Number. In Analysis services, I've tried setting the properties for that
>> dimension to quantative. Any suggestions on what to do next?
>>
>>
>> --
>>
>> *************************************************
>> Andy S.
>> [email protected]
>>
>> Please remove "noreply" before replying.
>>
>>
>>
>> *************************************************
>>
>>
>
>