Analysis Functions 

Use

When you start BEx Analyzer, the BEx Analyzer menu and two toolbars appear in Microsoft Excel. You access analysis functions with the analysis toolbar (BEx Analyzer Analysis) and the BEx Analyzer menu. All functions available on the toolbar are also available on the menu.

You can toggle the display of the analysis toolbar in Microsoft Excel via the menu path View  ® Toolbars  ® BEx Analyzer Analysis.

Features

Open

You can open workbooks or queries in BEx Analyzer. The Open tool has two submenus, and two Open items appear on the BEx Analyzer menu:

·        To open a query, choose Open ® Query from the analysis toolbar, or BEx Analyzer  ® Open Query from the menu.

·        To open a workbook, choose Open ® Workbook from the analysis toolbar, or BEx Analyzer  ® Open Workbook from the menu.

See Open, Opening and Saving Objects in BW, The Open Dialog

Save

You can save workbooks or views in BEx Analyzer, either under existing names or with new names. The Save tool has three submenus, and three Save items appear on the BEx Analyzer menu:

·        To save a workbook, choose Save ® Save Workbook from the analysis toolbar, or BEx Analyzer  ® Save Workbook from the menu.

·        To save a workbook with a new name, choose Save ® Save Workbook As from the analysis toolbar, or BEx Analyzer  ® Save Workbook As from the menu.

·        To save the current navigation state (view) of the data provider assigned to the design item in the currently active cell, choose Save  ® Save View.

See Save, Opening and Saving Objects in BW, The Save Dialog

Refresh / Pause Automatic Refresh

You control the refresh status (to enable or disable the request of current valid data from the server) with the refresh function, which is a toggle function:

·        To enable refresh, requesting the current valid data from the server, choose Refresh from the analysis toolbar, or BEx Analyzer  ® Refresh from the menu.

·        If you have already activated the refresh function and you wish to pause automatic refreshing of current valid data, choose Pause Automatic Refresh from the analysis toolbar, or BEx Analyzer  ® Pause Automatic Refresh from the menu.

See Refresh / Pause Automatic Refresh

Change Variable Values

You can change the variable values in your query:

·        Choose Change Variable Values from the analysis toolbar, or BEx Analyzer  ® Change Variable Values from the menu.

See Changing Variable Values

Tools

You can launch other tools from within BEx Analyzer via the Tools function and its submenu:

·        To launch BEx Query Designer, choose Tools ® Query Designer from the analysis toolbar, or BEx Analyzer  ® Tools  ® Query Designer from the menu.

·        To precalculate and distribute workbooks with the BEx Broadcaster, choose Tools ® Broadcaster from the analysis toolbar, or BEx Analyzer  ® Tools  ® Broadcaster from the menu.

See Tools, Query Design: BEx Query Designer, Precalculating and Distributing Workbooks

Global Settings

You can configure global settings – defaults valid for the whole application rather than for individual workbooks:

·        Choose Global Settings from the analysis toolbar, or BEx Analyzer  ® Global Settings from the menu.

See Global Settings

Context Menu for Selected Cell (menu only)

You can access the context menu – to perform OLAP functionality, access item properties, or delete items – via the menu if you don’t have access to a secondary mouse click:

·        From the menu, choose BEx Analyzer  ® Context Menu for Selected Cell.

See Context Menu for Selected Cell

Design Toolbar (menu only)

The same functions that appear on the design toolbar are available via the BEx Analyzer menu:

·        From the menu, choose BEx Analyzer  ® Design Toolbar, and the submenu item that corresponds to the tool you want.

See Design Functions

Connect / System Information

You can connect to a system, display system information, and disconnect from a system with the connect function, which is a toggle function:

·        To connect to a system, choose Connect from the analysis toolbar, or BEx Analyzer  ® Connect from the menu.

·        If you are already connected and wish to view system information, which also allows you to disconnect from a system, choose System Information from the analysis toolbar, or BEx Analyzer  ® System Information from the menu.

See Connect / System Information

About (menu only)

You can display BEx Analyzer’s splash screen:

·        From the menu, choose BEx Analyzer  ® About

Help (menu only)

You can launch the SAP Library documentation for BEx Analyzer:

·        From the menu, choose BEx Analyzer  ® Help