Skip to Content
author's profile photo Former Member
Former Member

Web Functions: 2 FILTER 2 IOBJNM

Posted on Jan 16, 2004 at 08:53 PM 15 Views

I'm trying to apply the solution outlined by Heike Guder, who kindly responded to my previous question several days ago. (Web: Linking Similar Objects)

Can anyone help with the exact syntax to allow simultanious filtering (based on drop-down selection) of two tables which both include cost centre, but with different names, i.e.

0COSTCENTER: Cost center is a characteristic

0COORDER__0RESP_CCTR: Responsible Cost Center is a navigable attribute of Order

Here is one of very many combinations I have tried...

<SAP_BW_URL MULTI='X'

DATA_PROVIDER_1='ORDERVIEW' FILTER_IOBJNM_1='0COORDER__0RESP_CCTR'

DATA_PROVIDER_2='COSTCENTREVIEW' FILTER_IOBJNM_2='0COSTCENTER'>

Any suggestions greatly appreciated,

Rob

BW Business Explorer (SAP BEx)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2004 at 10:36 AM

    Hi Robert,

    your URL should somehow look like: (This is an example solution)

    You can't use DATA_PROVIDER_1, DATA_PROVIDER_2 in your URL.

    Please also make sure, that when you use FILTER_IOBJNM_2 you also need FILTER_VALUE_2.

    I think the best option is solution one using a command sequence (as option 2 will filter all dataproviders; and not just the 2 specified). You probably need some javascript-Coding, as you need to use the same filter value in 2 different places. When you use a drop-Down-Box implement an onchange-Javascript function. Read the new selected value and post the correct url.

    Regards

          Heike

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jan 20, 2004 at 09:52 AM

      Thanks agian Heike.

      It does seem that JavaScript may be necessary; and someone on SAPFANS kindly provided it. Anybody (with 0CCA_C11 and 0OPA_C11 activated) wishing to apply this solution just needs to copy the following code into the HTML tab of the Web Application Designer, and modify the query names.

      _________________________________________________________________