Hello BW(BI) gurus,
As far as I know when you run webtemplate with multiple queries in them or do "Refresh All Queries" in workbooks, then these queries are executed <b>sequentially</b>, i.e. one by one.
I can understand why this happens for workbook (Excel just run query in a sequence of embedding taken from "very hidden" sheet). But I cannot understand why it happens to webtemplate, where the whole HTML page generation happens on BW application server.
Would someone like to comment on this?