BEx Analyzer Performance Issue

[Former Member]

Hello Everyone,

Currently We have BI 7.0 installed. We have a BEx query which is running fine in RSRT and executes in 30 seconds for around 50,000 records. If i execute same BEx query in BEx Analyzer than it takes more than 3 minutes to execute the same BEx query. We have MS office 2003.

SAP Logon pad configuration is given below :

Release : 720

File Version : 7200.3.14.1077

Bulid : 1382596

Patch Level : 14

Hot Fix : 1

My BW System configuration is given below

Is it a patch level issue ?

[yasemin_kilinc]

Hi,

Please take a look at SAP Note: 1101143. It is a collective note on performance issues in Analyzer. A reason that comes to my mind is that your macro security settings may be too high. Please check them and look at the note I mention.

Hope it helps

Yasemin...

[Former Member]

Hi Yasemin,

Thanks for your reply. There are so many notes. I will go through specific to BEx analyzer notes. I don't have any macro written for BEx Analyzer.

Regards,

Komik Shah

[yasemin_kilinc]

Hi,

The note I have given is specifid to Bex, and what I say about macros is that your macro security settings in excel may be high. It doesn't matter whether you have macro or not written in analyzer.