Having trouble sorting numerical data from SQL analysis cube

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.



*************************************************
 
J

Jéjé

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.
 
A

Andy S.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top