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.



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