on 09-02-2012 7:28 PM
Hello experts
I am developing a report in BEX.
The output of the report i want to show on descending sorting by a characteristic field.
The problem is caused by the fact that sorting is done by char field, but the field itself contains only numbers, always.
I mean it looks like this:
Characteristic - Portion Number | Key Figure |
---|---|
900 | 1111 |
859 | 2222 |
81 | 1212 |
795 | 2121 |
732 | 5454 |
7 | 6666 |
624 | 2211 |
Etc. | 4444 |
Please advise how to sort correctly.
Hello,
Use the option to sort it by text OR
create the replacment path variable with Portion Number as the ref char.
Thanks,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
The characteristic Portion_Numb does not contain text table.
It only char12 field without text table, master data table and hierarchy table.
That is not possible to sort by text.
Would you please be more specific about the possibility of "create replacment path variable with Portion Number as the ref char"?
Hi vijay
I want to sort the output of a query with descending sort according to characteristic Portion_Numb, char12.
I do not think it's the solution, there is no connection between sorting the data in the output of the query, and sort the data while loading data.
In any case, the data in DSO sorted already. Since the data are loaded in the delta, once a day, according to the infoobject Portion_Numb. And still it display data sorted incorrectly, as the table above...
Hello Yiannis
Thanks for the reply.
Infoobject named Portion_Numb does not have any conversion routine.
The data type of Portion_Numb is Char12.
During loading data into a DSO, in a transformation level, i use the L_Trim(Portion_Numb) formula, which cuts leading blank characters.
So there is no need in ALPHA conversion routine.
I would like to find a solution in BEX.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.