Work with Data Analyzer
You have several options to work on your ad-hoc analysis that you started in data analyzer.
You can set filters and variable prompts, work with the table's context menu and use the builder and styling panel to drill-down in your data.
If you want to set filters, click to display the filter line and click beneath the menu bar to choose one of the items. To collapse the filter line, click again . Depending on the amount of filters you have set, the number is displayed directly on the symbol.
Setting Variable Prompts
In SAP BW, prompts are referred to as prompt variables.
If your data source is designed for setting variable prompts, click Edit Prompts in the menu bar to set the variable prompts. When you have set variable prompts, they are displayed in the Information menu under Variables.
Using the Builder Panel
The Builder panel is displayed at the right side of the application. Here you can see the data source of the application and change it if needed. Under Rows and Columns, you see all measures and dimensions that are displayed in the table.
By clicking Swap Axes, you can exchange rows and columns.
By clicking Arrange Totals/Parent Nodes Below, you can set the display of the totals or parent nodes below or above.
By clicking Compact Display, you can show multiple dimensions in the drill down as hierarchy (for SAP BW queries only).
By clicking Suppress Zeros, you can suppress zeros in rows and/or columns (for SAP BW queries only).
In the Available Items area that is displayed on the left hand side of the navigation panel by default, you can see all available items for the data source. Here you can select dimensions and measures and assign them directly to the table's rows or columns by clicking or . To close the available items area, click the button.
You can also drag and drop dimensions from the Available Items panel into the Builder panel.
In the Available Items panel, you can also search for items. Additionally, in the upper right corner of the Available Items area, you can change the items' display between ID and Description as well as their sort order.
You can resize the width of the left side panel for Available Items. This way you can display long dimension names.
Using the Styling Panel
To change the number formatting of your measures, switch to the Styling panel . Here you can find different number formatting options.
Number formatting is not supported for the new model type.
Using the Table's Context Menu
Getting Information about the Data Source
In the Information popup window you can get some general information about the query or view in the General tab like Query name, the Info Provider name and the date of the Last Data Update and the used variables in the Variables tab. Next to Last Data Update you can click the Refresh button to refresh the data. After the refresh the time stamp changes according to the last data update.