Skip to Content
0

webi - merged prompt

Feb 25 at 07:44 PM

60

avatar image

Hi,

I have a WEBI report with 2 tabs, one tab is getting report from BEx 1 Query and second tab is getting report from BEx 2 Query. Now for both the BEx queries i have created prompt in WEBI with description as"Plant". As the prompt description is same they are merged into one single prompt. when i execute the WEBI report, say i pass the plant value as "100" which is present in BEx 1 query but not in BEx 2 query, so i am getting error message

But if i pass values present in both BEx reports then the WEBI report is working fine.

My requirement, when the plant is present in BEx 1 but not in BEx 2 then without throwing error message the second query must give a message as "No data to retrieve".

Thanks.

10 |10000 characters needed characters left characters exceeded

what is the error message?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Shiva Vishnubatla
Feb 26 at 03:26 PM
1

the message appears to be genuine -

you may just need multiple multiple names for the "prompt name" as the content is not exactly the same

Share
10 |10000 characters needed characters left characters exceeded
Lakshminarasimhan N Apr 10 at 08:37 AM
0

Hi All,


Issue resolved. Basically i am combining HANA view with BEx Query and hence we need to maintain master data in "BW" side to overcome this issue. If the data present in HANA view but not in BW then this error popup. One time master data maintenance is the problem solver.

Share
10 |10000 characters needed characters left characters exceeded