|
Home > Archive > MS SQL Data Warehousing > January 2006 > Having trouble sorting numerical data from SQL analysis cube
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Having trouble sorting numerical data from SQL analysis cube
|
|
| Andy S. 2006-01-16, 8:23 pm |
| 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.
********************
********************
*********
| |
| Anne Troy 2006-01-17, 3:23 am |
| Very common, Andy. This should help:
http://www.officearticles.com/excel...osoft_excel.htm
See "Data isn't recognized..."
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
"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.
>
>
>
> ********************
********************
*********
>
>
| |
|
| 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.
>
>
>
> ********************
********************
*********
>
>
| |
| Andy S. 2006-01-17, 9:23 am |
| Thank you, it works great.
"Jéjé" < willgart@BBBhotmailA
AA.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...
>
>
|
|
|
|
|