Question Re: Bex Analyzer doesn't work in Technology Q&A

Bex Analyzer doesn't work

Former Member — Tue, 05 Feb 2008 12:24:57 GMT

Hello everyone

Can somebody tell us what we should do for working Bex Analyzer 7.0? We can not open query tool and so on. But Bex Query Designer 7.0 works fine.

We have SAP BW 7.0, SAP NW BI 7.0, Support Package for SAP BW SAPKW 70016

There is information for Bex Query Designer: AddOn 7x. Support Package 3, Revision 519

Thanks for answers. Points are guarantied

Re: Bex Analyzer doesn't work

Former Member — Tue, 05 Feb 2008 12:58:46 GMT

Hi,

When u open BEX Analyzer is it opening in german?If so, u have to apply BI Addon 7.X,Support pack2,patch1.Ask ur basis team to do it for you.We had similar issue and overcame by applying that frontend.let me know if u need further help.

Regards

Chandru

Re: Bex Analyzer doesn't work

Former Member — Tue, 05 Feb 2008 13:07:36 GMT

Hi Svetlana.

If the language is in German you might have forgot to restart the OS after installing the BI frontend or between the installation of the BI frontend and a BI support package.

I would recommend that you uninstall the BI frontend, reinstall the frontend, reboot, install the BI support package, reboot and then open the BEx Analyzer. This worked for us.

Hope it helps.

Stefan

Re: Bex Analyzer doesn't work

Former Member — Tue, 05 Feb 2008 13:58:20 GMT

No, Chandru and Stefan

Language is Russian and English

Maby deal is really in support package. Can you tell me which support package should we install?

Re: Bex Analyzer doesn't work

Former Member — Tue, 05 Feb 2008 14:06:28 GMT

Hi,

you need to apply BI Addon patch 7.1 sp2 MS Excel 2003 Sp2 atleast to work with New BEx Analyzer

Chandru

Re: Bex Analyzer doesn't work

Former Member — Tue, 05 Feb 2008 16:55:39 GMT

Hello,

is there a file Bexanalyser.xla in :

C:\Program Files\Common Files\SAP Shared\BW ?

C:\Program Files\SAP\FrontEnd\Bw ?

Try to execute this file.. is the BEx Analyser working fine now ?

Re: Bex Analyzer doesn't work

pavel_afanasiev — Tue, 05 Feb 2008 19:46:20 GMT

Svetlana,

can you elaborate a little more on what is happening (rather not happening)?

Before installing/reinstalling all the tools, there other things that could be checked.

Does BEx Analyzer open at all?

Are you trying to start it from the Start menu or from the RRMX transaction?

Was it installed in the first place?

If it opens, are you able to connect to the server? Can you open up any workbooks?

bexanalyzer.xla is the component that gets installed in order for the Analyzer to run properly. Do you have the macro setting lowered enough in Excel + have the trust VBA projects enabled? (Macro settings should be set to low security)

thanks

Re: Bex Analyzer doesn't work

Former Member — Sat, 27 Sep 2008 08:21:19 GMT

Patch your MS office with the file through link below:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=1b0bfb35-c252-43cc-8a2a-6a64d6ac4670

I met the same issue recently and fortunately, later I realized a software patch is necessary for MS excel.

Hope it will help.

Re: Bex Analyzer doesn't work

Former Member — Mon, 22 Feb 2010 17:08:38 GMT

Dear All,

I have the same issue.

When I try to run the BeX Analyzer, either from Start->Business Explorer->Analyzer or from RRMX transaction,

I can't open any queries/workbooks and I can see all the icon in German.

The BeX 3.x, instead, works properly.

I have the following environment:

Windows XP with SP2

Office 2007 Pro

Sap GUI 7.10 Level Patch 14

Any suggestion?

Thanks in advance

Alessandro

Re: Bex Analyzer doesn't work

Former Member — Tue, 07 Jun 2016 09:31:00 GMT

Hi Everyone,

I have a similar problem (not able to open Bex analyzer) in my system. In excel 2013,the language i can see in German.also bex analyzer.xla from this location (C:\Program Files (x86)\SAP\Business Explorer\BI) is not getting open.my friend's excel has all icons are enabled.along with,Bex analyzer button is exist in his excel.Please suggest some solution to rectify this issue.

Regards,

Rathi.