Text Elements in BI 7

[Former Member]

Hi,

We currently have a report in BW 3.5 which contains a text element which in turn displays the value of the variable that the user chose in the selection screen of a report.

In BI 7.0 I have found the text item but when I try to display a variable it simply displays the name of the variable and not the contents.

How could I display or at least retrieve the value the user selected in the selection screen? Are there any means of doing so via Javascript?

Thanks in advance,

Ale

[Former Member · Accepted solution]

Thanks for the replies, they were all very useful.

Preetha, do you know how I would get the key to display in the info box instead of the text? I have tried changing the variable in the query to be both key and text but that didn't work.

Any ideas?

Thank you,

Regards,

Ale

[Former Member · Accepted solution]

Hi Ale,

Do you mean that you want to display only value that user enters (its key value). Correct me if i am wrong.

Please provide little more info.

Thanks !

[Former Member · Accepted solution]

Hi Preetha,

That's exactly what I mean

In my case specifically the user would type, for example: 200613. This is the key and it's text form would be "w/e 06 Apr 06". When the value is submitted I get the info box with the value "w/e 06 Apr 06" but I would like it to display the 200613 instead.

Thanks,

Ale

[Former Member · Accepted solution]

Ale for that you need to made the setting in the query itself set in display as key.

[Former Member · Accepted solution]

Ale try this option :

Your variable is based on a characterstic, if that char is not being used in rows then drag it in the free characteristic area. Made its display setting as text. In the template for that information field web item access that variable from the same information provider in which you make that change.

Hope this helps !

[Former Member · Accepted solution]

Preetha,

Thanks for the replies. The variable is a free characteristic already. The issue with changing it to display just the key is that we have a drop down which allows the users to filter by year/week and if we change the char to key then all the values in the drop down become keys.

How can i separate the drop down values from the information value?

Ale

[Former Member · Accepted solution]

Ale then the other solution is that make a similar query to your earlier existing one almost all its copy. Create one more data provider in the template. Set the display of variable to key and make data binding of information web item with this new data provider. Use this data provider only for this informatio web item dont bind it with other items.

Try this hope this solves your problem.

[Former Member]

you can achjive using informationWeb Item.

take look at the below link for details...

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/47/96784226d1d242e10000000a1550b0/content.htm">http://help.sap.com/saphelp_nw04s/helpdata/en/47/96784226d1d242e10000000a1550b0/content.htm</a>

Hope this helps.

Nagesh Ganisetti.

• Assign points if it helps.

[Former Member]

Hi Alessandro,

Are you talking about displaying the user selected value in ouput of web template. If that's the case then u need not to go for javascript just follow below steps:

1. Select Information field item present under advanced web items.

2. Make following settings in it property:

2.1 In internal display check 'Display Static Filter value' and 'Display Variables'.

2.2 Provide a data provider to this item which contains this variable.

2.3 In List of Text elements to Display option select: Static filter as your Text element,

In the list of characterstic of static filter click the little button which will open a popup window from where you can select the variable to display.

Make following settings and use the web item.

Hope this solves your problem.

Thanks !

[Former Member]

Hi Ale,

This can be achived by using Xpath.

This blog might be helpful in developing the code.

/people/prakash.darji/blog/2006/09/22/using-xpath-statements-within-sap-netweaver-2004s-bex-web-application-designer--part-1

thanks