Question Re: BEx Analyzer Performance Issue in Technology Q&A

BEx Analyzer Performance Issue

Former Member — Thu, 19 Sep 2013 07:10:10 GMT

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 ?

Re: BEx Analyzer Performance Issue

yasemin_kilinc — Thu, 19 Sep 2013 07:29:22 GMT

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...

Re: BEx Analyzer Performance Issue

former_member182470 — Thu, 19 Sep 2013 07:39:05 GMT

Actually BEx Analyzer(Excel version) rendering is taking long time in your case.

Try to connect to Analyzer through RRMX t-code from BW.

Re: BEx Analyzer Performance Issue

Former Member — Thu, 19 Sep 2013 09:03:39 GMT

Hi Suman,

Thanks for your reply but it didn't work. Is there any other suggestion. ?

Regards,

Komik Shah

Re: BEx Analyzer Performance Issue

Former Member — Thu, 19 Sep 2013 09:05:04 GMT

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

Re: BEx Analyzer Performance Issue

MGrob — Thu, 19 Sep 2013 10:52:22 GMT

SAPLogon 7.20 isn't supported anymore since april 13. I recommend you try with SAPLogon 7.30 and patch level4 for BI Addon. It looks like it could be a frontend issue since you don't expirience a performance issue in rsrt.

hope it helps

Martin

Re: BEx Analyzer Performance Issue

yasemin_kilinc — Thu, 19 Sep 2013 11:35:12 GMT

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.