on 07-22-2016 7:33 PM
Hi,
I have a workbook with one analysis connection (RFC) inserted into a tab of the report. The query / connection runs fine outside of the workbook - it returns in a number of seconds. However when embedded into an excel sheet with various formulas in excel the performance is very poor. The workbook is 9gb so it is very large - but there are no performance issues until i try to refresh the connection. I have done some analysis using the profiling statistics and the issue seems to be with the workbook redisplay - it is taking almost 15 mins to format the display in Excel. Has anyone else had this issue previously - i have searched and haven't found a solution.
I'm on analysis version 2.2 SP02 32 bit - with Office 2010 14.0
I have attached the statistics
Any ideas?
Thanks
Brian
Hi Brian,
are you sure, that your workbook is 9GB large? Maybe one of these notes help you:
BR,
Tobias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Brian,
Which client do you use when running it 'outside' of Analysis? If using BEx Web then that would make sense as the BEx Web need to render only enough information for the current page. 9MB is fairly large - as far as I know there is a 10MB limit on workbooks so beware of this.
Have you perhaps set the workbook to discard data before saving? That increases the file size as well - for some obscure reason.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.