Skip to Content

Merged Prompt in WEBI showing only common values

Hi All,

I am using two universe in Webi report. Both the universes have a common field. On that field I have created an optional prompt in both the universes. When I execute the WEBI report, both the prompts are being merged and is showing as one prompt which is as expected, but the values of the prompt is not bringing all values. It either shows common values from both the universes or shows all the values of the first universe(Query 1) which I have used in WEBI report.

Can someone please let me know how to show all values from both the universes as prompts values.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 12, 2018 at 09:12 AM

    in case of merged prompt "The List of Values displayed by the merged prompt is the list associated with the object in the prompt that has the most display property constraints."

    check attached webi help guide. section 2.26.1 Merged prompts (Page 178)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 08, 2018 at 11:36 AM

    While executing the report after merging the prompts in webi, i do not see data in few sources even if there is data in the backend.

    When I run the report without merging the prompts I can see the data, can you pls help on this?

    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.