Skip to Content
0

Possible to disable merging of prompts (datasource: query BEx)?

Feb 07 at 01:13 PM

46

avatar image

Hi All,
I have a date filter prompt on query BEx used as a data source for WebIntelligence document. When I use this datasource in 2 queries on the same WebIntelligence document the prompts are merged.
If feasible I would like to enter a different value for each query.

Is that feasible ?

(BI Platform 4.2 Support Pack 4 Patch 2)

Best Regards,
MJ

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

4 Answers

Michael Jennings Feb 07 at 03:12 PM
0

Dear Amit,
unfortunately due the structure of qBex We have to use the data filter prompt on Qbex instead of

using WebIntelligence filter prompt applied on Query panel.

Best regard,

MJ

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

then create duplicate BEx query and change the prompt text in the query so that user will get two different prompt.

0
Michael Jennings Feb 07 at 03:14 PM
0

Dear Amit,
unfortunately due the structure of qBex We have to use the data filter prompt on Qbex instead of using WebIntelligence filter prompt applied on Query panel.

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Feb 07 at 01:19 PM
0

Add the prompt filter at webi queries level and keep the prompt text different.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 08 at 02:56 PM
0

Hi,

I also have the same issue:

  • There are two Bex queries already which have to be reused.
  • Both have same prompt text.
  • In WebI I have to put different values for both of the prompts from two queries, but they are merging automatically.

In the Report`s document Summary I found Merge Prompts(BEX Variables) as On.

Is there a way to switch it off??

BO - 4.1 SP5 Patch 6

Share
10 |10000 characters needed characters left characters exceeded