Skip to Content
Author's profile photo Tammy Powlas

SAP Design Studio for Dashboards on BW & Hana – Moving from Traditional Dashboards to BI Applications

Yesterday Andreas Krause, SAP EMEA BI Centre of Excellence,  gave a webcast on SAP Design Studio, describing it as the “new tool for dashboarding on top of SAP BW & Hana”


Figure 1: Source: SAP

Where does Design Studio fit in?  Figure one shows the high level areas.  On the right is Reporting, which has a fixed layout, highly formatted information, combination of the look and feel

On the left side there is Discovery and Analysis which is all about the data, trends, detect outliers, format of data is third priority

In the middle is Dashboards & Apps, where Design Studio, which offers a mix of formattingand ability to interact – showing information in a visual way toward the end user.


Figure 2: Source: SAP

In Figure 2, Andreas reviewed what a dashboard is.  Design Studio is for professionally authored dashboards, created for the purpose to align to objectives & KPI’s


Figure 3: Source: SAP

SAP offers two tools for professionally authored dashboards.

SAP BusinessObjects Dashboards known as XCelsius is for highly visualized presentations.

Design Studio will build dashboard apps on top of multi-dimensional data


Figure 4: Source: SAP

Andreas said we are moving away from traditional dashboards of KPI tracking to BI applications where the app is designed to perform specific activities for the users and moving to a more higher level of user interaction with the application and visualization.

This is the main purpose of Design Studio – it is not just about dashboard – but working with the BI application – for the developer to create the BI application


Figure 5: Source: SAP

With Design Studio you get a what you see is what you get design environment.

You see what the user sees as you design

According to Andreas it offers a large set of design components, such as components for filtering, grid layout

It has a drag  & drop operation

Scripting language  is a subset of JavaScript

It offers connectivity to BusinessObjects BI platforms to use it as the run time environment with lifecycle management

In terms of mobility it offers iPad support

It has direct access to BW to query / cube / hana view

Andreas then discussed “three sets of challenges” that Design Studio covers.

Challenge Set 1:

Andreas said Design Studio provides information from a trusted data source from wherever the user sits – mobile or desktop


Figure 6: Source: SAP

Figure 6 shows it can connect to your query, you can place relevant objects into specific view/column/rows, and directly create a chart component


Figure 7: Source: SAP

Figure 7 shows the QR code – to open application in Safari

Second option is via BI platform with Mobile BI 4.4 – to be released (BI4 SP05 prerequisite)

Challenge Set 2:

Push BI adoption with a scalable solution


Figure 8: Source: SAP

Figure 8 shows you can apply simple filters and adopt the layout and output of the application and change chart types, change style of the charts

It has drill down capabilities

With BW it enables support for currency conversion if required


Figure 9: Source: SAP

Connections through BI platform are available in Design Studio along with available HANA sources, as shown in Figure 9

Challenge Set 3:

The next challenge was to “reuse existing analysis assets & integrate” and “flexibility and ease of design”


Figure 10: Source: SAP

The data sources re-use the BEx queries from BW and hana views, with no metadata in between.  It connects directly to queries and views as shown in Figure 10.


Figure 11: Source: SAP

Figure 11 shows that Design Studio offers out of the box hierarchy and currency conversion support


Figure 12: Source: SAP

Andreas said the “ease of design” will help shorten development time, with the drag and drop capability to place components at exactly at the place needed, with a pixel perfect layout, and WYSIWYG design time as shown in Figure 12.


Figure 13: Source: SAP

Because the experience is different desktop versus iPad different templates are offered.  The iPad offers a touch screen so as a result there are dedicated templates for iPad and Desktop


Figure 14: Source: SAP

Roadmaps involve the usual legal disclaimer and that things are subject to change.  Figure 14 shows the current roadmap.

Current solution is 1.0; this was launched at SAPPHIRE Madrid

It is built in JavaScript

Planned innovations are in the middle and indicated the “next release”.  It is planned to support integrated planning, report to report interface, sample applications, custom themes, extended chart configuration, and an analysis view as a data source

Future direction is usually 12-18 months out:

  • – Saving BI application – enable on BW side – get document integration
  • – SDK
  • – Conversion support from existing WAD/Design
  • – Additional data sources  – existing semantic layer from BI platform
  • – Open data protocol – ODBC JDBC data sources


Figure 15: Source: SAP

What does this mean for existing customers asks Figure 15.

If using BEx Web Application Designer then look to moving to Design Studio – not just for the web but for the mobile device

Dashboard customers using with relational data sources continue to use and upgrade to HTML5

If using BW as a data source consider using new dashboards in Design Studio

Question & Answer:

Q: Is Android version available?

A: No specific Android version available now

Q:  Offline reporting?

A: You need to be connected to your back end system for a level of interactivity – no offline support

Q: Gap between BEx Web Application Designer and Design Studio? Are there plans to close gaps?

A: Yes, this is a version 1.0 product, a matter of time to prioritization of features

Check out the SAP BusinessObjects Design Studio space for more information.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Tammy, thanks for info.

      In studio, when creating DS from BEx-query getting

      \What is this ?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Design Studio right now doesn't support mandatory variables (without a default value)

      I've asked SAP to give us a link on Idea Place so these can be placed there.


      Author's profile photo Former Member
      Former Member

      Does it will be fixed in SP2 ?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I am not sure I follow, Mikhail, but if time allows I may discuss in a separate blog

      Author's profile photo Rajiv Bahl
      Rajiv Bahl

      Hi Tammy, Nice blog.

      Please can you repost a new link to the presentation as the current one is not working.



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Rajiv - the links go down 6 months after the recording.  I'll remove the links to the blog.