I am looking into a problem reported by a user with a Query Context Selection Prompt on a new WEBI report in BO XI environment. The User claims that she never has seen a Query Context Selection prompt in 5.1 environment. I tried everything except removing table joins’ selection, in several contexts in the universe, for disabling the Query Context selection prompt.
I tested the BO XI universe SQL parameter checkbox selected in the Designer with “Allow selection of multiple contexts”, but neither selected nor not selected, it did not make any difference.
BTW, the SQL Parameter with “Multiple SQL statements for each context” has already been selected. In addition, the “Compare_CONTEXT_WITH_JOINS=YES” parameter is already defined.
I also changed the “Reset Context on Refresh” checkbox deselected, but nothing seems to be working.
Does anyone have any idea? Please help! I am clueless.
Your steps so far seem a bit drastic as many of the things you mentioned should be part of your overall strategy and not changed to suit the needs of one report. (You may well be breaking other reports in the process).
Have you had a look at the SQL generated to try to understand what tables are being used and what tables need to be used to specify a particular context?
I would think you should be able to tell a report which context to use, and then save that permanently, or at least until you ever need to change it. It is very annoying for it to ask you every time you run it.
I did see a post that said it does not do that for the end user when they don’t run it in “modify” mode. Is that automatic? or something they set? I would think the Developer should be able to turn that on/off for both modify mode and regular mode.
Am I right in thinking that the idea was the Developer should always have to decide the context while developing, but once in Production, we won’t bother the user with this? How about don’t bother the Developer with it either!
I am probably just missing something. I am not new to Business Objects in general, but definitely new to Webi details. Sorry for any naivete on my part!
(BOB member since 2006-11-23)
(BOB member since 2009-05-08)
(BOB member since 2009-08-28)