Initailize Drop Down Box with first value

[Former Member]

Hi there,

I have created a drop down box for user to select a role to run a dashboard. Instead of displaying "Show All Values" or <blank> as the inital value of the drop down box, I wonder if it is possible to populate the first role value in it?

Hope to have an answer soon. Points will be awarded. Thanks

Heres the XHTML code

<bi:TEXT_ITEM name="TEXT_ITEM_1" designheight="39" designwidth="106" webitem="ZWEB_ROLE_LABEL" >
                                <bi:TEXT_BINDING type="CHOICE" value="TEXT_CONTENT" >
                                    <bi:TEXT_CONTENT />
                                </bi:TEXT_BINDING>
                            </bi:TEXT_ITEM>
                            <bi:DROPDOWN_ITEM name="DROPDOWN_ITEM_1" webitem="ZWEB_ROLES_LIST" designwidth="240" designheight="38" >
                                <bi:WIDTH value="240" />
                                <bi:HEIGHT value="38" />
                                <bi:DATA_BINDING_TYPE type="CHOICE" value="CHARACTERISTIC_SELECTION" >
                                    <bi:CHARACTERISTIC_SELECTION type="COMPOSITE" >
                                        <bi:DATA_PROVIDER_REF value="ROLES" />
                                        <bi:CHARACTERISTIC value="ZROLE" text="User Login Role" />
                                        <bi:ALL_VALUES_ENTRY_INCLUDED value="X" />
                                        <bi:ACTION_WITH_DEFAULT type="CHOICE" value="INSTRUCTION_WITH_DEFAULT" >
                                            <bi:INSTRUCTION_WITH_DEFAULT type="COMPOSITE" >
                                                <bi:EXECUTION_TIME value="AFTER" />
                                                <bi:INSTRUCTION >
                                                    <bi:SET_VARIABLES_STATE >
                                                        <bi:VARIABLE_VALUES type="ORDEREDLIST" >
                                                            <bi:VARIABLE_VALUE type="COMPOSITE" index="1" >
                                                                <bi:VARIABLE_TYPE type="CHOICE" value="SELECTION_BINDING_TYPE" >
                                                                    <bi:SELECTION_BINDING_TYPE type="CHOICE" value="DATA_PROVIDER_CHARACTERISTIC" >
                                                                        <bi:DATA_PROVIDER_CHARACTERISTIC type="COMPOSITE" >
                                                                            <bi:DATA_PROVIDER_REF value="ROLES" />
                                                                            <bi:CHARACTERISTIC value="ZROLE" text="User Login Role" />
                                                                        </bi:DATA_PROVIDER_CHARACTERISTIC>
                                                                    </bi:SELECTION_BINDING_TYPE>
                                                                </bi:VARIABLE_TYPE>
                                                                <bi:VARIABLE value="ZV_ROLE" text="Role (Cust Exit)" />
                                                            </bi:VARIABLE_VALUE>
                                                        </bi:VARIABLE_VALUES>
                                                    </bi:SET_VARIABLES_STATE>
                                                </bi:INSTRUCTION>
                                            </bi:INSTRUCTION_WITH_DEFAULT>
                                        </bi:ACTION_WITH_DEFAULT>
                                    </bi:CHARACTERISTIC_SELECTION>
                                </bi:DATA_BINDING_TYPE>
                            </bi:DROPDOWN_ITEM>

[Former Member · Accepted solution]

To solve this, you need to filter the Drop Down Box characteristic before execution of the web template.

To do this you need to add the filter to the URL:

<b><u>1.- Calling from another Web Template</u></b>

You can add this command in the web template:

<SAP_BW_URL DATA_PROVIDER=’View1’ FILTER_IOBJNM=’0COUNTRY’ FILTER_VALUE=’DE’>

<u><b>2.- Calling Parameterized Web Templates with URL</b></u>

<b><u>Use</u></b>

The URL for calling a Web template is generated by the Web Application Designer. It is possible to copy the URL, and use it again as many times as you like.

A typical URL looks like this:

http://myAppServer:myPort/SAP/BW/BEx?CMD=LDOC&template_id=yourTemplate

The first part of the URL ((http://myAppServer:myPort/SAP/BW/BEx?) calls the BEx service in the SAP Web Application Server in the BW system. The next step is to call the Web template.

The command ‘LDOC’ with the parameters 'TEMPLATE_ID' calls the Web template. The command LDOC requests a new HTML page. The Web template is used to construct this HTML page. The Web application corresponding to the Web template is displayed in the Web Browser.

You parameterize the Web template by adding further parameters to the URL. These parameters are passed on to all data providers and Web items. Parameterizing the URL allows you to filter all the query views according to a particular country or cost center.

<b><u>Examples</u></b>

<b>Filtering all query views according to Germany</b> http://myAppServer:myPort/SAP/BW/BEx?CMD=LDOC&template_id=yourTemplate&FILTER_IOBJNM=0COUNTRY&FILTER...

<b>Filtering all query views according to Germany, 2000</b> http://myAppServer:myPort/SAP/BW/BEx?CMD=LDOC&template_id=yourTemplate&FILTER_IOBJNM_1=0COUNTRY&FILT...

[Former Member · Accepted solution]

Hi there

Thanks for your prompt reply.

We are are accessing this dashboard via iView and we are on BI7.0. If not wrong this solution is only applicable for BW3.X

I believe the solution should be in javascript or xhtml I guess... anyone else have solution for this?

[Former Member · Accepted solution]

This documents explains how change the iView URL to add parameters

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2090414b-cd20-2a10-d594-8de9d146...

http://help.sap.com/saphelp_nw04/helpdata/en/8d/8e0c7e477e4239a7ee288d7846a0bb/content.htm