We have a BEx Analyzer workbook that consists of about 10 worksheets, each displaying data from a different query. Refreshing the workbook in BEx Analyzer takes a very long time, typically 20 minutes or so. During this refresh process there is very little activity on the BW system itself. Each individual query runs on the web in a few seconds. Aggregates have been built for every query in the workbook.
The workbook's file size has also increased from ~2MB to 15MB as changes are made to the workbook.
Any suggestions on how to improve workbook performance would be helpful.