Launch Data Analyzer and Start Ad-Hoc Analysis

You can create an ad-hoc analysis based on an SAP BW Live query.

Please ensure the following pre-requisites are met before proceeding: To use an SAP BW query, at least one live connection to a SAP BW system needs to be configured in SAP Analytics Cloud.

You can create an ad-hoc analysis based on an SAP HANA Live view.

Please assure that the following condition is made: To use an SAP HANA Live view, at least one live connection to a SAP HANA Live system needs to be configured in SAP Analytics Cloud.

You can create an ad-hoc analysis based on an SAP Analytics Cloud model. .

Please assure that the following condition is made: To use an SAP Analytics Cloud model analytical dataset, at least one model needs to be available within the file repository configured in SAP Analytics Cloud.

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.

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

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.

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.

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.

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 Save  Save As in the upper left corner of 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. The saved insight does not only appear in the files folder you have saved the insight to but also under the Recent Files section of the data analyzer start page.

Note

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

• If you are assigned to the creator or admin role, you can save an insight in the public or your private files.

• If you are assigned to a viewer role, you can save an insight in your private files only. To do this an administrator can grant the private insight privilege to users with no create rights on the public or private files by creating a custom role and assigning the private insight privilege. With the private insight privilege, these users can also share and delete their insights however they can't overwrite the insight (only save as a new file name) and they can't edit or rename the insight in the file repository. For more information on creating custom roles, please see Create Custom Roles.

After saving an insight, the insight name is displayed in the header of data analyzer. Saving an insight also creates an insight ID that is displayed in the URL, for example, https://<hostname>/sap/fpa/ui/app.html#/dataanalyzer&/dz/1A6006079B878D23EF65D16ACCBB65C4

To open an existing insight and make changes to the data, select Files from the side navigation and select the folder where you have saved your insight. In the folder, click the respective insight to open it in data analyzer. Alternatively, you can open insights who have worked on and saved recently in the Recent Files section on the data analyzer start page.

Note

Insights are labled with the symbol in front of the insight name and can be found under the file type Insight.

To save your changes, click Save  Save As 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.