Loading of Workbook in BEX Analyzer

[Former Member]

Hi,

Loading of workbook in BEx analyzer with prompt of input variables takes very long time. If we have two or three queries attached to a workbook, it is taking longer time than executing the queries using query designer having same input variable.

Is there any way to increase the speed of loading input variable in BEX analyzer?

Thanks.

[Pravender · Accepted solution]

Hi

You can use workbook compression for this. You can compress your workbook while saving to the server. It will be fast when you will load it again.

You can check [http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3414700)ID1599638050DB01470728905059926586End?blog=/pub/wlg/10447]

and OSS Note 1101143.

Edited by: Pravender on Sep 8, 2009 11:15 AM

[Former Member · Accepted solution]

Hi Pravender,

Thanks a lot for the reply!

I tried to find the option of Compression of workbook. The option is disabled and am unable to check that option. How do i enable that option for the workbook.

[Pravender · Accepted solution]

For compression option you need to install Microsoft J#.

you can follow http://www.microsoft.com/downloads/details.aspx?familyid=f72c74b3-ed0e-4af8-ae63-2f0e42501be1&displa... as given in OSS note 1101143.