BEx Analyzer is an analytical, reporting and design tool embedded in Microsoft Excel. In BEx Analyzer, you can analyze and plan with selected InfoProvider data using the context menu or drag and drop to navigate in queries created in BEx Query Designer.
You can design the interfaces for your queries by inserting design items (controls) such as analysis grids, dropdown boxes and buttons into your Excel workbook. This allows you to transform your workbook into a query application.
BEx Analyzer's functionality is divided into two modes, each with a dedicated toolbar and menu path:
Analysis Mode
Working in analysis mode, you can accomplish the following types of tasks:
You can access analysis mode from either the dedicated analysis toolbar or from the menu in BEx Analyzer.
See also:
Design Mode
Working in design mode, you can accomplish the following types of tasks:
You can access design mode from either the dedicated design toolbar or the menu in BEx Analyzer.
See also:
The graphic below provides an overview of how BEx Analyzer integrates into the Business Explorer Suite:
To start BEx Analyzer, from the Windows Start menu, choose Programs → Business Explorer → Analyzer.