(DV-2105) BEx Analyzer

BEx Analyzer testing performs tests of excel-based reporting analyses (i.e. last level of reporting), which are created using the BEx Analyzer reporting tool embedded with Microsoft Excel. Data in each workbook is refreshed and downloaded to Validate for comparison.

In this section

Prerequisites for BEx Analyzer testing

  • In Microsoft Excel add the Excel add-in BExAnalyzer.xla. It can be usually found in the folder C:\Program Files (x86)\Common Files\SAP Shared\BW.

            Manage Excel Add-ins

Prerequisites for BEx Analyzer

  • BI 7.X tools (BEx) require a 32-bit version of MS Office (see the SAP note 1995532).
  • For BI add-on 7.X (based 7.40) Support Package 9 use patch 10 or higher (BI740SP09P_910-20012040.EXE available on market place) because of an error in lower versions.

The functionality BEx Analyzer testing is currently by default hidden. If you want to turn it on, please contact us for support.