Technical Articles
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.
Wow very nice finally a path to replace BEx Web!! Looking forward to the further development on this.
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
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
Ingo Hilgefort thanks for the intro! Any plans on making it available for non-BEx sources? Cheers, Dmitry
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
Ingo Hilgefort, any API documentation or reference guide for further / URL Parameters, e.g. specifying filters, mapping variables, etc.? Would be greatly appreciated..
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.
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
The online documentation" link seems to be broken. Can you please make this available again?
I guess it is this one: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/67afbf41f24f4cb48ca7bd72d5e40d94.html
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 Source Browser 2
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.