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

Prompt in WebI Report needs to show Key and Text

Hi,

I'm using the following:

- SAP BI release 701 SP 5

- BO XI 3.1 - Integration Kit for SAP 12.0

How can I define my filter's prompt function so in a WebI report the prompt values show me both Key and Text?

From a BEx query we have generated a universe, which contains filters generated from the BEx variables.

When I run a WebI report straight from the generated universe, my prompt values will show both Key and Text (or Name and Caption if you prefer). This is great functionality for user input.

However, if I modify the universe and I want to reorganize the classes, rename the dimensions or change the filters so the prompt functions contain default values, the functionality of displaying both Key and Text disappears almost every time.

Only the text remains (which comes from the object defined in the [lov] parameter of the prompt).

Does anybody know the right requirements for the dimensions, filters and prompt functions so that when running a WebI report the prompt values show both Key and Text?

Thanks in advance for your reply!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 01:38 PM

    Hi,

    I too got the same issue ,when I run the WEBI(BO 4)i am getting text instead of keys for all the fields .

    Can any one please let me know where is the option to choose key/Text for all the fields in Report .

    I have coosen Key display for all the fields in BEX Query designer but it is showing text in WEBI which is created on BEX query

    Thanks

    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.