How do I add BEx Analyzer to excel?

How do I add BEx Analyzer to excel?

To open the BEX Analyser, from the Start button click All Programs and then select Business Explorer followed by the first option, ‘Analyzer’. This will launch Microsoft Excel and the BEx Analyzer add-in. Click on the Add-in tab to find the BEx Analyzer toolbar.

How do I open BEx Analyzer in Excel?

To start the BEx Analyzer, choose Start→ All Programs → Business Explorer →Analyze. This will open Microsoft Excel with the SAP BEx plugins enabled.

How do you use a BEx Analyzer?

Launch BEx Query Designer in order to define queries. Analyze selected InfoProvider data by navigating interactively within these queries. Navigate and analyze using the context menu or drag and drop.

How do you check for Add-Ins in Excel?

Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears. In the Add-Ins available box, select the check box next to the add-in that you want to activate, and then click OK.

How do I install BEx Analyzer?

Complete Installation SAP GUI 760 and BEx Frontend….start the Front-End Installer from Frontend-DVD:

  1. Extract the SAPGUI 750 Core Frontend-DVD ZIP file.
  2. Run: …\BD_NW_7.0_Presentation_7.50_Comp._2_\PRES1\GUI\WINDOWS\WIN32\SetupAll.exe.
  3. select/install [x] SAP GUI for Windows 7.50 (Compilation 2) [x] Business Explorer.

What is a BEx report?

SAP Business Explorer (SAP BEx) provides you the set of tools to perform reporting, query analysis to support strategic decision. This tool provides a lot of queries and report designing functions. The BEx Report Designer tool can be used to create formatted reports for printing and presentation.

How do I update my BEx Analyzer?

Refresh. You can also control the automatic refreshing of the workbook in the BEx Analyzer. For activating this, navigate to BEx Analyzer → Refresh.

How do I create a new query in BEx Analyzer?

  1. The Business Information Warehouse must contain at least one InfoProvider before you can define a new query. Start the Business Explorer Analyzer.
  2. From the BEx toolbar, choose Open.
  3. Choose Queries.
  4. Choose New.
  5. Select the InfoProvider that has the data on which the query should be based.

How do I create a BEx workbook?

Steps to Create a Workbook: Select File -> New OR click New icon on the toolbar : Step 2: Insert a Query from BEx Query designer into a Workbook: 1. Select the Cell in the worksheet (Here it is B2) at which you want to start your Query embedding.

How do you add disabled add-ins in Excel?


  1. Click the File tab and then click Options. (In Microsoft Excel 2007, click the Microsoft Office Button, and then click Excel Options.)
  2. On the Excel Options window, click Add-Ins.
  3. From the Manage list, select Disabled Items, and then click Go.
  4. Select the check box next to the add-in.
  5. Click Enable.

How do I install SAP analyzer?

3 – (Re)installation steps:

  1. uninstall the Frontend and SAP GUI.
  2. make sure that these folders are deleted:
  3. restart the PC.
  4. start the Front-End Installer from Frontend-DVD:
  5. start the latest SAP GUI patch installer.
  6. start the latest SAP BI Addon patch installer.

How do I access Bex analyzer?

In the previous version of Excel, you access BEx Analyzer as from the start button as follows: 1 Click all programs 2 Select Business Explorer 3 Analyzer, this will launch Microsoft Excel 4 BEx Analyzer 5 Add -ins More

What are the different control types available in Bex analyzer?

You can also add different control types such as, Analysis Grids, Dropdown Boxes and Button in an Excel workbook. The BEx Analyzer provides you two different function modes that can be used for executing OLAP Analysis or to develop interfaces for Query Applications.

How do I use the analysis mode in businessex analyzer?

Business Explorer – Analysis Mode in Analyzer. When BEx analyzer is started, the menu bar and the BEx Analyzer-tool bar is displayed. You can also access the BEx Report Designer and the Web analyzer from BEx analyzer → Tools option. You can open a workbook or a query in the BEx Analyzer toolbar.