View Filter Value DP_VIEW_FILTER and Pass it to multi data providers

[Former Member]

Hi

We are using the following command to view filter values and expand in the dataprovider_1

SAPBWOpenWindow(SAP_BW_URL_Get()"&CMD=PROCESS_HELP_WINDOW&HELP_SERVICE=DP_VIEW_FILTER&DATA_PROVIDER=DATAPROVIDER_1&IOBJNM="iobjnm, "FILTER",800,600);

(got the code from a PDF that showed how to use drop down for to select multiple values)

Is there a way to pass this value to multiple data providers like shown below?

SAPBWOpenWindow(SAP_BW_URL_Get()"&CMD=PROCESS_HELP_WINDOW&HELP_SERVICE=DP_VIEW_FILTER&DATA_PROVIDER=*&MULTI=X&IOBJNM="iobjnm, "FILTER",800,600);

There is a bug in this code and i am not sure how to use the Dataprovider = * and Multi = X!

In dropdown box, i gave affected data providers as all three..

no luck..

Please help. thanks

[former_member189638 · Accepted solution]

Put * and X in single quotes

Try using the folllowing

SAPBWOpenWindow(SAP_BW_URL_Get()"&CMD=PROCESS_HELP_WINDOW&HELP_SERVICE=DP_VIEW_FILTER&DATA_PROVIDER='*'&MULTI='X'&IOBJNM="iobjnm, "FILTER",800,600);

Edited by: Rakesh Pattani on Dec 20, 2007 10:52 AM

[Former Member · Accepted solution]

Hi Rakesh...

Thanks for the response but it didn't help!

Putting single quotes didn't help!

Is there any other way?

Please help!

[former_member189638]

Instead of SAPBWOpenWindow use SAPBWOpenURL

[Former Member]

No Rakesh. SAPBWOpenUrl didn't work!

[Former Member]

Got it..

The right cmd was

SAPBWOpenWindow(SAP_BW_URL_Get() + "&CMD=PROCESS_HELP_WINDOW&HELP_SERVICE=DP_VIEW_FILTER&DATA_PROVIDER=" + dataprov+ "&IOBJNM=" +iobjnm,"FILTER",800,600 + "&SUBCMD=FILTER_SUBMIT&DATA_PROVIDER=*&MULTI=X" );

}