Chars in Sorted Order

[Former Member]

So if the Characteristics do not automatically display in any Sorted order ; what is wrong with my front end and how should i fix it ?

[former_member189638]

If u select the sorting option by doing a right click on the Characteristic and selecting properties, still it is not getting soreted?

[Former Member]

It sorts after the right click - but i want it as a default output - such that the user does not need to do anything to get the sorted order.

[Former Member]

I think the Zero padding is not really the issue. The values are all 6 char alpha numeric. I am probably looking for BI's default Sort behavior which is not working - not sure why that is so.

[Former Member]

Shweta,

Could you paste a sample of sort you are seeing in your frontend..

Thanks.

[former_member188011]

Hi Shweta2207:

Do you have Structures on your query definition? That might be the cause you're not able to sort your query results.

Regards,

Francisco Milán.

[Former Member]

Hey Debajyoti,

Unfortunately I can't paste the exact info - but let's take an example. Say I have the foll material numbers which are currently appearing in the this order that I am mentioning below and actually should be in a proper ascending order :

1. D234452

2. A432500

3. 11130028

4. 10440022

5. 11240328

So they are clearly not in order since what I expect is 4,5,3,2,1 as the order.

Hey Francisco - nopes - no structures on the query.

thanks

Shweta

[former_member188011]

Hi Shweta2207:

If you expect to get the values 4, 3, 5, 2, 1 (ascending order) then you need to right pad with blank spaces the values that are 7 characters in lenght, this way all the Material Numbers will be 8 characters long and you'll get the expected sort order.

I think the master data is being sorted this way because the values are being left paded with zeros, because of the ALPHA Routine.

Regards,

Francisco Milán.

Edited by: Francisco Milan on May 20, 2010 5:20 PM

[former_member188011]

Hi Shweta2207:

You might need to use the ALPHA Routine on the InfoObject definition (General Tab) for each Characteristic that is not being sorted properly. This way the Characteristic values will be left padded with "0" (zeros) during data load, and your report should display data sorted correctly.

Regards,

Francisco Milán.