Sitemap

Amicuk Programming Answers

Can we toggle the display of Key/Text in Webi prompt?

2015-10-11   Views:2

Advertisement

Gurus, We have a BOBJ 4.0 and BW 7.1 system. We have developed a webi report on top of BW BEx query. We have created 3 variables in BW BEx Query and they appear as prompts in webi. The prompt variables in webi display both the key and text when the l

Gurus,
We have a BOBJ 4.0 and BW 7.1 system. We have developed a webi report on top of BW BEx query. We have created 3 variables in BW BEx Query and they appear as prompts in webi. The prompt variables in webi display both the key and text when the list of values are refreshed. The business wants to see the key first and the text later on the webi prompt. I have tried modifying the BEx query to say just 'Key' or 'Key and Text' but none seems to have any effect on webi.
I have attached the screenshot from our webi prompt which displays all the material text first and the material number (key) next to it. Is there any option of bringing the key first and the text later in the webi prompt? Creating a universe or creating the prompts directly on the webi report is not an option at this time.
Any help is greatly appreciated! Points will be rewarded!
Thanks,
G.

The replay answer
Advertisement
Hi Nirupa,
I am sorry if I wasn't clear in my requirement. The requirement is to have the Key display first and then the text next to it. If you see the attached screenshot, in the highlighted area, we have the text first and then the key next to it.
I tried making many changes to the BEx variable and the BEx Query but this order of text first and key next in the prompts does not seem to change. Is there a way to change this behavior of the webi prompts? Again, all the 3 prompts are created on BEx query designer as variables and there are no variables created on webi.

Go to See the other 7 answers

Can we toggle the display of Key/Text in Webi prompt?

Category:DefaultRelease time:2015-10-11Views:130

Gurus, We have a BOBJ 4.0 and BW 7.1 system. We have developed a webi report on top of BW BEx query. We have created 3 variables in BW BEx Query and they appear as prompts in webi. The prompt variables in webi display both the key and text when the l[More]

Displaying dynamic variable text in WEBi

Category:DefaultRelease time:-0001-11-30Views:130

Hi I would like to populate data to my dashboard using a Webi report. My datasource is BI query. In this query I have two dynamic variable values where the user needs to enter the starting period & ending period If the user enter starting period as [More]

Need to display TEXT in web selection screen

Category:DefaultRelease time:2015-10-11Views:130

HI All, We are working on CRM-BW  modeling. We have one field called "product" which will have key and medium text. We need to display both key + text in web reporting selection screen. When we ran first time text was not showing in web report.[More]

How to influence the text display of key figures in the interarctive DP

Category:DefaultRelease time:2015-10-11Views:130

Hello all, Does anyone know if there is a possibility (BADI, etc.) to change the text display of key figures (not characteristics!) in a planning book/data view? I know that you can define a free text in the data view but still, this is only one fixe[More]

How to Display key/text in default selection screen?

Category:DefaultRelease time:2015-10-11Views:130

HI Gururs, I want to display key/text in variable default selection screen in BI Analyzer in Quality. please give me any suggestions to resolve this. Thanks vadlamudihi, What i have done is in the cube level, in the dimensions i have made specific pr[More]

In BeX only Key is display instead of Text in filter value

Category:DefaultRelease time:2015-10-11Views:130

Hi, Our company migrated from BW 3.0b to BI 7.0 Netweaver 2004s recently. Before the migration, a value in the Filtersection of an executed query in the BEx Analyzer was displayed as text. Now after the migration it always displays the key instead of[More]

Display key in the selection screen and Key & Text in the report

Category:DefaultRelease time:2015-10-11Views:130

Hi, For the infoobject in the query, In the variable selection screen When i want to select any value it should display only key, and in the report i want to display key and text of that infoobject. Is it possible? Thanks RaniHi Display As Here you d[More]

Display Key & Text In Variable Screen

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am having one master data Location having Attribute and Text data loaded. I am using the same Location as a characteristics in my DSO and then in Query . Now, i have create one variable on Location. When i am executing the query , and click[More]

Reg: problem in displaying as key and text

Category:DefaultRelease time:-0001-11-30Views:130

Hi Friends, I have a problem while displaying values for 0profit_ctr. In Development box report working fine. In production it giving problem. ISSUE: I want to display the 0Profit_ctr as key and text format. In development box it showing correct. I c[More]

Query Designer&WAD: Variable search help - Display Key/Text button

Category:DefaultRelease time:-0001-11-30Views:130

Good day. Please, can you write me some solution of my problem. I have the character with hierarchy. In tab "Business Explorer" of character set display as "Text". When i run my query on SAP Portal and enter to search help of character[More]

Web reporting - variable selection should be display as key and description

Category:DefaultRelease time:2015-10-11Views:130

hi experts, Can anybody tell me the solution for my issue. My isssue is , in the web reporting, i have variable company code, i am selecting the company code thru search help. the values for company code is displaying with key.  the new requirement s[More]

Hot
My computer is having problems updating iTunes to 8.1. It would never finish (it just sits there "installing" with one segment on the progress bar left ... for hours and hours). After that, I hit "Stop" and of course its sitting there [More]
Hello, I am having issues creating report datasource in "Windows authentication (integrated) or SharePoint user" in SharePoint 2013. I followed the steps mentioned in the link http://blogs.msdn.com/b/psssql/archive/2014/04/28/sharepoint-adventur [More]
I just this second hooked up my brand new 30" monitor and it is at 2560 x 1600 and I have no dual link wire connected at all. I can't even plug in the Firewire because my Mac Pro Tower had square Firewire plug and not the angled ones this came with. [More]
I designed a form and converted it in to PDF format for printing. The form has some formatting errors and needs to be edited. However attempt to do so results in a message stating that it is a secure documents and can not be edited. This is inspite o [More]
Hi All, Could you any one let me know the process or steps to hide the age in the event text of the iview Reminder of dates. Currently along with Date of Birth the age is shown in with in brackets. I want to hide the age which is shown. I belive this [More]
Hello , We are using GC Release 3.I need to get an alert/message in the OEM Grid console when a database user table(eg: Employee table) get inserted or updated. Is it possible?And then, I need to get an email notification related to this. If anyone d [More]
I have 3 tables. event_table: Unit                 Varchar2, FirstTime          Date, LastTime          Date, SerialNumber     Number, UnitNumber      Number, Acknowledged  Number audit_table: key              Number, userid           Varchar2, Entry [More]
Hi everyone: I have a vertical spry menu as shown below. I was trying to display an image-text(graphic image) when i mouse over for example on "home" or "product" or on any of them. it will be different image for each of them. I tried [More]
Is there a way to stop or cancel the autostart for the the Music Player on the N81? For the most part I do not use it often and to have it running taking CPU cycles as well as RAM is a waste in my opinion. I looked in the manual but maybe I missed so [More]
Hi,       We have a requirement to orchestrate Adobe livecycle process for document distrubution. There should be a recieving node which will be exposed as to be exposed as service on SOAP. THis Node calls the threee distrubution activities (Email, F [More]