Launch Data Analyzer and Start Ad-Hoc Analysis

Data analyzer is a predefined ready-to-run service for SAP BW queries, SAP HANA live views and SAP Analytics Cloud models for ad-hoc analysis. It can be accessed by using the side navigation of SAP Analytics Cloud and it enables you to save your drill-down data state and analysis as insight. All SAP BW queries, SAP HANA Live views and models can be accessed directly in the selection dialogs for data source and existing models and no additional model is created.

Data analyzer contains a table, 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 data analyzer, you need to have the corresponding permission. Many standard application roles already include the permission to work with data analyzer. For further information, contact your application designer and see Standard Application Roles.

Opening Data Analyzer and Creating an Ad-Hoc Analysis

  1. To open data analyzer and create a new ad-hoc analysis, go to Data Analyzer in the side navigation of SAP Analytics Cloud. The start page of data analyzer is displayed with the following URL: https://<hostname>/sap/fpa/ui/app.html#/dataanalyzer

  2. On the data analyzer start page, choose one of these options:

    • Start New From a Data Source to create an ad-hoc analysis based on a SAP BW query or SAP HANA live view. For more information, see section Creating an Ad-Hoc Analysis based on a SAP BW Query and Creating an Ad-Hoc Analysis based on a SAP HANA Live View in this chapter.

    • Start New: From an Existing Model to create an ad-hoc analysis based on an existing SAP Analytics Cloud model. For more information, see Creating an Ad-hoc Analysis based on an SAC Analytics Cloud Model.

Note

  • You can work with only a single data source in data analyzer.

  • Once you've opened data analyzer for a new ad-hoc analysis following the two options described above, the URL will get updated containing the data source information, for example in SAP BW Data Analyzerhttps://<hostname>/sap/fpa/ui/app.html#/dataanalyzer&/dz/?connection=BIX&dataSourceName=0BICS_C03_BICSTEST_Q0010

  • When you start a new ad-hoc analysis and leave data analyzer without saving any changes, you won't be asked to save your changes. Only if you open an existing insight, change it and leave without saving, you are asked whether your changes should be saved. Be aware that users with viewer role and without the private insight privilege can open and change insights but can't save the changes.

Besides starting a new ad-hoc analysis from the data analyzer start page, you have also the following possibilities to create an ad-hoc analysis in data analyzer:

  • You can open data analyzer via the URL parameters that specify the connection and the data source name.

  • You can start with opening a saved insight, for example from the Recent Files section on the data analyzer start page or from My Files on the Files start page.

  • As a story user you can open data analyzer from a table via the actions menu item Open Data Analyzer. To be able to use this action menu item, first the data analyzer property has to be enabled by one of following options:

    • enable data analyzer on a table via the builder panel (by checking the property Enable Data Analyzer)

    • enable data analyzer for all tables via the Story Details dialog (by selecting Start of the navigation pathStory Details  Next navigation step  Data Exploration Settings Next navigation step  Enable Data Analyzer for all TablesEnd of the navigation path in the File menu of the story)

    When the action menu item Open Data Analyzer is selected, data analyzer is opened with transferred table information like the following::

    • data source

    • navigation state (dimensions/measures on rows and columns)

    • filters

    • thresholds

    • variables

    Note
    In some cases the Open Data Analyzer action menu item will be disabled:

    • If Optimized View Mode is enabled for the story.

    • If the user does not have the Execute privilege for data analyzer.

    • For more information on other uses cases where this option is not available, see SAP Note 3102823 Information published on SAP site

Creating an Ad-Hoc Analysis based on a SAP BW Query

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.

Specifying connnection Procedure
Starting in data analyzer start page and opening the connection via the Select Data Source dialog.

  1. Open data analyzer from the side navigation panel which brings you to data analyzer start page.

  2. Choose From a Data Source to create an ad-hoc analysis based on a SAP BW query.

  3. The Select Data Source dialog opens where you can choose a SAP BW connection and a query..

  4. Confirm the selection and data analyzer is displayed.

After having chosen the the SAP BW query the URL is updated accordingly.
Starting in data analyzer and opening the connection via the URL parameters that specify the SAP BW connection and the query. For parametrization, please specify the following parameters:

  • connection

  • data source name (that refers to the technical name of the SAP BW) query

Example
Usage with system type parameter https://<hostname>/sap/fpa/ui/app.html?#/dataanalyzer&/dz/?systemType=BW&connection=<connectionName>&dataSourceName=<BWQueryName>
Example
Usage without system type parameter https://<hostname>/sap/fpa/ui/app.html?#/dataanalyzer&/dz/?connection=<connetionName>&dataSourceName=<BWQueryName>
Note

It is important that you use dataanalyzer.

You can open 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);

Creating an Ad-Hoc Analysis based on a SAP HANA Live View

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.

Specifying connnection Procedure
Starting in data analyzer start page and opening the connection via the Select Data Source dialog.

  1. Open data analyzer from the side navigation panel which brings you to data analyzer start page.

  2. Choose From a Data Source to create an ad-hoc analysis based on a SAP HANA live connection.

  3. The Select Data Source dialog opens where you can choose a SAP HANA connection and a data source.

  4. Confirm the selection and data analyzer is displayed.

After having chosen the model the URL is updated accordingly.
Starting in data analyzer and opening the connection via the URL parameters that specify the SAP HANA connection and the view. For parametrization, please specify the following parameters:

  • system type

  • connection

  • data source name (that refers to to the SAP HANA View name and all the associated details required around it such as schema name package name etc)

Example
https://<hostname>/sap/fpa/ui/app.html#dataanalyzer&/dz/?systemType=HANA&connection=<connectionName>&dataSourceName=[<SchemaName>][<PackageName>][<HANAViewName>
Note

  • It is important that you use dataanalyzer.

  • A SAP HANA view ID should follow the format of [<SchemaName>][<PackageName>][<HANAViewName>] where the square brackets are required

  • For [<SchemaName>] enter always [_SYS_BIC] to signify a remote SAP HANA system

Note

You can open 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);

Creating an Ad-hoc Analysis based on an SAC Analytics Cloud Model

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.

Specifying connnection Procedure
Starting in data analyzer start page and opening the connection via the Select Data Set or Model dialog.

  1. Open data analyzer from the side navigation panel which brings you to data analyzer start page.

  2. Choose From an Existing Model to create an ad-hoc analysis based on a model.

  3. The Select Data Set or Model dialog opens where you can search for or open an exsting model in the files folders of your choice..

  4. Confirm the selection and data analyzer is displayed.

After having chosen the model the URL is updated accordingly.
Starting in data analyzer and opening the connection via the URL parameters that specify the SAP Analytics Cloud model connection. For parameterization, please specify the following parameters:

  • system type=MODEL

  • datasourceName: name of the model to load that has 2 formats

    • legacy format of package : model name, for example sap.epm:BestRunJuice_SampleModel

    • standard resourceId, for example CHZOJIBK5943RVTGDX3HR9EDC

Example
https://<hostname>/sap/fpa/ui/app.html#/dataanalyzer&/dz/?systemType=MODEL;datasourceName=<PackageName>:<ModelName>
Example
https://<hostname>/sap/fpa/ui/app.html#/dataanalyzer&/dz/?systemType=MODEL;datasourceName=<resourceId>
Note

It is important that you use dataanalyzer.