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 explore in your data.

Adding Filters

You can add filters to focus on details in your analysis.

If you want to add filters, click (Add Filter) to choose one of the listed items. In the Set Filter dialog you can add filters according to your needs: You can add filters for dimensions and filter by member or by range. After you have added filters, the filter tokens are displayed next to (Add Filter). By clicking (Delete Filter) you can easily remove the filter.

In the Settings section you can globally turn on the Cascading Filter Behavior for all dimensions added to the filter line.
  • With Always cascade members turned on, only members that are relevant in the current filter context will be available for selection in the filter dialog.
  • With Default turned on, you can switch back to the default dimension setting.

    • for SAP BW data sources the default is the setting in the SAP BW query.

    • for SAP HANA data sources, the default setting is “booked”.

You can individually change the cascading behavior of a single dimension in the Set Filter for <your item> dialog. This turns off the global setting within the filter line

Setting Variable Prompts

Note

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 toolbar bar to set the variable prompts.

Using the Builder Panel and the Available Objects List

The Builder panel is displayed at the right side of the application. Under Rows and Columns, you see all measures and dimensions that are displayed in the table. In the Available Objects panel that is displayed next to the Builder Panel by default, all available measures and dimensions of the data source are displayed. Here you can select dimensions and assign them directly to the table's rows or columns by clicking or or dragging and dropping dimensions or measures from the Available Objects to the Builder panel. For displaying more measures in the table, you can check the measures in the list or uncheck them if you want to remove them from the table. To remove dimensions or measures from the Builder panel and from the table, click (Remove) behind the dimension.

For the Rows and Columns, you are offered a context menu that you can open by clicking (More). Here you can use the following functions:

  • By clicking Swap Axes, you can exchange rows and columns.

  • By clicking Totals Position, you ou can set the display of the totals.

  • By clicking Arrange Parent Nodes, you can set the position of the parent nodes.

  • 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).

Each dimension in the Builder panel also has a context menu that you can open and use by clicking behind the according dimension.

In the Available Objects panel, you can also search for objects. Additionally, in the upper right corner of the Available Objects panel, you can change the objects' display as well as their sort order.

You can resize the width of the left side panel for Available Objects. This way you can display long dimension and long measure names.

In the Builder panel you can also switch the visualization of your data from table to chart by choosing a chart type in the dropdown box at the top of the panel. Each chart type offers a specific set of settings that you can change. The following chart types are availabe:

  • bar/column

  • line

  • pie

  • donut

Note

The data visualization switch is only supported for SAP BW live and SAP HANA live connections as well as for SAP Datasphere models.

Using the Styling Panel

In the Styling panel you can use the Default or Basic template as styling option for your table and switch on Alternating Rows. To change the number formatting of your measures, you find different number formatting options like Scale, Scale Format, Decimal Places, and so on.

For SAP BW data sources you can set the position of the Display Scale/Currencies/Unit in the Styling panel.

Using the Table's Context Menu

Depending on the context menu of a measure or dimension, you are offered different options:

  • filter member

  • filter

  • exclcude member

  • sort options

  • table functions

    • select conversions

    • freeze with various options

    • swap axsis

    • show/hide with various options

    • full screen

  • create top N

Additional Options: Create New and Show Information about the Data Source

In the Additional Options menu of the toolbar you can use the following items.

  • By clicking Create New... you can create a new ad-hoc analysis with a new data source.

  • By clicking Show Information... in the dropdown, you can get some general information about the query or view and the date of the Last Data Update.

Undo, Redo and Reset

You can use the toolbar menus Undo, Redo and Reset in data analyzer. These menu functions support all actions that manipulate the data source in the table (like for example sorting, swap axis and more) . They do not support table styling settings and general appearance settings of user interface elements.

Auto Refresh

With the toolbar menu Auto Refresh you can set the auto refresh of the data.