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

sitNL 2016

Posted by on Nov 27, 2016

Yesterday was the 8th edition of the yearly SAP Inside Track The Netherlands (sitNL). The event was sold-out and even had a waiting list! Wow! Luckily the new location at the Ciber office in Eindhoven was very spacey and I’d say large enough to host even more participants. Also it is only a 20 minute drive – by bike –  for me, so really excellent location (although I missed the free car wash ?).


The BI track had a very interesting and nicely balanced program. Some high-level sessions, some more detailed ones, back-end stuff, front-end stuff, admin stuff. Good stuff.

Highlights for me were the TechEd recap by Ronald Konijnenburg en Sven van Leuken and the demo of 360Suite (skip the slides next time guys, the demo tells the story ?). I also went to the excellent Machine Learning 101 session by Fred Verheul, which reminded me to finally finish the Data Science for Business book I started reading earlier this year.

Below I put some #sitNL tweets as an impression.

Read More

Posted in: Knowledge sharing, SAP

Migrating Analysis for Office workbooks from BW to BI Platform

Posted by on Oct 8, 2016

We are in process of moving a lot of Analysis for Office (AfO) workbooks from a SAP BW environment to the SAP BusinessObjects BI Platform. Besides storing the workbooks on BI Platform, we of course want to use the OLAP connection on the BI Platform to connect to BW, instead of using the direct – locally defined – connection from AfO to BW.

AfO has a nice feature to quickly swap source systems, but it is a bit hidden. We are using Analysis for Office 2.3 by the way.

1. Open the workbook you want to migrate. Make sure your workbook is not connected to the BW system. Display the Design Panel, go to the Components tab and select your workbook. Right-click to Log Off.afo_switch_1

Read More

Posted in: Analysis for Office, Knowledge sharing

SAPinsider Q&A webinar on Design Studio 1.6

Posted by on Mar 20, 2016

Jeroen and I are doing a Q&A webinar on SAP BusinessObjects Design Studio 1.6 hosted by Thursday next week (March 31). This webinar is free and you can already submit your questions at

The chat will start at 10.30AM EDT/3.30PM GMT. If you can’t join us live, there will be a replay/transcript available later.

Update: Replay is available now here.

SAPinsider logo

What’s New in SAP BusinessObjects Design Studio 1.6? Q&A on New Features, Deployment Options, Use Cases, and More

Q&A with Jeroen van der A and Xavier Hacking
Date: Thursday, March 31, 2016
Time: 10:30 AM EDT / 3:30 PM GMT
Duration: 60 minutes

A new release of SAP BusinessObjects Design Studio was announced at the end of last year, and with its many new features and enhancements, it’s being hailed as the most mature tool yet. But what exactly are these new features, and what can they do for your business?

Join our live Q&A with SAP BI experts and BI 2016 speakers Jeroen van der A and Xavier Hacking of Interdobs to find out more about the new capabilities of SAP BusinessObjects Design Studio 1.6, to hear what organizations are doing with it, and to get a rundown of the different deployment options. Whether you are evaluating Design Studio for the first time or looking to upgrade to 1.6, this live Q&A is a chance to hear experts answer your most pressing questions, including:

  • What are the key features in of Design Studio 1.6?
  • What is the preferred deployment option for Design Studio?
  • How does Design Studio 1.6 compare to SAP BusinessObjects Dashboards (Xcelsius)?
  • Can we migrate BEx WAD or Xcelsius reports/dashboards to Design Studio?
  • What are the mobile dashboard options available with this new release?

Sign in and join this live Q&A and post your questions for our panelists!

Posted in: Knowledge sharing, SAP BusinessObjects Design Studio