Skip to Content
Author's profile photo Tammy Powlas

World Premiere Design Studio 1.6 #SAPtd SAP TechEd

The usual legal disclaimer applies that things in the future are subject to change

Watch replay online at

Notes below are from a combination of attending several sessions.


Figure 1: Source: SAP

Cloud for Analytics includes reporting, planning


Figure 2: Source: SAP

Analysis OLAP converges to Design Studio

Major investments in Design Studio but not in Dashboards, BEx Web or Analysis OLAP


Figure 3: Source: SAP

Most customers are using Design Studio with BI Platform

New investments for NetWeaver and HANA deployments are not planned

If starting with Design Studio projects start with BI Platform


Figure 4: Source: SAP

Planned GA end of November, early December

Four features in Figure 4 – end user analysis

Enhanced geomaps, able to add pie chart to geomaps, or add custom markers, images, graphics

Scorecard is formatted table that can cover all formatting requirements.  A butterfly table has a dimension in middle, key figure on right and left side

Standard crosstab is dimensions on the left

Spreadsheet is alternative to crosstab; more Excel like, look and feel

Timer can be used as a refresh for near real time scenarios

Tree is a new component – display hierarchical structures; the tree component to display bookmark folders on BI Platform

CSV file as datasource – in local mode, to help designers and developers create applications

Increased limit of universe connections to 20K rows, multi-source universes, right to left support

Note – the slides below were covered in a demo, but it is hard to capture those in screen shots.


Figure 5: Source: SAP

New info chart, new chart types, trellis charts, combination charts, more configuration options


Figure 6: Source: SAP

Geo map was released in 1.5; in 1.6 layer info can be displayed as a pie chart


Figure 7: Source: SAP

End user can define how chart can look like


Figure 8: Source: SAP

Drag and drop key figures and characteristics are available for the crosstab


Figure 9: Source: SAP

Custom measures, new calculated KF’s, scaling figures

Info Chart, Trellis Chart, config options


Figure 10: Source: SAP

Crosstab is used for OLAP use cases

Scorecard is used for formatted use cases

Can change font size, background color


Figure 11: Source: SAP

Analytical application is out of the box, generic analysis (ready to run application) – you can choose BW query or HANA view as a data source

Spreadsheet, hide show – what you can do with crosstab you can do with the spreadsheet component; also can use the planning scenario


Figure 12: Source: SAP

CSV file for rapid prototyping can be used in Local Mode only


Figure 13: Source: SAP

Figure 13 has been discussed before but good to see multi-source universes are supported


Figure 14: Source: SAP

Figure 14 covers the new Fiori component library


Figure 15: Source: SAP

Figure 15 was discussed mostly in the hands-on workshops

You can watch the recording from above or join ASUG next month for the webcast – register here.

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 sharing.

      I have two questions and wonder if you have some ideas.

      Does Custom Measure only work in run-time? Can we define Custom Measure in design time in advance?

      And for spreadsheet component, does it provide more functions than crosstab? Or it's just a excel-style crosstab?

      Best regards,


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

      Hi Alfred- I am sorry I just saw your questions after all the Design Studio sessions were done at TechEd Las Vegas - I recommend watching the recording, or hopefully Karol will answer - I am not sure.

      Author's profile photo Vi Tran
      Vi Tran

      Great info.  Excited for 1.6 to come out.  Do you know if you will be able to bind custom DS to the cross tabs?

      Author's profile photo Karol Kalisz
      Karol Kalisz

      Hi Vi,

      Crosstab is a component reflecting all specialities from BW as data source. For that, Crosstab is using internal API to the BICS layer and cannot support right now the custom data sources.

      You can use the Scorecard component on any data source, or the UI5 Table from SCN repository.


      Author's profile photo Carlos Weffer
      Carlos Weffer

      Hi Karol

      Is it UI5 Table from SCN repository based on sap.m.table? Does it provides the "growing" feature?


      Author's profile photo Vi Tran
      Vi Tran

      Thanks for the information.  This is helpful.

      Author's profile photo Carlos Weffer
      Carlos Weffer

      Hi Tammy

      Thanks for sharing all this info. I am very excited about the new Fiori Components: Foundation for responsive applications going forward. Great News!!



      Author's profile photo Daniel Klein
      Daniel Klein
      • new EXCEL-like planning spreadsheet
      • CSS-Editor in Design Time
      • Drag & Drop for Crosstab navigation
      • Context menu enhancements and usability for charts
      • new "Timer" component for auto-refresh
      • Graphics and Icons Library
      • data binding enhancements

      This release will be awesome! Can't wait to install it!

      Source: Roadmap

      Author's profile photo Former Member
      Former Member

      Hey Tammy,

      thank`s for sharing the information about Design Studio 1.6.

      I am honestly disappointed about the message that the use case where Design Studio reports are directly stored on a BW system without using a BI Platform will not be supported in the future.

      I have sold this scenario to one of my customers. I am not sure what I`m supposed to tell them now?

      I further would only partly support SAP`s point that most customers use Design Studio in combination with BI Platform. This surely applies to historic Business Objects customers. But if I think of my regular BW customers I clearly have to neglect that point.

      From version 1.5 on, I sensed the feeling that Design Studio is really maturing into a great reporting tool. I was confident to demonstrate and show it to all of my customers.

      They really liked it and were searching for an easy and straightforward use-case. They do not want do administrate, monitor, install or patch a BI Platform. Neither do they wish to implement complex SSO scenarios. From my customer base, only one out of many customers uses the BI launchpad as a portal. Most customers have a sharepoint or a Netweaver portal anyways.

      I was really happy when Design Studio usage without the BI platform was announced.

      Is there a way to influence the above depicted decision, since each slide of SAP`s presentation states that it is subjected to change?

      Thank you & Cheers,


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

      Hi Marcus - thank you for reading and commenting; I am an SAP customer myself.  I recommend discussing this with SAP product management, or perhaps creating a new discussion thread so SAP can reply to your questions. 

      Author's profile photo Carlos Weffer
      Carlos Weffer

      Hi Marcus

      Glad to know I am not the only one with this very same opinion.

      Why SAP would like to take options away from customers? I must say, in this case the simpler options. Having to justify a BIP implementation only because you are planning to use Design Studio seems hard to me.

      They way I see it, they are making the life easier for their competitors.

      You can count with my help to influence SAP to reconsider this decision.



      Author's profile photo Daniel Klein
      Daniel Klein

      I agree with you Mr. Preis.

      If we would not rely on the BIP for the full feature set, we would not have installed the BIP at all (we are not using any other BIP tool).

      Author's profile photo Former Member
      Former Member


      open idea on ideaplace, we will support you idea.

      Author's profile photo Former Member
      Former Member
      Author's profile photo David Stocker
      David Stocker

      Hi Marcus,

      This is a topic where a lot of tears have been shed over the years, but we really do think that we can build a better product by concentrating on the platform where the overwhelming majority of worldwide Design Studio customers are; and that's on the BIP. 

      And we're not pulling the plug on existing scenarios.  We're not pulling the plug on existing Netweaver scenarios, but future functionality will be built for the BIP.

      The Future of Design Studio Platform Development



      Author's profile photo Daniel Klein
      Daniel Klein

      Hello David,

      but the future is S4/HANA, not BIP.

      Design Studio should also be build for the future, not for the platform that is currently used most.

      But hopefully this orientation will change when most customers have shut down their BO systems and are S4/HANA only.

      Author's profile photo Former Member
      Former Member

      Hi Tammy/Karol,

      I am quite excited with planning stuff and have a question,

      If we plan for current year - will actuals periods gets disabled/locked ?

      Can we add/insert a new line on excel sheet with save to backend functionality? (we have this in DS 1.5).

      Appreciate your help.



      Author's profile photo Former Member
      Former Member

      Hi Marcus, Carlos,

      I share your concerns. I would like to see the option to use DS directly on BW and HANA being continued. And if all the data resides in BW or HANA I don't see much benefit added by the BI platform - in contrast BI platform administration is a really complex task. I don't see why one would need an extra 5GB piece of software to just store some DS templates. And I don't really believe that adding an extra software layer would increase the overall reporting performance.

      Best regards,


      Author's profile photo Former Member
      Former Member

      What Hanno said!


      Author's profile photo Former Member
      Former Member

      Hi, Tammy,

      When GA?

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

      Mikhail - I am hoping we receive an update on our upcoming ASUG Webcast next week.

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

      Mikhail - please see Re: release date  design studio 1.6 for your answer 🙂

      Author's profile photo Stefan Knoerrlein
      Stefan Knoerrlein

      Hi Tammy,

      I'm a bit confused regarding the starting point of freezing NetWeaver investments.

      All new features coming with 1.6 are actually still supported for NW or not ?

      May be you can answer this.



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

      Stefan - yes, things like templates etc. will work with NetWeaver; we had an ASUG webcast on this yesterday and when I have time I will share my notes on this. 

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      sounds great - I am also highly interessted in your notes.



      Author's profile photo Former Member
      Former Member

      Lot of great features ! The best one for me : the ability for the end user to create a custom measures ! Awesome !