"Andy S." <andymcdba1@noreply.yahoo.com> wrote in message
news:%230Ad2GvGGHA.1100@TK2MSFTNGP10.phx.gbl...
> 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.
> andymcdba1@noreply.yahoo.com
>
> Please remove "noreply" before replying.
>
>
>
> *************************************************
>
>

"Andy S." <andymcdba1@noreply.yahoo.com> wrote in message
news:%230Ad2GvGGHA.1100@TK2MSFTNGP10.phx.gbl...
> 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.
> andymcdba1@noreply.yahoo.com
>
> Please remove "noreply" before replying.
>
>
>
> *************************************************
>
>

"Jéjé" <willgart@BBBhotmailAAA.com> wrote in message
news:OXcR4byGGHA.984@tk2msftngp13.phx.gbl...
> 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." <andymcdba1@noreply.yahoo.com> wrote in message
> news:%230Ad2GvGGHA.1100@TK2MSFTNGP10.phx.gbl...
>> 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.
>> andymcdba1@noreply.yahoo.com
>>
>> Please remove "noreply" before replying.
>>
>>
>>
>> *************************************************
>>
>>
>
>