Jul 27, 2020 at 01:48 PM

SAP BW Web Report filtering via URL (exclude multiple value)

67 Views

Hi Experts.

Good day !!

As stated in the title, we need to create a filter via URL of SAP BW web report.We come up with the URL below:
http://lsgnajap01.itgna.local:50000/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=ZRD_M01_Q002_T&BI_COMMAND_1-BI_COMMAND_TYPE=SET_SELECTION_STATE&BI_COMMAND_1-TARGET_DATA_PROVIDER_REF_LIST-TARGET_DATA_PROVIDER_REF_1=*&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-CHARACTERISTIC=ZAXLAC&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1-RANGE_SELECTION&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1-RANGE_SELECTION-RANGE_SELECTION_SIGN=EXCLUDING&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1-RANGE_SELECTION-RANGE_SELECTION_OPERATOR-EQUAL_SELECTION_1-MEMBER_NAME=00000000000000561020

Below is the result when we run the report(it works):

Object = ZAXLAC

Excluded Value = 00000000000000561020

However, we are unable to exclude multiple values. With this, we would to to ask what parameter we need to add/change.

Thanks in advance.

Best regards