SAP Analytics Cloud Add-in for MS Office (beta) – First Look

At the end of 2019 SAP suddenly introduced a completely new addition to the SAP Analytics Cloud suite: SAP Analytics Cloud for Office. I’ve had a quick look at the beta version of this Excel add-in and it – obviously – looks a lot like our good old SAP Analysis Office. Apparently the decision was made to create a new Excel add-in from scratch specifically for SAC.

From what I’ve seen, there are at least two major differences in the foundations of this tool: First, the installation of this SAC for Office is done via the built-in MS Office store. That means that you can easily push this add-in to all Excel installations within your organization. Also think about what this means for the distribution of updates: this is not necessary anymore as the users will always run the latest version of the software from the MS Office store! Second: this add-in not only works within your ‘on-premise’ Excel installation on your Windows laptop, but also in online Office 365 plus – and I’ve waited over 10 years for this – on the Mac! Awesome!!

So check out the video where I show a very minimal demo. As this is just the very first beta, don’t expect much. For live HANA/BW connectivity you still need to use SAP Analysis Office 2.8 for example. Also, there is still no integrated SAC repository option to easily store and open your workbooks on the SAC platform. Looking at the roadmap, the focus for the first half of 2020 is on Planning.

SAP Analytics Cloud 2019 Roundup: the good, the bad and the ugly

Posted by on Dec 29, 2019 in SAP Analytics Cloud | No Comments

2019 is almost over, so just like last year this is a good moment to look back at what happened in the SAP Analytics Cloud universe over the past 12 months. This year we got an astonishing 24 wave releases for the SAC tenants that are on the fast track schedule, so that should be enough to cover! Traditionally, I’ll do the grouping of the roundup in a good, bad and ugly manner.

The Good

This year’s SAP TechEd confirmed the statement from 2018 that SAP Analytics Cloud would eventually turn in to the single BI solution for all the SAP solutions. In Q4 the betas for the first batch of ‘embedded analytics’ started, featuring the new SAP Datawarehouse Cloud, SAP SuccessFactors and SAP Fieldglass. 

The standalone SAC solution is turning more and more into this broad enterprise BI platform which will very soon overhaul the feature set of the on-premise SAP BusinessObjects BI Platform. Let’s go through some of the changes:

Platform administration has made some improvements, for example the simple fact that we can now finally authorize on models by storing them in folders. Sharing settings on these folders also have improved with better inheritance of sharing settings. Also, we can now take the full user administration outside of SAC by mapping accounts, teams and roles to MS Azure AD groups. With this you could setup your SAC tenant in such a way that users only need to go to the SAC URL and automatically an account is created for them and assigned to the correct teams and roles: no more manual admin activities needed in SAC! Finally, there are improvements in the Transport/LCM area, where we now can directly deploy between tenants, without export and importing files. 

Read More

SAP TechEd 2019 Highlights

I went to Las Vegas SAP TechEd 2019 a couple of weeks ago, of course focussing on all the new stuff for SAP Analytics Cloud (SAC) and the brand new SAP Data Warehouse Cloud (DWC). Let’s go through some highlights.

Embedded Analytics

Announced a long time ago already, but now shown for the first time: SAC as a completely integrated reporting and analysis solution with SAP cloud applications. With this it is instantly possible to use SAC on top of the data from the particular tool, with a live connectivity! For example: when using SAP Fieldglass, you can start up the built-in SAC instance and create a model on top of the Fieldglass tables to get data into a story. This new features will be part of the existing license for the cloud application, but only gives access to the BI features of SAC. In case you want to combine data from different sources or use predictive and planning features, you’ll need to switch to the “standalone” version of SAC. The goal is to have live connectors towards all the SAP cloud applications in the standalone SAC, although there were no timelines provided. The cloud offerings that will contain an embedded SAC first are SAP Fieldglass , SAP SuccessFactors and SAP Data Warehouse Cloud.

SAP Analytics Cloud Mobile

The mobile solution for SAC is still lagging far behind the web version. There still is no Android app available (promised for end of 2019), there is no proper integration with the SAP Analytics Hub (Q2 2020) and the Analytics Designer apps don’t work (Q2 2020). On short, we can expect improvements in the areas of live prompts and SSO (no more double logins). SAP has a lot of work to do to catch up, especially as the mobile team has a lot of interesting ideas for future direction: there will be more emphasis on use cases and workflows where the users use the app to answer very specific questions (eventually via speech), instead of just loading and interacting with predefined reports. The vision is that the app would learn form this behavior and offer a timeline and push messages to provide information and insights in a more pro-active way.

SAP Data Warehouse Cloud

TechEd 2019 had a lot of attention for the new DWC, as it was mentioned in almost all sessions, including the keynote. I get the enthusiasm, especially when you combine the potential of this solution with “embedded SAC”, as this could give power users a complete toolset to setup their own mini data warehouse within a governed SAC ecosystem. With its direct (live) connectors to SAP and non-SAP source, a fully web-based cloud environment which is easily maintainable and scalable, and the reporting and analysis feature set of SAC this could be a serious alternative for all those local MS Excel/Access solutions that we still see a lot. The creation of a model in DWC is pretty simple (drag & drop) and does not require SQL knowledge. So in concept it looks great, but also here a lot of work still needs to be done before they can bring this to market.

In conclusion, this was pretty interesting convention and it is absolutely clear that the position of SAC within the full SAP ecosystem is only getting stronger.

Video: SAP Analytics Cloud Data Analyzer [2019.14]

Posted by on Jul 21, 2019 in SAP Analytics Cloud, Video | 2 Comments

SAP Analytics Cloud version 2019.14 introduces a new cool feature: the Data Analyzer. With the Data Analyzer we can instantly report on BEx Queries in SAP Analytics Cloud, without having to create a model first (don’t panic, HANA views are also on the roadmap). For those who have used the Lumira Designer “Generic Analysis Template” or the BEx Web Analyzer this will all look very familiar. So time to check it out in a short video!

Video: SAP Analytics Cloud Application Design – Overview & Filters [2019.4 – preview]

Posted by on Mar 17, 2019 in SAP Analytics Cloud, Video | No Comments

In this video I give an introduction to the upcoming Application Design feature in SAP Analytics Cloud, including several ways to filter a chart using the new App Design widgets and scripts.