When you navigate a query in analysis mode, you interactively work with the query to generate different views of its data. This allows you to perform OLAP analysis, which helps you to evaluate query results from different perspectives.
After opening a query or inserting a query into a workbook, the distribution of dimensions, including characteristics and key figures or structures, into the rows and columns from the query definition is displayed in the first view of the analysis grid. Using navigation functions such as drilling, filtering, and hierarchy expansion, you can change the query and thereby generate additional views of InfoProvider data.
Most design items provide navigation functions. The two key design items in which you can navigate in analysis mode are the analysis grid and the navigation pane, in which you can navigate in several different ways:
Open the context menu for a particular cell using the secondary mouse button or using the BEx Analyzer menu.
For more information, see:Context Menu for Selected Cell
Using the mouse, drag one cell onto another either within the analysis grid or the navigation pane.
See also:Drag and Drop Functions
The analysis grid and navigation pane may display different types of icons with which you can navigate.
More information:Analysis Grid andNavigation Pane
You can perform the following navigation functions:
In the navigation pane:
In the analysis grid:
More information:Analysis Grid andNavigation Pane
In the context menu you have access to the menu itemsCharacteristic Properties, Key Figure Properties andQuery Properties to change the display and create new views of the data. You can useGoto to jump to documents and targets using the report-report interface, if customized in your query. Finally, if your query is input-ready, you can enter data into input-ready cells to perform planning functions (seeFunctions for Manual Planning).
Additional design items provide specialized navigation functions:
The navigation functions you can perform vary depending on which design item and which kind of cell in the analysis grid or navigation pane you use. SeeAnalysis Grid andNavigation Pane for navigation functions specific to those items.
When you navigate, you can perform the following functions:
More Information: