Skip to Content
0

WEBI Prompts not merged

Nov 29, 2016 at 09:56 AM

302

avatar image
Former Member

Hi All,

I have 3 queries in my Webi report. 1 from HANA and 2 are bex queries.

All the 3 queries have prompts . Hana has input parameter which is mandatory . Bex prompts are input ready variables and mandatory. All the 3 have same tech name and descripton. I have checked in Document properties "Auto merge Prompts". But the prompts are not merging.

Please help.

When I add the bex query to Webi, I have to enter the value to the prompt as it is a mandatory variable and then add the bex fields to the query. But when I am running the query, the value I am entering in the prompt is not passed to Bex query instead the old value (entered while adding the query) is passed.

Anyone please suggest what could be done to merge the prompts.

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

3 Answers

Jyothirmayee A Nov 29, 2016 at 04:43 PM
0

Hi,

Does the 2 BEx query prompts merged?. Do you see prompts popped up 2 times?.

If you think BEx and HANA prompts render the same data set then edit the query and Click on Set variables and Uncheck the option "Use BEx query defined result values at runtime".

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 29, 2016 at 09:45 PM
0

Hi Jyothi,

Thank you for the response. please find attach webi-prompt.png and Query prompt query-prompt.png. These are the current settings now.

Yes the 2 Bex prompts are merged. I gave in report prompt calmonth as 12.2016 and in the query it is 06.2016. So the result set is bringing 12.2016 data. But I dont want 2 prompts to bring in for the user.

I have tried unchecking "Set as Prompt" in the query. In that i am getting only 1 prompt. but the problem is it is getting the data of 06.2016 and not 12.2016. It means Prompts are not merged.

Dont know where the problem exists.

Please advise.


webi-prompt.png (22.3 kB)
query-prompt.png (16.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
Jyothirmayee A Dec 02, 2016 at 04:48 PM
0

Hi,

Please check the BEx query variable which must have defaulted the value set to 06.2016.

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded