Having trouble sorting numerical data from SQL analysis cube

  • Thread starter Thread starter Andy S.
  • Start date Start date
A

Andy S.

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.
(e-mail address removed)

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.
 
Thank you, it works great.
Jéjé said:
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.
Click to expand...
 
Back
Top