Working with Data Analyzer

The data analyzer is a predefined ready-to-run service for SAP BW queries. It uses SAP BW live connections created in SAP Analytics Cloud. All SAP BW queries can be accessed directly in theSelect Data Source dialog and no additional model is created.

The data analyzer contains a table that is displayed in full screen, a filter area, and a builder panel with navigation capabilities to add and remove dimensions and measures from the table. In addition, you find a menu bar with a Refresh possibility and an Edit Prompts dialog (in case your data source is designed for setting prompts).

Note

Before you can work with the data analyzer, you need to have the corresponding permission. Many standard application roles already include the permission to work with the data analyzer. For further information, contact your application designer and see Granting Permissions for the Data Analyzer.

How to Open the Data Analyzer
You can open the data analyzer in one of the following ways:

  • You can open the data analyzer via the following URL: http://<HOST>:<PORT>/sap/fpa/ui/app.html?tenant=<TENANT_NAME>#;view_id=dataAnalyzer;. The Select Data Source dialog opens where you can choose a SAP BW connection and a data source.

  • You can open the data analyzer directly via URL parameters that specify the SAP BW connection and the query. For parametrization, please specify the following parameters:

    • connection

    • data source name

    Example
    http://<HOST>:<PORT>/sap/fpa/ui/app.html?tenant=<TENANT_NAME>#;view_id=dataAnalyzer;connection=<CONNECTION_NAME>;dataSourceName=<DATA_SOURCE_NAME>
    Note

    It is important that you use dataAnalyzer for view_id:: view_id=dataAnalyzer.

  • You can open the data analyzer by creating an analytic application with the following script in the onInitialization event handler of your application: NavigationUtils.openDataAnalyzer(undefined, undefined, undefined, false);

    We also deliver a sample application that launches the data analyzer. To open this sample application, you have first to import it:

    1. In the main menu of SAP Analytics Cloud, choose Start of the navigation pathBrowse Next navigation step Files Next navigation step Content Network Next navigation step SamplesEnd of the navigation path.

    2. Click the folder SAP Analytic Cloud, Analytic Designer Sample Content to import this content.

    3. After the import, go to Start of the navigation pathBrowse Next navigation step My Files Next navigation step Public Next navigation step Analytic DesignerEnd of the navigation path.

    4. Click the folder Analytic Designer - Data Analyzer.

    5. Click Analytic Designer - Launch Data Analyzer to open the data analyzer.

Note

You can work with only a single SAP BW data source in the data analyzer.

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.
Note

In SAP BW, measures are referred to as keyfigures and dimensions as characteristics.

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

  • By clicking Suppress Zeros, you can suppress zeros in rows and/or columns.

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 query. 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 Table's Context Menu
Setting Filters

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 mlters you have set, the number is displayed directly on the symbol.

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 menu bar to set the variable prompts. When you have set variable prompts, they are displayed in the Information menu under Variables.

Getting Information about the Data Source

In the Information popup window you can get some information about the query like Query name, the Info Provider name and the date of the Last Data Update. 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.

Saving and using Insights
After you have drilled down to the data details according to your needs and analyzed your data, you might want to save this insight. For this, you simply click Start of the navigation pathSave Next navigation step Save AsEnd of the navigation path in the upper left corner of the data analyzer. In the Save Insight dialog select the file location (public or private) for your insight and enter a name and description for it.
Note

An insight represents the displayed data source with filters, the navigation state as well as the presentation state of the table.

To save an insight, you need to have the admin or creator role. You can't save an insight if you are assigned to the viewer role.

To open an existing insight and make changes to the data, select Start of the navigation pathBrowse Next navigation step FilesEnd of the navigation path from the Main Menu and select the folder where you have saved your insight. In the folder, click the respective insight to open it in data analyzer.
Note

In the file repository insights are labeled with the symbol in front of the insight name and can be found under the file type Insight.

To save your changes, click Start of the navigation pathSave Next navigation step Save AsEnd of the navigation path and select the existing name of the insight to overwrite it. Or type in a new name for a new insight.
Note

Changes to existing insights can be made depending on permissions for your user role and for the file repository.

In the folder view you can also share your insight, add it to your favorites or delete it.
Note

For the time being you can share insights by email but you can’t create a custom link.