Skip to Content
0

Merged Prompt in WEBI showing only common values

Jan 12 at 09:00 AM

42

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Jan 12 at 09:12 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you for the details.

0

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?

0
Poojitha Sukumaran Feb 08 at 11:36 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded