Skip to Content
0
Former Member
Feb 12, 2010 at 03:53 AM

Poor performance when refreshing BEx Analyzer workbook

32 Views

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.

Thanks,

Jason Kraft