SAPinsider Q&A on What’s Next with SAP BusinessObjects Design Studio and SAP BusinessObjects Lumira 2.0

Posted by on May 10, 2017

Jeroen and I did another Q&A chat for SAPinsider. This time the topic was the big upcoming  Lumira 2.0 release. As always, we discussed a lot of interesting topics, ranging from the new features and interoperability scenarios, to new licensing setup and migration scenarios.

You can find the chat replay and the transcript here.


Posted in: SAP BusinessObjects Design Studio, SAP Lumira, Webinars

Development Tips for Creating Mobile Apps with SAP BusinessObjects Design Studio and the SAP BusinessObjects BI Platform

Posted by on Mar 5, 2017

My latest article for the BI Expert online magazine is all about creating mobile applications with SAP BusinessObjects Design Studio. The learning objectives are:

  • How to set up the BI platform for mobile applications
  • How to use the SAP BusinessObjects Mobile app
  • Constraints to consider when developing mobile Design Studio apps
  • How to set up a Design Studio template for mobile applications
  • Best practices for designing mobile applications


Development Tips for Creating Mobile Apps with SAP BusinessObjects Design Studio and the SAP BusinessObjects BI Platform

Today’s business users expect their data, reports, and dashboards to be available everywhere, all the time. Not just when they are behind their desks, but also on mobile devices such as mobile phones and tablets. Design Studio and the SAP BusinessObjects BI platform can support this request. However, the way a user interacts with a mobile dashboard differs a lot from using a dashboard on a laptop or desktop computer—the smaller mobile screen means less space for visualizations, filters, buttons, and other components.

Thus, developing mobile applications requires a different approach than developing dashboards for normal desktop usage. This article demonstrates practical best practices on how to achieve this with SAP BusinessObjects Design Studio and the SAP BusinessObjects BI platform.

The Basics: Setting Up the BI Platform and Mobile Applications

You can use the SAP BusinessObjects Mobile app to run Design Studio applications on a mobile device. This is the preferred option, as the app provides a secure and easy way to connect to the BI platform and run Design Studio applications, as well as other BI documents such as Web Intelligence, Crystal Reports, and SAP Lumira documents.

The alternative would be to use a web browser like Safari or Google Chrome on the mobile device to access the BI applications. A big disadvantage to this alternative is that the BI Launchpad interface isn’t responsive to the decreased screen size and appears and functions in the same way as on a desktop browser. This means that users must log on using tiny log-in screens, and must browse to specific documents using the folder structure in the BI Launchpad, which is optimized for use on a big screen with a mouse—in other words, not ideal for mobile phone use with their smaller screens. (I go into more detail about the SAP BusinessObjects Mobile app later in this article, in the “Features of SAP BusinessObjects Mobile Applications” section.)

You can get the full article at BI Expert.

Posted in: SAP BusinessObjects Design Studio

Design Studio 1.x and hierarchies: Not Assigned node filtering

Posted by on Jan 29, 2017

In BW hierarchies, the values that are not assigned to a hierarchy node are gathered under the Not Assigned node. The query output shows this node in the hierarchy on the same level as the top node of the hierarchy. This works the same for all SAP front-end tools that support hierarchies (Design Studio, Analysis for Office, BEx Analyzer, BEx Web Analyzer).

So far so good. Last week I ran into an issue with filtering on these Not Assigned nodes in Design Studio. The option just isn’t available! The whole hierarchy is visible in the filter menu, expect for the Not Assigned node! This happens both in prompt filters and the normal filters via a component (i.e. Dimension Filter or filtering via context-menu on Crosstab).

Filter in BEx Web Analyzer:

Web Analyzer Not Assigned

Display and filter in Design Studio:

Read More

Posted in: Featured, Knowledge sharing, SAP BusinessObjects Design Studio

Relative OpenDocument links

Posted by on Jan 12, 2017

In the BI Platform each document and folder has its own direct Document Link. Via this OpenDocument concept the specific object can be opened instantly, without having to browse through the BI Launchpad. You can find the Document Link by right-clicking a document in BI Launchpad/CMC.

In addition, we can use this link to pass parameters between reports. This video explains how to do this in Design Studio:

Lately I got several questions on using OpenDocument links in Design Studio dashboards in the context of BI landscapes with multiple BI Platform installations, let’s say with separate Development, Test, Production systems. For example, what to do when a Design Studio dashboard needs to link to another dashboard?

If we just use the OpenDocument URL it will always reference to the object on a specific system (i.e. Production), independently of the installation the dashboard is running on. This will definitely lead to issues during development and testing, as the referenced object is on a different environment giving probably some unrelated results, and might even not be available or accessible at all!

The solution is pretty simple, but you just have to know this: Always use relative URLs instead of the full absolute URLs. This relative URL should look like: /BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=<CUID>

So it’s basically the OpenDocument Link without the http://<server>:<port> part. This setup will also reuse a session on the BI Platform, saving login time and platform resources.

Posted in: Knowledge sharing, SAP BusinessObjects BI Platform, SAP BusinessObjects Design Studio

OMG they killed SCN

Posted by on Dec 4, 2016

The new SAP Community (formerly SCN – SAP Community Network) must be one of the biggest cluster fucks of 2016. It seems to meet all the conditions of the definition:

clusterfuck ‎(plural clusterfucks)

  1. (slang, vulgar) A chaotic situation where everything seems to go wrong. It is often caused by incompetencecommunication failure, or a complex environment.

After a few weeks and several hopeful attempts I’ve totally given up on this platform. And I’m apparently not the only one. The problem with the previous SCN was that it was hard to find stuff. But, when you finally found the right spaces it kinda worked as you could easily browse the discussion topics you were interested in and see whether questions are already answered.

My Lumira question from 23 November has now 6 (!!!) views and 0 replies. And there are lots of other Lumira topics with even less views. If I look at the Design Studio area I see the same thing. Most of the topics have max 10 views. On the old SCN this was a very popular space and people were almost fighting to provide help. Oh, and the upvoting feature isn’t used at all.


The main problem is that the new SAP Community lacks any clear structure (yes, there are ‘tags’) and the bizarre thing seems to be that this is by design! I get the feeling that it doesn’t want to be like a classic forum for some unclear reason.

Read More

Posted in: SAP, SAP BusinessObjects Design Studio, SAP Lumira