we are experimenting with Query Drill in WebI R3. However, we see a strange behavior that I would like to verify with you:
It appears that when drilling in this mode, WebI would refresh ALL queries in a report, not just the one that it adapts for drilling. I make this assumption because drilling get quicker if I remove other queries.
Can anyone confirm this? Do you think there’s a technical reason for that or is BO just “playing it safe” to make sure merged dimension etc. remain in-line? I would find that strange since there is indeed the option to refresh just one particular query, right?
That’s interesting, but you can try a simple experiment to confirm this. Put one cell on your report for each query. In the cell, put the formula: =LastExecutionDate(“NameOfQuery”)
So you can see the last refresh date/time for each query. Then do your query drill and see if all cells update.
Well, like you said, data from one query may be related to data from another query, so I can see some reasoning behind it. But it would be nice to at least have the option to turn it off. However, I’ve never been a big fan of Query Drill, as it adds significant overhead to the database (every click reruns the query(ies)), and it slows down drilling.
(BOB member since 2002-08-08)