Skip to Content
Technical Articles
Author's profile photo Ingo Hilgefort

Data Analyzer – Ad Hoc Query Analysis for BW Queries with SAP Analytics Cloud

Some of you might already have noticed (or even used) the new option on SAP Analytics Cloud and SAP Analytics Cloud, Analytics Designer to provide an Ad Hoc Query Analysis experience to your end-user. Yes – Ad Hoc Query Analysis – similar to the old BEx Web Analyzer.

So lets take a look at how it works and what options are already available today.

 

Launching the Data Analyzer

You have two options to launch the Data Analyzer.

First, you can simply launch the Data Analyzer using a URL:

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

A simple approach would be to copy the URL after you logged in to your SAP Analytics Cloud tenant, and probably the URL ends with view_id=home, so all you have to do is to change the view_id to “dataAnalyzer”.

The ability to add the connection and the data source as URL parameters are optional. In case you decide to leave those elements off the URL, then the Data Analyzer will simply prompt you for the connection and the BW Query name.

The second option is part of SAP Analytics Cloud, Analytics Designer where you can use the following script command to launch the Data Analyzer:

NavigationUtils.openDataAnalyzer()

 

Using the Data Analyzer

One of the big advantages of the Data Analyzer, is simply the fact, that your user doesn’t need to create a model in SAP Analytics Cloud, but instead can simply use the BW Queries as they are and then analyze the information.

So lets use the Data Analyzer now.

In my scenario I use the URL option and I do not pass in a connection or BW query name…

….and because we didn’t provide those details, the first step is that the Data Analyzer will ask us for the connection and the data source name.

After selecting the Connection and selecting the BW Query, I am presented with the table based on the definition of the BW Query.

In my example, the BW Query contains the dimension Customer in the Rows and all the key figures in the columns, which is what the table will show by default.

The ad hoc part comes to life, when the user now opens the Designer options.

Using the option shown as (1) in the screen above will open up the navigation panel – shown on the left hand side (3). Using the Navigation Panel, the user has the ability to choose which dimensions / measures are shown in the Rows or Columns, simply by using the icons next to the dimension / measure name and to use a simple click to either add or remove the dimension from the Rows or Columns .

Shown in the image above as (2), the user has the ability to change the settings for the dimension and for the measure.

For dimensions, the user has the ability to choose between the ID or Description (or both) for the display, and the user can also switch on and also switch between different hierarchies on the fly.

For the Measures, the user quickly can remove a subset of the measures.

And last but for sure not least, with the option shown above as (4) the user has the ability to switch to a different BW query on the fly. The user will be shown the connection dialog and can then choose a different BW query and a list of recently used BW queries is available as well.

 

 

In case your BW Query contains BEx Variables, you also will have the option to set the variable values from the toolbar and your table will always show with a Filter line, so that the user also has the ability to add additional filter values.

 

Summary

  • The Data Analyzer is basically a ready-to-run option, which allows your users to analyze BW queries on the fly.
  • Your users have the option to navigate, analyzer, and filter the data.
  • You have the option to use the URL parameters or use the scripting option in Analytics Designer.
  • The Data Analyzer is tied to a new permission that is required, please see the online documentation for further details.
  • The user doesn’t need a SAP Analytics Cloud model, but instead can use the BW queries direcctly

 

Additional capabilities, such as Bookmarks or Commenting are planned for a future version of the Data Analyzer.

 

In case you would like to find out more, here the link to the online documentation.

Assigned tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Martin Grob
      Martin Grob

      Wow very nice finally a path to replace BEx Web!! Looking forward to the further development on this.

      Author's profile photo Dmitry Kuznetsov
      Dmitry Kuznetsov

      Sorry, Martin, BEx web was long replaced by e.g. DesignStudio Analysis Template.

       

      Now seems like SAC is starting to catch up ?

       


      Dmitry Kuznetsov

      BI Consulting

      Author's profile photo HADAR MAORHI
      HADAR MAORHI

      So ... lets put it like this : finally a path to replace BEx Web without having to buy "Business object"... 

      Plz work on Additional capabilities, such as Bookmarks (MHTML) and sharing etc...

       

      Tnx,

      Hadar

      Author's profile photo Dmitry Kuznetsov
      Dmitry Kuznetsov

      Ingo Hilgefort thanks for the intro! Any plans on making it available for non-BEx sources? Cheers, Dmitry

      Author's profile photo Anup Kulkami
      Anup Kulkami

      The look and feel is too "excel"y.

      Should have options to choose some fancy templates (lumira designer analysis template looks much better).

       

      Tried to play with it but disappointed by the default size of the analysis area. Should capture the full screen by default. Otherwise it's waste of screen area and takes extra clicks to make it full screen.

       

      Additional url parameter ;mode=present helps a bit though 🙂

      -Anup

      Author's profile photo Dmitry Kuznetsov
      Dmitry Kuznetsov

      Ingo Hilgefort, any API  documentation or reference guide for further / URL Parameters, e.g. specifying filters, mapping variables, etc.? Would be greatly appreciated..

      Author's profile photo Leo Frederiksen
      Leo Frederiksen

      Agree, that would be nice. Also the option to use bookmarks so that you don't have to make the same navigations steps again and again.

       

      Author's profile photo Michael Brøndt Kjær
      Michael Brøndt Kjær

      Great with the introduction of bookmark functionality (insights)

      Ingo Hilgefort

      any update Dmitrys question? URL parameters on variables would make the data analyzer a much more powerfull tool.

      This has also been requested by others, eg. https://answers.sap.com/questions/13143444/sac-data-analyzer-url-parameter.html

       

      Author's profile photo Rasmus Koldt Olesen
      Rasmus Koldt Olesen

      The online documentation" link seems to be broken. Can you please make this available again?

      Author's profile photo Bernd Gerlach-de Campos
      Bernd Gerlach-de Campos

      I guess it is this one: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/67afbf41f24f4cb48ca7bd72d5e40d94.html

      Author's profile photo Rene Kragsfeldt
      Rene Kragsfeldt

      Really looking forward to the bookmarking functionality which will make a big difference for the users experience.

      Another welcome feature, when comparing to the BO Lumira Designer “Generic Analysis” Application, is the option to browse for the data source to be analyzed. E.g. we maintain folder structures in both BW (queries) and S/4HANA (CDS views) which is the same users navigate in when using Analysis for Office.

      Data Source Browser

      Data%20Source%20Browser%202

      Data Source Browser 2

      Author's profile photo Avinash Kumar Mavilla
      Avinash Kumar Mavilla

      Hi,

      Can we move the DataAnalyzer which was created in Development to Production using normal SAC transport process?

      Thanks for your Reply.

       

      Best Regards,

      Avinash.