Sorting A Dimension

[jatin.popat]

Hello,

I having following Values in a particular dimension :
A,1,2,3,4,5,0,-1,-2,-3,-4,-5

As per Client Requirement, It should be displayed in the cube as :
-5
-4
-3
-2
-1
0
1
2
3
4
5
A

I have tried both the numeric as well Alphabetic sorting but i am not getting the required output.
Kindly provide some suggestions regarding this issue....................

Thanks in advance............

[SanderH]

The easiest solution is to add a column in your data source which contains the sort order. Use this column in your Transformer model to set up the correct sorting order.

[jatin.popat]

i should create this sorted column in FM model or Transformer Model ?

[SanderH]

First you need to add this in your data source and then include it in your Transformer model. Then you can use it for sorting the items in the dimension.

[jatin.popat]

I solved this problem using hard-coding in the transformer model........

...>> Created a new calculated column in the Transformer model using
       
        if 'A' then '6'

Ans then used this calculated column to sort that particular dimension.....