SAP Lumira designer

by Arwold Koelewijn on June 15, 2020

SAP Lumira designer, the successor of SAP Design Studio, is on the market and in use for more than 2 years now. I have been using it for a while as well, and this is the tool I have been waiting for, ever since Design Studio came on the market. If you are looking to build a BI application, I don’t think there is a better tool. Especially on a SAP BW datawarehouse. there is so much possible with just the standard functionality! In this blog I want to focus on the positives and will write about the three best things I like.  As with everything, there are also some negatives, but I will save that for another time.

Number 1: Composites

With composites it is possible to make small building blocks, with a certain look and feel and functionality, and then use them as many times as you need to build up a full application. So in short, with composites, everything is possible. I learned a lot from this blog but there are many more with valuable insights. I have been using composites in the template report for a BI application, which helps to maintain the application easier. But it comes really into the spotlight when you can build custom made visuals based on just the data and programming logic. Also when used for a more operational type report with a lot of different panels and elements, it is really amazing to see the simplicity in coding you can achieve for so many complex operations. I made one of those operational reports, which had a sibling in Design Studio, and the way to build it is so much more cleaner, understandable and flexible. I really love this functionality.

Number 2: Bookmarking

One of the best liked features of the SAP BEx and SAP Design Studio tooling has always been to possibility of bookmarking. With bookmarking it is possible to capture the selections and navigation state in a report, save and use it for later purpose. For example for a monthly repeating report, users can just use the bookmark which had the settings and selections they liked, and refresh the data. In a way this is a kind of self service BI, hence it’s popularity. Bookmarks made by a user could be shared by sending an email with the bookmark link. In this new version, it is possible to build an application that shows all the available bookmarks there are, for a user, for the specific report or for certain groups. And it is possible to make ‘public’ bookmarks, which are automatically available for all users of the report they are related to. This makes it a lot easier for users to create and share specific states of a report. For users this functionality is the main reason why they are willing to do a conversion from Design Studio to Lumira Designer.

Number 3: Action sheet

With the action sheet component it is possible to create a nice menu item list that is linked to other components. It’s typical use is to have a menu area with action sheets linked to the icons. I think this is a nice component that is a user-friendly way of showing several menu items.

Honorable mention: Comment function

With the comment functionality It is possible to make context related notes, either for public or private usage. For example, a user can make a private reminder connected to a number which raises questions, or can make a public note about the same number with an explication why the number raises questions. This is a promising functionality, and although I have not implemented it fully, users respond well to the demonstrations.

To summarize: Lumira designer is the best tool for building a scripted BI application on a SAP BW datawarehouse.

BI Summit 2019 Dutch Universities

November 3, 2019

T his year the BI Summit of the Dutch universities was held at the TUE (13 th September 2019). This was already the third edition, and it seems that every year it is growing in size and becoming more professional. There were a lot of interesting presentations and in this blog I would like to […]

Read the full article →

Modern SAP BI solutions – is it time to upgrade?

September 19, 2019

Last week I attended a SAP BI meeting hosted by the University of Utrecht, concerning the direction SAP is going with the BI solutions BW4HANA and SAC (SAP Analytics Cloud). BW4HANA The BW4HANA suite has a lot to offer and looks really promising. However, since the current BWonHANA systems are also pretty complete datawarehousing suites, […]

Read the full article →

Tangible benefits of a good datawarehouse – part 2

December 19, 2018

T he benefits of a datawarehouse are not easily quantifiable. Therefore I like to point them out when there is an opportunity, see also Tangible benefits of a good datawarehouse. Last week the UvA received a positive quality assessment of the NVAO (the accreditation organization tasked with providing an expert and objective assessment of the […]

Read the full article →


November 24, 2018

One of the topics that is getting more attention lately is ‘Robotics Process Automation’ (RPA). At Tacstone we build a new proposition on this service. In essence this is a new software service that allows to automate processes, without having to modify the existing software systems. The software can logon, simulate keyboard- and mouse input, […]

Read the full article →

Scrum please!

April 20, 2018

Last week I had the pleasure of attending a Scrum Master training, given by Zilverline. I have to admit, I was skeptical at first about Scrum. I am a trained Prince2 Practitioner, so I figured, this is probably “just old wine in new bags”, as we say in Holland. And in a way that is […]

Read the full article →

Enterprise deep learning with TensorFlow

December 9, 2017

An interesting course offered by openSAP is Enterprise deep learning with TensorFlow, which is currently running in its last week. I found this a great insight in the current state of machine learning possibilities. It was a very hands-on training where it was possible to play with TensorFlow Applications, an open-source library for numerical computation. […]

Read the full article →

Getting Started with Data Science

October 8, 2017

O n March this year I enrolled in the open sap course ‘Getting Started with Data Science’. It was a great insight in the business value a data scientist can have and how SAP can make their life easier. Some elements I like to point out. Project methodology What I really liked in the course […]

Read the full article →

SAP Lumira and Tableau compared

August 3, 2017

SAP Lumira and Tableau are both data visualization tools that can be used to explore data. Recently I did small projects in both tools, so I am finally able to make a comparison. Tableau Based on my experience of working with Tableau (version 10.3) I found that the tool is amazingly rich. There is great […]

Read the full article →

HERUG 2017

May 16, 2017

Last month (April 2017) I had the pleasure to attend the Higher Education & Research User Group (HERUG) conference in Amsterdam. I was also an presenter at two sessions. On Tuesday I was presenting together with Pieter-Jan Aartsen of the UvA about the project we did with the implementation of the IMR. Partly this has […]

Read the full article →

Integration of SAP Lumira in an existing environment

March 15, 2017

SAP Lumira is a great tool with a lot of possibilities. However, when it comes to the integration in an existing environment, there remain a few inconveniences. Imagine an existing environment where several connected applications have been built with SAP Design Studio, based on SAP BW, which is reached through a SAP Netweaver portal, using […]

Read the full article →

International Business Communication Standards: first baby steps

October 23, 2016

This week I brought a report live that uses the International Business Communication Standards (IBCS) as the guideline in presenting information. Although this report can only be considered as a small baby step, still the benefits of using standards are clear. In the begin of this year I was at the book launch of the […]

Read the full article →

SAP BW/4HANA – the next step towards simplicity

September 9, 2016

Last month SAP has announced the next generation of SAP Business Warehouse, BW/4HANA. This logical step in the evolution of the Business Warehouse is completely dedicated to the HANA platform, and as such, can do without millions lines of coding to support other databases. Also, it has unloaded the heritage of previous SAP BW versions […]

Read the full article →