Entering content frame

Function documentation Analysis & Reporting: BEx Analyzer Locate the document in its SAP Library structure

Use

BEx Analyzer is Business Explorer's analytical, reporting, and design tool embedded in Microsoft Excel. In BEx Analyzer, you can analyze and plan with selected InfoProvider data by navigating, with the context menu or via drag and drop, within queries created in the BEx Query Designer.

You can also design the interface for your queries by embedding design items such as the analysis grid, dropdown boxes, and buttons into your Excel workbook, thus turning the 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 performing OLAP analysis 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

·        Execute 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.

See also:

Analysis Mode

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 with its dedicated design toolbar or via the BEx Analyzer menu.

See also:

Design Mode

Background documentation

For general information about the way messages and errors are communicated in BEx Analyzer, see General Error and Message Handling.

Integration

The following graphic provides an overview of how BEx Analyzer integrates into the Business Explorer Suite:

This graphic is explained in the accompanying text

Activities

To start BEx Analyzer, from the Windows Start menu, choose Programs ® Business Explorer ® Analyzer.

 

 

Leaving content frame