I have a query that can come from 1 of 3 contexts, so when I run the report I get the Context prompt popup. Now I don’t want this popup as it is very likely to confuse a user, I just wanted to run the query, which is identical for all 3 contexts.
I’ve found a couple of solutions mentioned:
Add an object into the query that is only in 1 context. However this generally mean hitting a big fact table which will slow the query
Create a new context for the tables of interest, plus and additional derived dummy table. Add a object from dummy table to the query, meaning it will force it to use the new context. This seems a better solution to me.
However I thought of another idea. For the query, go edit the SQL and choose the radio button to use Custom SQL. Don’t make any changes and save this. Run and save report. This seems to override the need to ask for a context.
However I wasn’t 100% happy with the solution so I went to change the query back to use the non-custom sql. I again ran and saved the report. To my surprise I no longer get the Context prompt.
What I would like to know is if anyone else as come across this? My concern is this a BOXI bug, if a very useful bug, that may go away in a future release.
It’s an interesting one, could you please try to modify the report by adding or removing objects and post whether you are getting the Context Dialog box while running the report?
Paul:
Users in Infoview should not see the popup message asking for the context since the report store the last context it was run before it was published. So, it is my understanding.
Are you sure you dont want to take a different path when the users refresh the report next time?
If yes, then go the Properties tab in the Query Panel, scroll down and you’ll see an option to Reset contexts on refresh. Uncheck the check box and it will not pop up the window with list of contexts the next time you refresh the report.
Mohammed:
Thanks, I wasn’t aware of that setting (perhaps since I am new on Webi)…Do you know how to set that setting as a general switch? I visited CMC, but there is none setting that look alike…Not that way for Deski application.
Sorry Mohammed, perhaps I wasn’t too much clear…I was wondering for a general setting on CMC that controls that Webi behavior over Infoview, rather than doing it per report.
On Deski, there is a setting on CMCM that allows or not…to regenerate the SQL statement in each Infoview-Deski run and I think that displays the popup in each run.
It is not an urgent matter, though. Thanks for your reply
I was just discussing this same issue with someone here. It’s the main reason I try to avoid contexts whenever possible. (Yea yea I know… contexts are good… )
But it does confuse users. The only issue I have with that context on refresh option is that the chosen context gets removed if you “Purge all queries”. (Though that might have changed, I’ve never really gone back). Our requirement was that every report opening needed to ask the user prompt info and they did not want any previous data there.
I really wish there was a way to ‘prioritize’ or set a default context, just like you can a prompt. If no default is set, the system will ask the user… otherwise it uses the highest priority context it finds that is valid.
(BOB member since 2010-12-10)
(BOB member since 2004-10-01)
(BOB member since 2010-06-16)
(BOB member since 2010-06-16)
)