Show Key+Text in Web Item Dropdown (Data Binding Type VARIABLE_SELECTION)

[gregor_kolck]

Dear experts,

I'm using a Web Template in BI 7.02 with a dropdown item with VARIABLE_SELECTION

                <bi:DROPDOWN_ITEM name="DROPDOWN_ITEM_3" designheight="23" designwidth="200" >

                    <bi:DATA_BINDING_TYPE type="CHOICE" value="VARIABLE_SELECTION" >

                        <bi:VARIABLE_SELECTION type="COMPOSITE" >

                            <bi:VAR_NAME value="DPVDBRKST03" text="Kostenstelle" />

                        </bi:VARIABLE_SELECTION>

                    </bi:DATA_BINDING_TYPE>

                </bi:DROPDOWN_ITEM>

The dropdown shows only characteristic key values but not the texts.

How can I populate teh dropdown with key + text?

Best regards

Gregor

[gregor_kolck]

I found a solution:

I changed the standard setting in the infoobject itself to key and text.

Now the variable dropdown shows key+text.

Gregor

[former_member182470]

I have asked couple of times to check the settings in RSD1 t-code. That was the key thing.

[former_member182470]

Hi Gregor,

You have to select "Key and Text" in Display settings of the Char(for which you have created variable) in Query designer. Then your dropdown in WAD will show you both Key+Text.

Regards,

Suman

[gregor_kolck]

Hi Suman,

thats what I expected, too. I have checked this already but it does not work.

When I use an INFO_FIELD_ITEM for this variable it also shows only key and not key + text.

Gregor

[former_member182470]

So you mean to say you have selected key and text in query designer currently.

In WAD 7.0, you just need to select your Variable like below. No custom XML code is required.That's it. It will show Key and text as per the query settings. Close the web template and re-open the template and then execute it.

Hope you have maintained texts for this Char in RSD1 t-code.

[gregor_kolck]

Right, it was not checked in my first post. But I checked it before an now again.

The item is setup as

                <bi:DROPDOWN_ITEM name="DROPDOWN_ITEM_3" designheight="100" designwidth="100" >

                    <bi:DATA_BINDING_TYPE type="CHOICE" value="VARIABLE_SELECTION" >

                        <bi:VARIABLE_SELECTION type="COMPOSITE" >

                            <bi:VAR_NAME value="DPVDBRKST03" text="Kostenstelle" />

                            <bi:LABEL_VISIBLE value="X" />

                        </bi:VARIABLE_SELECTION>

                    </bi:DATA_BINDING_TYPE>

                    <bi:TEXT_MAXLENGTH value="100" />

                    <bi:WIDTH value="100" />

                    <bi:HEIGHT value="100" />

                </bi:DROPDOWN_ITEM>

and shows as

In opposite if I use a dropdown with type CHARACTERISTIC_SELECTION for the same infoobject it is correctly displayed as.

Gregor

[former_member182470]

Anyway, you have achieved it, right. I am able to achieve with my screen shot settings. You may close the thread if the issue is resolved.

[gregor_kolck]

Yes, I achieved it for type CHARACTERISTIC_SELECTION but I need it for VARIABLE_SELECTION.

Gregor

[former_member182470]

Have you set for your variable like this?

Hope you have maintained texts for this Char in RSD1 t-code.

[anshu_lilhori]

Please check if you have maintained long text for that infoobject on which drop down box is created.

As far as i understand Label_Visible picks the long text so check the same.And at BEx level also select long text for that characteristic.

Give it a try and let me know if that works or not.

Regards,

AL

[gregor_kolck]

Hi Ansu,

that was already the case:

- longtexts are maintained

- query is set to key+text for that characteristic

Gregor