Question:
I am having trouble getting the SET_CONDITION or SET_EXCEPTION URL command url's to work. Can anyone see what I am doing wrong here?
The results from clicking the link below on the client web page is a round trip to the server with no changes applied to the display -- ie. the condition does not get created.
<A href="<SAP_BW_URL CMD='SET_CONDITION' DATA_PROVIDER='DATAPROVIDER_1' ACTIVE='X' DESCRIPTION='TOP 20 Queries' IOBJNM_I='OTCTQUERY' STRUCTURE_MEMBER_1_I='FE6BA6BC589E4A4FA81AD8602B98B95A' OPERATOR_I='TC' VALUE_LOW_I=20.0 >">CONDITION
</A>
Answer:
I've tried that before and was never able to get it to work. I've been to lazy to tell SAP about it, as it was just some prototype work that I did.
However, there is an ugly work around. My scenario was that I wanted to create a Top N wizard. I would prompt the user for characteristic (ie Customer, Plant, Product Line...), prompt them for which key figure to build the condition on, and the value they wanted for N . On my query, I created a condition for each key figure possibility. In my case, I had 4 (1 for gross sales, 1 for net sales, 1 for profit and 1 for tons shipped). Then, using RSRT, I found the condition ID's for each of these conditions and after some complex javascript, would activate and de-activate the condition ID's and swap the characteristics that were in the drilldown.
If this seems like a solution that would work for you, let me know and I'll provide the javascript code.