Skip to Content

webi - merged prompt

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 26 at 03:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 10 at 08:37 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded