How to use SAP Analysis Office with SAP Analytics Cloud

Posted by

In the below video I give a quick run-through of how the use SAP Analysis Office in combination with SAP Analytics Cloud. Not only can we use SAP Analytics Cloud models as a data source in SAP Analysis Office, we can also store the workbooks on SAP Analytics Cloud. Even better, we can open them from there, and make SAP Analysis Office refresh them for us without having to enter user credentials again! As you’ll see, the current integration is still very basic, but hey, we’re getting there. In the video I’m using SAP Analysis Office 2.6, but it should also work with version 2.5.


  1. Create Analysis Office Workbook with SAP Analytics Cloud Model as a data source.
  2. Store Analysis Office Workbook on SAP Analytics Cloud.
  3. Open Analysis Office Workbook from SAP Analytics Cloud.

Coming soon: SAP Lumira, Discovery Edition – The Comprehensive Guide

Posted by

Big news, as I am very happy to announce our newest SAP Press book: SAP Lumira, Discovery Edition – The Comprehensive Guide. For this book I teamed up with my Interdobs colleague Martijn van Foeken (@mfoeken), who is a seasoned SAP BusinessObjects specialist with over 10 years of hands-on experience.

The major SAP Lumira 2 release of last summer brought so many changes and that much new stuff to the toolset, that we decided to not just update the existing “Getting Started with SAP Lumira” book from 2015 (based on SAP Lumira 1.18, ‘member?), but to start all over again. Our book will cover the recent SAP Lumira 2.1 update as well. In the weeks towards the release date, I’ll share some more details on the exact content and what you can expect to learn from this book.

The book will be available at and Amazon, probably by the end of this quarter, in ebook, print and bundled editions.

SAP Lumira, Discovery Edition – The Comprehensive Guide
475 pages, 2018
E-book formats: EPUB, MOBI, PDF, online
ISBN 978-1-4932-1613-0

Read More

5 crazy SAP BI predictions for 2018

Posted by

2017 is over, 2018 is here, so it is time to make some crazy (or maybe not so crazy) predictions for the SAP BI universe this year!

1. SAPcoin

SAP will launch its own cryptocurrency based on the blockchain technology, to simplify transactions between and within organizations that run SAP software. The coin will probably be called SAPcoin, The Walldorf or The Hasso. At the end of 2018, the market capitalization of SAPcoin will be larger than that of SAP itself.

2. SAP Lumira Cloud

In the yearly SAP BI naming shuffle, SAP Analytics Cloud will be renamed once more. After Cloud for Analytics, SAP BusinessObjects Cloud and SAP Analytics Cloud, the new name will now leverage the stronger and more unique Lumira brand. Therefore, the tool will be called SAP Lumira Cloud (at least for the remainder of the year).

3. SAP Lumira Mobile

The three (!!!) mobile BI apps that we currently have (SAP BusinessObjects Mobile, SAP Analytics Cloud Mobile and SAP Roambi) will merge into a single app. Obviously, this app will be called the SAP Lumira Mobile app (at least for this year). Navigation in the app will be based on content from the SAP Analytics Hub, and will support all the document types that the current apps support (Lumira applications and stories, Crystal Reports, Webi, Analytics Cloud and even Xcelsius dashboards). Roambi will disappear as a standalone product, and will be integrated into SAP Analytics Cloud as a (mobile) template provider. Instead of spreadsheets, these templates will use the SAP Analytics Cloud models as a data source. The SAP community decides to call them “Roambies”, to keep this lovely tool in remembrance.

4. Interoperability!

Infinite interoperability! SAP Analysis Office workbooks can be hosted on SAP Analytics Cloud, to eliminate the need for a SAP BusinessObjects BI Platform. This way, long-time SAP BI customers can completely switch to the cloud solution, without completely alienating their beloved Excel users of the finance department. Furthermore, on-premise Lumira applications and stories can use SAP Analytics Cloud models as a datasource, and it will be possible to import a SAP Analytics Cloud story into Lumira Designer as a composite.

5. SAP Community

SAP Community is closed down, and replaced by either a basic, Reddit-like forum with structure, or a third-party starts a completely new SAP community platform that makes sense.

SAP Lumira Discovery 2.1 – New Features Overview

Posted by

SAP Lumira 2.1 is here and comes with a couple of nice new features! In the below video I have a quick look at the added functionality for the SAP Lumira Discovery client tool.

SAP Lumira 2.0 – an introduction

Posted by

The wait is almost over, SAP Lumira will be GA by the end of August 2017! As you probably already know, Lumira 2.0 is the successor of SAP BusinessObjects Design Studio 1.6 and SAP Lumira 1.31. Indeed, both products will be converged in one tool (to rule them all!). I’ll discuss the impact of this, and of course all the other new features in this blog. By the way, for those who understand Dutch, please check for the original post.

A new foundation

The last major release of SAP BusinessObjects Design Studio 1.6 dates back to November 2015. Since then, some service packs have been issued on quite a regular basis, which even contained some new functionality in a few cases. For example, almost all components have now been made m-mode compatible, currency conversion is possible and the generic analysis template has improved considerably.

SAP Lumira 1.31 was launched in June 2016, and since then we have only seen some patches with bug fixes, including running Lumira in combination with BI Platforms that use SSL.

The long time between major releases with new functionality is definitely something we weren’t used to regarding SAP Lumira. The reason behind this is that for Lumira 2.0 a completely new foundation has been laid to keep the tool future-proof. The focus of the development team has been deliberately shifted to Lumira 2.0, with the consequence that the further development of the two existing tools has mostly shut down.

Lumira 2.0 consists of two client tools and a common backend add-on for the BI Platform.The client tools are Lumira Designer (successor of Design Studio 1.6) and Lumira Discovery (successor to SAP Lumira 1.31). Both tools are built on the same code base and use the common file type LUMX. This means that a document created in Lumira Discovery can be opened in Lumira Designer and vice versa.

Before we dive into this scenario, let’s get a have look at both tools first.

Lumira Designer

As mentioned, Lumira Designer is the successor of Design Studio 1.6, and remains within Lumira 2.0 the client tool for developing advanced BI applications and dashboards. It is still the place to build predefined applications, in which scripts can be used for specific functionality.


An important new feature is the Composite. The composite  allows you to develop your own component based on other components. You can then reuse a composite in your applications; even in other applications! An example is a composite of a KPI tile, which consists of a text, a KPI value and a chart. You could reuse such a composite four times in an application, showing for each version the values of another measure.


Read More