Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Int's sorting as char's
0 views
Skip to first unread message
Joe H
Oct 13, 2008, 5:06:52 PM10/13/08
to
I have ContractID in my dimension - but it sorts it as a character not an
integer:
integer:
This is what it's doing:
7998
7999
8
8049
8890
9
9122
9733
fim...@exologic.com
Oct 13, 2008, 5:49:07 PM10/13/08
to
It could be as simple as changing the Sort By from Name to Key.
Or be explicit about it by adding another field in your DSV called
ContractIDSort, and do a T-SQL Cast on it.
Then add another attribute to the dimension. Then make the
ContractID, original attribute, as a Sort By the attribute
ContractIDSort.
Or be explicit about it by adding another field in your DSV called
ContractIDSort, and do a T-SQL Cast on it.
Then add another attribute to the dimension. Then make the
ContractID, original attribute, as a Sort By the attribute
ContractIDSort.
That should eliminate the issue.
-exologic
0 new messages