Using URL to Sort Values

[Former Member]

Hi,

I am using Web Application Designer. I have a table which has a column of numbers (these numbers are derived using a formula in the query). I want to sort (ascending/descending) this column of numbers using the SAP_BW_URL so that I can make links to sort by asc or desc.

I tried following this help doc: http://help.sap.com/saphelp_bw30b/helpdata/en/50/0a433ab9fb960ee10000000a11402f/content.htm

But I can't get it to work. I use sort_type = 'V' but when you do that, it ignores the iobjnm characteristic value. Instead, it expects value for structure_member. This doesn't make sense to me. I don't want to sort an entire structure... just one characteristic in the structure. Can someone clarify that?

OR (alternative solution????)

In the context menu of the column, I can choose sort, then sort in Ascending Order or sort in Descending Order. Is there a way to get the URL of that link in the context menu?

Thanks!!!!!

[Former Member · Accepted solution]

Does anyone know how to call the same JavaScript fuctions that are used in the context menu?

I want to put a link on the page which does the same thing as going to a key figure's context menu, choosing Sort, and then choosing Sort in Ascending Order.

Thanks,

[Former Member · Accepted solution]

Hi Audrey,

I think your problem is with the dataprovider

Is DP correct?

<SAP_BW_URL DATA_PROVIDER='DP' CMD='SORT' SORT_TYPE='V' SORT_DIRECTION='A' STRUCTURE_MEMBER_1='3WWA4FB5R1K1YDEPYWXEHR91A'>

Also a good solution would be, to execute your template with &snippet_operations= (add this to your URL). Now for each step a new URL will be generated and you can see this in the browser address bar. Check the settings here and change your SAP_BW_URL notation accordingly.

The javascript functions in the context menu are not released for customer usage. Of course you could just call the same function, but this of course might be changed in a SP for example.

Heike

[Former Member · Accepted solution]

Hi,

I am having this problem also.

I have the dataprovider and other bits correct. I know this because I have managed to get the sort url working to sort characteristics using SORT_TYPE='T' and IOBJNM='technical name for characteristic'.

The problem comes when trying to sort a structure. I have done everything as said in the help documents posted above but it does not work.

Can anyone help us?

[Former Member · Accepted solution]

I too was able to get it to work when I changed the field that I was sorting on to a characteristic. But it still doesn't work on a formula.

Can anyone help?

Thanks.

[Former Member · Accepted solution]

Hi all,

there had been an error in the documentation

The actual documentation states sort_type=W and not V

http://help.sap.com/saphelp_nw04/helpdata/en/50/0a433ab9fb960ee10000000a11402f/frameset.htm

Also the exmple is not correctly translated in the most up to date documentation.

Heike