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

Dropdown box All Values

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2004 at 09:33 PM

    Hi 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
    10|10000 characters needed characters exceeded

  • 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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted 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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.