SAP Analytics Cloud
I recently got quite some questions about the new Application Design feature in SAP Analytics Cloud, especially its position in relation to SAP Lumira Designer (Design Studio). I understand that all this may raise some questions with SAP BI customers that haven’t hopped on the SAC train yet or are just starting with their orientation on cloud solutions. So let’s bring some clarity here by starting from the beginning.
Application Design is part of the SAP Analytics Cloud platform and gives you the possibility to offer centrally governed analytical applications, created by professional application designers. These applications range from simple dashboards with just a few charts or tables to complex applications with custom layouts and interactivity options created with scripts.
With the option to use custom scripts the applications go a big step further than the SAP Analytics Cloud stories. That’s also why the stories are positioned to be (also) created by business users, while the applications are solely built by application designers. Eventually, the idea is to be able to integrate and combine features coming from the whole SAC platform in applications. For example, an application could visualize a live data source (BI), run a predictive scenario and offer planning capabilities to update data based on this.SAP Analytics Cloud, SAP BusinessObjects Design Studio, SAP Lumira
Gartner just published its legendary Magic Quadrant for Analytics and Business Intelligence Platforms for 2019. It is always interesting to see how the SAP BI offering compares to its competitors. In previous years I’ve been critical on this report, as most of the SAP tools were completely ignored (SAP BusinessObjects BI Platform, Lumira, etc.) and SAP Analytics Cloud was really just getting started. In the 2019 edition the BOBJ stuff is still out, but that is something I can live with as SAP clearly changed its strategy to cloud.
So let’s have a look at the chart. SAP is seen as a visionaire, but with a low ability to execute. The big competitors Microsoft (PowerBI) and Tableau seem to be far ahead, both in vision and execution. The details on SAP are basically a repeat of my good, bad and the ugly write up on SAP Analytics Cloud in 2018. Some quotes from the report:
SAP is a Visionary, its position in the Magic Quadrant being influenced by product limitations and relative weakness in terms of sales and marketing strategy. SAP still does not have the broad market momentum of the Leaders in this market. Its decision to focus on one product is beginning to improve its competitiveness, however. Reference customers for SAP Analytics Cloud report a much improved view of SAP’s viability as a vendor of modern analytics and BI.
SAP Analytics Cloud’s integrated functionality for planning, analytical and predictive capabilities in a unified, single platform is a differentiator. SAP is one of only two vendors in the Magic Quadrant with such an offering.
I can only agree with this. The focus should not be on purely closing the functionality gap with the quadrant leaders, but on offering a more integrated, broader solution.SAP Analytics Cloud
Just a few more days and the year is almost over again, which makes this a perfect time to have a look at what happened in the past 12 months in the world of SAP Analytics Cloud. With all the updates the tool got in 2018 (22 waves!), you’d almost forget that it is just 10 months ago that SAC was pushed forward as the future of BI for SAP. But the question is of course: can it already deliver on this promise? And is it really enterprise ready? So let’s have a look at the state of SAP Analytics Cloud anno 2018. I grouped my observations in a good, bad and ugly manner.
Let’s start with some important signs in addition to the famous strategy blog of February 2018. SAP Analytics Cloud will be turned into the single BI solution for all tooling within SAP. So not only as the front-end solution on top of a SAP BW or HANA system, but it will replace the built-in BI solutions that come with the several cloud solutions SAP has acquired/developed over the years. Think of SuccessFactors, Concur, Fieldglass, Cloud for Customer. This will bring in millions of potential new users. For project Blueberry, which is a future SAP BW4/HANA cloud based offering, SAC will be the BI front-end. For the on-premise tools the future looks pretty sad. They probably will be supported for another decade, but all new innovations will be done in SAC.
I also see that SAC is slowly transitioning from a BI/planning tool into a broad platform that goes further than what the SAP BusinessObjects BI Platform ever delivered. Initially it only hosted the models and stories for reporting and planning, then the boardrooms and predictive scenarios were added as separate objects, and next year we will see applications, Roambi templates and Analysis Office workbooks appearing.
The Analysis Office workbooks are an interesting topic in itself and I regard this as a must have for 2019 to completely get SAC to a full “enterprise ready platform” level. Currently, Analysis Office workbooks can only consume acquired data models in SAC. To make this really work we need support for live BW/HANA models, and the option to store these workbooks on the SAC platform from within the Analysis Office software. This is all on the roadmap for 2019.
In 2018 a lot of generic SAC features were released, for example story bookmarks, offline/live data blending and proper platform usage statistics. Also many more specific features were delivered, for example on BW live connectivity where SAC is now very close to supporting the full spectrum of BEx features. This year brought the universal display hierarchy, support for two BEx structures and support for BEx conditions.
To finish the Good section, SAP is doing a lot to support organizations to manage this new normal of cloud. It will offer so-called test tenants that run a preview of the upcoming wave. This allows customers to check out new features so they are prepared for the actual release.
The BadSAP Analytics Cloud
SAP Analytics Cloud Application Design is expected to be available somewhere at the beginning of 2019, so let’s already have a look at some tips to get you started with this first release.
In case you haven’t heard about Application Design, this is a brand new solution within the SAP Analytics Cloud, which allows you to build your own applications. It makes use of the components that we already know from the BI, Planning and Predictive areas in SAP Analytics Cloud, but lets you use scripts to extend these capabilities. It is basically SAP Lumira Designer in the cloud.
1. Fast scripting
For those familiar with SAP Lumira Designer this one won’t come as a surprise. Also in SAC Application Design you can (and should) use the content assistent (CTRL + SPACE) to help you write scripts. It is fast and prevents mistakes. Just hit CTRL + SPACE and you’ll get a list of possible options.
You can find the SAP Analytics Cloud Application Design API Reference with all options here. Note that – just as in SAP Lumira Designer – you can also use “this“, instead of the name of the object that you are adding a script to. This is fast and flexible, as you can easily reuse the same code without having to adjust the name of the widgets. “me” doesn’t work by the way.
2. Debug with console.log();
With console.log(); you can pass values to the console of the web browser. You can use this to debug your application and see what is happening with your code.
3. Info Panel
The built-in Info Panel contains two tabs: Errors and Reference List. The Errors will show you incorrect scripts and scripts with warnings. You can click the error and immediately go to the script and the line.
4. R Visualization widget
Just as in SAC stories you can use the R Visualization widget in Application Design. Very interesting is the fact that you cannot only use this to visualize a custom R chart, but you can also use the variables that you define in the R script editor in your Application Design scripts. You could for example use R to do some advanced calculations, and display the result through another widget.
5. Get the largest monitor you can
Make sure you got a large monitor when you want to properly work with this tool. I was using my 13″ MacBook Pro, but with these massive panels on all sides there isn’t much space left for the actual application canvas and you don’t want to be scrolling and opening/closing panels all the time.Featured, SAP Analytics Cloud
SAP Analytics Cloud wave 2018.16 finally introduces story bookmarks! We already knew the bookmarking concept from other SAP BI tools like SAP Lumira Designer and Discovery, and even the good old BEx Web Analyzer had the option to store the navigation state of a report. So it’s good to see this now in SAP Analytics Cloud as well.
For those who are not familiar with bookmarks: it basically allows you to store filters settings on a story, without having to create numerous (personal) copies of a story. In the video I take a look at how this now works in SAP Analytics Cloud.
Posted in: SAP Analytics Cloud, Video