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]

Thanks. Changing the V to W works.

Now I have another question.

Usually, you can take your SAP_BW_URL parameters and put them in the object tag for the data provider. The result is a default parameterized report.

My SAP_BW_URL is <SAP_BW_URL DATA_PROVIDER='DP' CMD='SORT' SORT_TYPE='W' SORT_DIRECTION='A' STRUCTURE_MEMBER_1='3WWA4FB5R1K1YDEPYWXEHR91A'> which now works perfectly.

I want my report to default to my key figure (total tickets) to being sorted ascending.

So, incorporating the SAP_BW_URL parameters into my object tag, results in...

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="DP"/>

<param name="QUERY" value="ZEIC_7010_TOPCUSTOMER_INTER"/>

<param name="INFOCUBE" value="0SAL_DS01"/>

• <param name='CMD' value='SORT' />

• <param name='SORT_TYPE' value='W'/>

• <param name='SORT_DIRECTION' value='A'/>

• <param name='STRUCTURE_MEMBER_1' value='3WWA4FB5R1K1YDEPYWXEHR91A'/>

<param name='HELP_SERVICE' value='ZPRINTING'/>

<param name='HELP_SERVICE_CLASS' value='Z_PRINT_HELP_SERVICE'/>

DATA_PROVIDER: DP

</object>

I put *'s in front of the revelant parameters.

When I run my report with this code, I get an error "Messages: Error loading item TITLE." in my Internet Exploer browser.

Does anyone know what I'm doing wrong?

Thanks.

[Former Member]

Hi Audrey,

you have now 2 cmd parameters in your Data-Provider-Tag. This is not working of course. Adding commands like this works only for generic commands (like filter) What you need to do: use a command sequence.

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="DP"/>

<param name="QUERY" value="ZEIC_7010_TOPCUSTOMER_INTER"/>

<param name="INFOCUBE" value="0SAL_DS01"/>

<param name='CMD_1' value='CMD=SORT&SORT_TYPE=W&....' />

</object>

Also as I see it just in your template. As possible do not assign the Help-Service to the DataProvider assign it to a web item instead!

Heike

[Former Member]

It worked! Thank you for all your help!