When you start the BEx Analyzer, the BEx Analyzer menu and two toolbars are displayed in Microsoft Excel. You access analysis functions using the analysis toolbar (BEx Analysis Toolbox) and the BEx Analyzer menu. All the functions available in the toolbar are also available in the menu.
You can toggle the display of the analysis toolbar in Microsoft Excel by choosing View → Toolbars → BEx Analysis Toolbox.
Open
You can open workbooks or queries in the BEx Analyzer. The Open tool has two submenus. The open option is displayed in the BEx Analyzer menu.
More information:Accessing Data, Opening and Saving Objects in BEx, and The Open Dialog
Save
You can save workbooks or views in the BEx Analyzer, either under existing names or with new names. The Save tool has three submenus, and three save options are displayed in the BEx Analyzer menu:
More information:Save, Opening and Saving Objects in BEx, and The Save Dialog
Refresh / Pause Automatic Refresh
You use this toggle function to control the refresh status (to enable or disable the request of current valid data from the server):
More information:Temporary Pausing of Refreshing
Changing Variable Values
You can change the variable values in your query:
More information:Changing Variable Values
Tools
Using the Tools function and its submenu, you can start other tools from within the BEx Analyzer:
More information:Calling BEx Tools, BEx Query Designer, and Precalculating and Distributing Workbooks
Global Settings
You can configure global settings. These are settings that are applied to the entire application and not just to specific workbooks.
More information:Configuring Global Settings
Context Menu for Selected Cell (Menu Only)
If you cannot use the secondary mouse button, you can access the context menu (with which you can execute OLAP functions, access item properties, or delete items) from the menu:
More information:Context Menu for Selected Cell
Design Toolbar (Menu Only)
The functions that are available in the design toolbar are also available in the BEx Analyzer menu:
More information:Design Functions
Connect / System Information
You can use this toggle function to connect to a system, display system information, and disconnect from a system:
More information:Creating a Connection to a System
About (Menu Only)
You can display the splash screen for the BEx Analyzer:
Application Help (Menu Only)
You can start the SAP Library documentation for the BEx Analyzer: