Skip to Content
0
Jun 04, 2009 at 01:08 PM

BI Command to Set Sorting not functioning

111 Views

I'm putting this BI Command in the url

&BI_COMMAND_2-BI_COMMAND_TYPE=SET_SORTING

&BI_COMMAND_2-TARGET_DATA_PROVIDER_REF=DP_1

&BI_COMMAND_2-TARGET_DATA_PROVIDER_REF_LIST=ORDEREDLIST

&BI_COMMAND_2-CHARACTERISTIC=ZMIKE_OBJ

&BI_COMMAND_2-SORTING_TYPE=SORT_BY_CHARCTERISTIC_MEMBER

&BI_COMMAND_2-SORTING_TYPE-SORT_BY_CHARCTERISTIC_MEMBER-MEMBER_PRESENTATION=KEY

&BI_COMMAND_2-SORTING_TYPE-SORT_BY_CHARCTERISTIC_MEMBER-DIRECTION=ASCENDING

&BI_COMMAND_2-SORTING_TYPE-SORT_BY_CHARCTERISTIC_MEMBER-PRESENTATION_AREA=RESULT_SET

and I'm getting the error message:

The parameter "SORT_BY_CHARCTERISTIC_MEMBER" in the metadata of "CMD" "SET_SORTING is not correctly defined:

<parameterList>

<param name="BI_COMMAND_TYPE" value="SET_SORTING"/>

<param name="CHARACTERISTIC" value="ZMIKE_OBJ"/>

<param name="SORTING_TYPE" value="SORT_BY_CHARCTERISTIC_MEMBER" modification_type="delete_if_value_not_equal">

<param name="SORT_BY_CHARCTERISTIC_MEMBER">

<param name="DIRECTION" value="ASCENDING"/>

<param name="MEMBER_PRESENTATION" value="KEY"/>

<param name="PRESENTATION_AREA" value="RESULT_SET"/>

</param>

</param>

<param name="TARGET_DATA_PROVIDER_REF" value="DP_1"/>

<param name="TARGET_DATA_PROVIDER_REF_LIST" value="ORDEREDLIST"/>

</parameterList>

I have looked at the docs and it looks like this is correct but I must be missing something.

Any ideas where I may be amiss?

Mike