Hi All
I am new to BW and true to form in my company have not had huge amounts of training so am trying to "find my feet"!!!! So I apologize if this is a daft question!!!
I have set up a Web Template which includes a drop-down box on a characteristic in my query, I have selected the "Do not display All Values" option on the Dropdown box web item, but when I run my Web Template I always get an item in my dropdown box for "(All)"?????
I have spoken to one of my colleagues (in a different country) and he tells me that he has seen this before and as far as he is concerned it is a bug in BW which we cna do nothing about. Has anybody else seen this problem and fixed it?
It is important to my project because I need to get a different value in the dropdown box to be the default value and it seems to always use "(All)" as the default value (I guess it does some sort of alpha sort and uses the first value as default value? If I can't do anything about the ("All)" appearing - which I find hard to believe - has anybody any idea how I can force a drop-down box to use a specific value as the default value?
Many Thanks
Simon
3 Answers
-
Former MemberPosted on Nov 23, 2004 at 09:33 PMHi Simon Crowder,
There is a good document in SAP marketplace. Hope you have access.
please follow the following link,
http://service.sap.com/bw --> Media library --> HOW TO ... Guides --> Guide list SAP BW3.0B/BW31 Content --> How to use a dropdown box to set variable values.pdf.
ASSIGN POINTS if this is helpfull
arun
Add a comment
-
Posted on Nov 24, 2004 at 03:12 AM
Hi Simon,
U must be carefull in naming object
<select name="select">
.
.
.
</select>
try change name="select" with name="FILTER_VALUE_1"
here sample code with one dropdownbox
<form name="form_1" method="post" action="<SAP_BW_URL DATA_PROVIDER='DATAPROVIDER_1' FILTER_IOBJNM='0REGION'>">
<select name="FILTER_VALUE_1" size="1" style="FONT-SIZE: 8pt">
<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="GENERATE_CAPTION" value=""/>
<param name="IOBJNM" value="0REGION"/>
<param name="ONLY_VALUES" value="X"/>
<param name="TARGET_DATA_PROVIDER_1" value="DATAPROVIDER_1"/>
ITEM: DROPDOWNBOX_1
</object>
</SELECT>
<input type= "submit" value= "Submit" >
</form>
hope this help
supriatna
Add a comment
-
Former MemberPosted on Nov 24, 2004 at 06:55 AM
Hi,
please see note 597042 for further details. All will be displayed if the characteristic is not filtered. So just set a dynamic filter on the characteristic (you can achieve this by creating a view on your query; or you can add the following paramters in WAD to the DataProvider (HTML view)
<param name="FILTER_IOBJNM" value="YourCharacteristic"/>
<param name="FILTER_VALUE" value="YourCharacteristicValue"/>
Heike
Add a comment
Add a comment