Drop down boxes in WAD

[Former Member]

Hi All,

I have some drop down boxes in my web template the value "All" is display, i donot want that to be displayed so in the webitem properties i checked the option which says Do not Display "ALL Values" Entry but it still shows up in the report any idea what could be done?

[Former Member · Accepted solution]

Hi,

But initially it need to display 'All' the values, or else you need to sepcify which single value to be displayed.

If you have 'Do not display "All Values" Entry' once you choose any value the All value will vanish.

Thank you

Arun

[Former Member]

Hi,

how about using some javascript?

Just insert the following code in the 'HTML' tab and replace 'name_of_your_ddbox' with the name of your drop down box:

<script type="text/javascript">
<!--
function DeleteSelectOption(SelectName, selValue) {
  var sel=document.getElementsByName(SelectName)[0];
  for(var i=0; i < sel.options.length; i++) {
    if( sel.options<i>.value == selValue ) {
      sel.removeChild(sel.options<i>);
    }
  }
}

DeleteSelectOption('name_of_your_ddbox', '!ALL');
//-->
</script>

Regards

Steve

[Former Member]

Hi,

Can you make it 'Master Data table' and try it with proper key values from the Master data table in SE16 for the Infoobject?

Assign points if it helps

Arun

[Former Member]

Hi Shetty,

What is the READ MODE for these Dropdown boxes?If it is "Only values in InfoProvider" you need to provide one of the key values that are available in your cube.

So,find the corresponding key values available in the cube for the first 2 infoobjects.

Only one dropdown can be set? this is not true.Try to find the READ MODE of your dropdown.

Thank you

Arun

[Former Member]

The read mode is blank.

[Former Member]

Hi Shetty,

Don't type what i have given, I have given sample examples.You need to provide the actual value available for those infoobjects in the BW system. Please check in RDS1 for the available entries for infoobject ZIOBJ1, ZIOBJ2 and ZIOBJ3.

If you don't have any key value in the Infoobject and the InfoCube you cannot set this value.You need to load some value into the infoobject or the Infocube.

This is how the dropdown box in HTML view,

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="GET_ITEM"/>

<param name="NAME" value="DROPDOWNBOX_1"/>

<param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_FILTER_DDOWN"/>

<param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>

<param name="BORDER_STYLE" value="NO_BORDER"/>

<param name="IOBJNM" value="ZIOBJ1"/>

<param name="BOOKED_VALUES" value="Q"/>

<param name="NO_REMOVE_FILTER" value="X"/>

ITEM: DROPDOWNBOX_1

</object>

Find the Infoobject name from the parameter "IOBJNM" in your web template.Check for the corresponding Attribute or key values in BW system.

Assign Points

Arun

[Former Member]

Hi Arun,

I did replace them with my own info objects and their key values but still it sets only the last dropdown box.Tried with setting only one drop down at a time and that works fine, seems like it can set only one?

Thank You.

Message was edited by: shetty s

[Former Member]

Hi Shetty,

If you don't find this tables then goto RSD1 transaction in BW system and enter your Infoobject name and display.

Goto --> Master Data TAB --> then find what table you have

Thank you

Arun

[Former Member]

Hi Arun,

Basically Every InfoObject has Key and Text.If you want to check the key value goto Transaction SE16 in your BW system and use the table for Infoobjects as below,

InfoObject ZIOBJ1

/BIC/PZIOBJ1

InfoObject ZIOBJ2

/BIC/PZIOBJ2

InfoObject ZIOBJ3

/BIC/PZIOBJ3

The first field will be the Key value.

Thank you

Arun

[Former Member]

I did that but it set only the last dropdown box

<param name='FILTER_IOBJNM' value='ZIOBJ1'/>

<param name='FILTER_VALUE' value='WON'/>

<param name='FILTER_IOBJNM' value='ZIOBJ2'/>

<param name='FILTER_VALUE' value='LOST'/>

<param name='FILTER_IOBJNM' value='ZIOBJ3'/>

<param name='FILTER_VALUE' value='PROCESS'/>

in this case it only sets the last filter value.

[Former Member]

Hi Shetty,

Provide 6 lines as below,

<param name='FILTER_IOBJNM' value='ZIOBJ1'/>

<param name='FILTER_VALUE' value='WON'/>

<param name='FILTER_IOBJNM' value='ZIOBJ2'/>

<param name='FILTER_VALUE' value='LOST'/>

<param name='FILTER_IOBJNM' value='ZIOBJ3'/>

<param name='FILTER_VALUE' value='PROCESS'/>

The Filter Value is a meaningfull key value for infoobject ZIOBJ1, ZIOBJ2 and ZIBOJ3 available in the Cube and the master data.

Assign Points

Arun

[Former Member]

Hi Arun,

what do u mean by key value?

[Former Member]

Hi Shetty,

You have to put your InfoObject Name the dropdown is using and your Filter Value.

Assign points if it helps.

Arun

[Former Member]

There are 3-4 dropdown boxes and each use a different info object.

[Former Member]

Hi,

In your web template for SET_DATA_PROVIDER add the line 'FILTER_IOBJNM' and 'FILTER_VALUE' so that the dropdown box will be set to this value defautly and the 'All' value will not be displayed if you have selected 'Do not display "All Values" Entry'

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="DATAPROVIDER_1"/>

<param name="QUERY" value="ZTESTQUERY"/>

<param name="INFOCUBE" value="ZCUBET"/>

<param name='FILTER_IOBJNM' value='ZIOBJ1'/>

<param name='FILTER_VALUE' value='WON'/>

DATA_PROVIDER: DATAPROVIDER_1

</object>

Thank you

Arun

[Former Member]

just copy the two lines as it is or replace ZIOBJ1 & WON with my ioobjnm and the value i want but i have like 3-4 combo boxes which map to different info objects and is it not possible to not display all even when it loads for the first time?

Message was edited by: shetty s