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.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 12 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)

    https://help.sap.com/doc/businessobject_product_guides_sbo42_en_sbo42sp2_webi_user_guide_en_pdf/4.2.2/en-US/sbo42sp2_webi_user_guide_en.pdf

    Add comment
    10|10000 characters needed characters exceeded

    • 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?

  • Feb 08 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 comment
    10|10000 characters needed characters exceeded