Skip to Content

BEx Analyzer and Analysis for Office are tools created to visualization of query results. The purpose of these tools are the same, but also share some restrictions and limitations.

One of these limitations is a intermittent issues with unpredictable pattern, when BEx Analyzer is running at same time with third party Add-In on MS Excel.

Same is valid for Analysis for Office.

SAP already documented issues while using Essbase Hyperion, but it could happens with any Add-in installed.

The issue lies when a event is processed by two different add-ins, and this generate a conflict.

If you notice any unexpected behavior (general a pop-up with message error) deactivate all Add-Ins and test again.

For that, close all Excel instances. Start Ms Excel normally.

Click on File – Options – Add-Ins

Access Excel Add-Ins and COM Add-Ins and deactivate all of them, as the picture 1.

Exit from Excel and start BEx Analyzer again. It should works as expected.

ExcelOptions.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Emilio Rojas

    Hi,

    We have the same problem with analysis for office, and even when this addin does not installed in the user pcs, when export any report from BEx BW they have the same problem.

    This problem don’t have another way to be resolve??. Or another way to get out of the way.

    thanks and Regards

     

     

     

    (0) 

Leave a Reply