Analysis
& Reporting: BEx Analyzer
Use
The BEx Analyzer is the Business Explorer analytical, reporting, and design tool embedded in Microsoft Excel. In the BEx Analyzer, you can analyze and plan with selected InfoProvider data by using the context menu or drag and drop to navigate within queries created in the 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. In this way, you transform your workbook into a query application.
Features
BEx Analyzer’s functionality is divided into two modes, each with a dedicated toolbar and menu path:
● Analysis mode – for executing OLAP analyses on queries
● Design mode – for designing the interface for query applications
Analysis Mode
Working in analysis mode, you can accomplish the following types of tasks:
● Launch the BEx Query Designer in order to define queries
● Analyze selected InfoProvider data by navigating interactively within these queries
● Navigate and analyze via the context menu or via drag and drop
● Perform OLAP functionality such as filtering, drilling, and sorting
● Perform planning functionality
● Precalculate and distribute workbooks with the BEx Broadcaster
● For advanced programming capabilities, embed your own customized VBA programs (Visual Basic for Applications)
● Save workbooks in your favorites or in your role on the server, or locally on your computer
You access analysis mode functionality with its dedicated analysis toolbar or via the BEx Analyzer menu.
More Information:
Design Mode
Working in design mode, you can accomplish the following types of tasks:
● Design the interface for your queries by embedding design items such as the analysis grid, dropdown boxes, radio button groups, and buttons into your Microsoft Excel workbook
● Further customize your workbook with Excel’s formatting and chart functionality
You access design mode functionality using the dedicated design toolbar or the BEx Analyzer menu.
More Information:
■ For general information about the way messages and errors are communicated in the BEx Analyzer, see General Error and Message Handling.
■ For more information about restrictions in the BEx Analyzer, see Restrictions in the BEx Analyzer.
Integration
The following figure provides an overview of how the BEx Analyzer integrates into the Business Explorer Suite:
Activities
To start the BEx Analyzer, from the Windows Start menu, choose Programs → Business Explorer → Analyzer.