Show TOC

Analysis ModeLocate this document in the navigation structure

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 Analyzerdesign 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 theanalysis grid design item. With thenavigation pane and other design items, you can navigate in this grid using thecontext 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 toprecalculate 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