Skip to Content
avatar image
Former Member

Command for Filter and Drilldown According to

Hi,

I have to enhance my context menu.

I want to 'Filter and Drilldown' for characteristic value.

These values should not be part of the command, but determined dynamically.

I tried:

&DATA_PROVIDER=DATAPROVIDER_1&FILTER_IOBJNM=Z9_PROJ__Z9_ASSET&CMD=EXPAND&IOBJNM=Z9_PROJ__Z9_CLSTR

but this does not work..

Has anyone a good suggestion??

Thanks.

Hans.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 20, 2004 at 10:35 AM

    Hi,

    could you please specify your question more precisley. What is the code you're using at the moment? Which command doesn't work? Do you get a javascript error?

    Did you use parameter1 in your menuprocessor like mentioned in

    http://help.sap.com/saphelp_nw04/helpdata/en/a0/0b863be3047e19e10000000a114084/frameset.htm

    Heike

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2004 at 11:13 AM

    Hi Heike,

    thanks for the reply.

    Problems:

    1. Option does not appear in contact menu.

    2. therefore nothing can be executed.

    See code: (java scipt)

    SAPBWAddToMenu("Filter to Cluster","myMenuProcessor","5","CHARACTERISTIC_VALUE","Z9_PROJ__Z9_ASSET","X","TOP","DATAPROVIDER_1","","");

    // Command Processing

    function myMenuProcessor(parameter,cell_type,filter,parameter1,parameter2,item,dataprovider,x,y){

    switch (parameter){

    case "5":

    // Filter Asset and and expand by Cluster

    SAPBWOpenUrl(SAP_BW_URL_Get() + "&CMD=EXPAND&" +

    "DATA_PROVIDER=" + (dataprovider) +

    "&IOBJNM=Z9_PROJ__Z9_CLSTR&IOBJNM_PARENT=Z9_PROJ__Z9_ASSET&FILTER_IOBJNM=Z9_PROJ__Z9_ASSET" +

    "&FILTER_VALUE=" + (CHARACTERISTIC_VALUE) + "&FILTER_NODE_IOBJNM=" + (Z9_PROJ__Z9_ASSET));

    break;

    My aim is to filter from any Z9_PROJ__Z9_ASSET to the relevant Z9_PROJ__Z9_CLSTR.

    Thanks.

    Hans.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      there's one parameter too many.

      it should read

      SAPBWAddToMenu("Filter to Cluster","myMenuProcessor","5","CHARACTERISTIC_VALUE","Z9_PROJ__Z9_ASSET","X","TOP","DATAPROVIDER_1","");

      I've seen that one example in the documentation is wrong. It will be corrected.

      Heike

  • avatar image
    Former Member
    Jul 20, 2004 at 11:40 AM

    Hi Heike,

    thanks!

    The Option is showing on the menu now!

    (but)

    I get a Javascript error: CHARACTERISTIC_VALUE is undefined..

    How can the system determines the char.value?

    Hans.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2004 at 09:20 AM

    Hi Heike,

    I finally solved it!

    The code I used is:

    case "8":

    if (filter=="Z9_PROJ__Z9_ASSET"){

    location.href= SAP_BW_URL_Get() + "&DATA_PROVIDER=DATAPROVIDER_1&CMD=EXPAND&IOBJNM=Z9_PROJ__Z9_CLSTR&PARENT_IOBJNM=Z9_PROJ__Z9_ASSET&FILTER_IOBJNM=Z9_PROJ__Z9_ASSET&FILTER_VALUE=" + (parameter1);}

    break;

    Thanks you very much.

    Hans.

    Add comment
    10|10000 characters needed characters exceeded