Analysis Mode 

Use

In BEx Analyzer analysis mode, you analyze and plan with selected InfoProvider data by navigating interactively in queries that you have created with BEx Query Designer, and in the interface that you have designed in BEx Analyzer design mode. When you switch to analysis mode, results of your query are displayed in the Excel worksheet according to how you configured your data using design items.

Results of the query are displayed in the analysis grid design item. With the navigation pane and other design items, you can navigate in this grid using the context menu, drag and drop, or icons for sorting or expanding and collapsing hierarchies. When navigating, you execute OLAP functions such as filtering, drilling, and sorting characteristics and key figures in the rows and columns of the analysis grid. If you have defined input-ready queries, you can also enter data in the analysis grid to execute planning functions.

For advanced programming capabilities, you can embed your own customized VBA programs (Visual Basic for Applications) into your workbooks. You can also use BEx Broadcaster to precalculate and distribute workbooks. 

You can save workbooks in your favorites or in your role on the server for someone else to open and work with in analysis mode. You can also save the workbook locally on your computer.

 

Activities

●      Access analysis mode using the dedicated analysis toolbar or the BEx Analyzer menu. More information: Analysis Functions

●      Navigate in analysis mode using either the context menu or drag and drop. More information: Navigating in Analysis Mode

●      Use BEx Broadcaster to precalculate and distribute workbooks. See also: Precalculating and Distributing Workbooks