Working with the 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

    • dataSourceName

    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.