Skip to Content

Yesterday I attended the World Premiere of Design Studio 1.2 at TechEd.  This is part of the “share the knowledge” tour.

SAP’s Eric Schemer provided this session.  The usual disclaimer applies that things discussed are subject to change.


Figure 1: Source: SAP

Figure 1 shows overall planned features for Design Studio 1.2

Figure 1 shows an added navigation panel that allows users to filter and data drilldown and export to Excel.

Planned for release 1.3 is the export to PowerPoint.


Figure 2: Source: SAP

Figure 2 covers the new SDK, planned to be released with Design Studio 1.2


Figure 3: Source: SAP

Figure 3 covers new chart types, axis scaling, and the measure picker which allows binding of certain data cells.  Additionally there is a new chart background color.


Figure 4: Source: SAP

Figure 4 covers improvements to cross tabs, including changing the column width, enabling and disabling hierarchical navigation


Figure 5: Source: SAP

Figure 5 shows the new Navigation Panel, allowing you to filter and navigate in Design Studio. The added navigation panel allows users to filter and drilldown data.


Figure 6: Source: SAP

Design Studio 1.2 will support .UNX as a data source.


Figure 7: Source: SAP

Figure 7 shows the planned roadmap (subject to change) that shows the Background Query Loading which will improve performance.

Design Studio 1.3 is planned to have offline capabilities for Mobile

Eric said the top request was BW-IP support for Design Studio.

Planned for 1.3 is the HANA deployment – use Design Studio on HANA – without a BI Platform or Netweaver

Also planned for 1.3 is the BEx: Drag & drop, context menu, and RRI features.

In terms of Lumira visualization and put in Design Studio for a more sophisticated visualizaton


Figure 8: Source: SAP

Figure 8 covers BEx tools that are in maintenance mode and conversion support is planned for Design Studio, including web template migration.


Figure 9: Source: SAP

Figure 9 shows the full picture from XCelsius perspective

BusinessObjects customers today continue to use dashboards via Universes but can consider using Design Studio 1.2 as it offers universe support.


Figure 10: Source: SAP

Eric suggested if you start doing BI projects, take a look at analysis clients & Design Studio as you are not losing any key BW capabilities


Figure 11: Source: SAP

Figure 11 shows the suggested simplified adoption steps for BEx customers.

Question and Answer

Q: EPM – does it integrate with Design Studio?

A: Working on tidying up backend – BW-IP / BPC and looking at moving into one technical platform

On HANA – building a new HANA-based planning engine

Design Studio will work on both in the future

Q: Lifecycle of XCelsius?

A: Similar to BEx – offering with next BI4.x platforms and will work

No major new development

Q: Scheduling options for Design Studio?

A: Can’t schedule at the moment

Planned for 1.4 Analysis Office SP/Feature pack

Design Studio will look at offline capabilities

Q: No Java stack needed in BW?

A: Not needed for Design Studio – it is an add-on to BI4x

Q: Bookmarks are coming – with SDK – can we achieve this functionality with the SDK?

A: Can do with the SDK; want to have it in 1.3 as a standard capability

Q:  Are there performance benchmarks with DS vs XC

A: No

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Former Member

    Hi Tammy,

    Thanks for sharing. It is good that, Design studio will support UNX universes.

    So,  will design studio support universes on SSAS cubes or Hyperion Essbase OLAP too?



      1. Rama Shankar


        Is there any timeline / roadmap in having Design Studio support UNX files? It will be cool to have this functionality. The support for UNX will open up Design Studio to literally all backend databases.  Looking forward to hearing from you.



        1. Tammy Powlas
          Post author

          See SAP Note 1760372 – it says calendar week 47/48

          At SAP TechEd Las Vegas SAP said it is in validation and it is expected to be released end of November/December timeframe.

            1. Former Member


              Only mssql and Sybase IQ are supported at GA of design studio 1.2 .

              Others will become supported in service packs in the months following GA.

              Kind regards,


              1. Ingo Hilgefort

                Hello Sjoerd,

                perhaps you want to be very careful with such information as (1) I am sure this has never been communicated on any official SAP material and (2) that it is wrong.

                The official list of supported data sources will be communicated in form of a PAM when the product is released, but the above statement of only supporting MS SQL and Sybase IQ is not correct.


                Ingo Hilgefort, SAP

                    1. Former Member

                      Hi Ingo,

                      PAM for Design Studio 1.2 page 8 says:

                      * Design Studio supports universes fulfilling the following prerequisites:

                      • only relational, single source .unx universes

                      For a detailed list of supported features in release 1.2 refer to the chapter

                      “Universe Access in Design Studio” in Application Designer Guide

                      While in Application Designer Guide (page 49)


                      it stated that support is restricted to MS SQL and Sybase.

                      Do you state that other DB’s (like Oracle) are also supported via UNX?

  2. Former Member

    Thanks for sharing this information Tammy!

    Further, you ve mentioned “Eric said the top request was BW-IP support for Design Studio.

    Is there any further details on this? if it will be integrated with BW-IP soon or so?

        1. Tammy Powlas
          Post author

          I don’t recall it being mentioned on the webcast; it was mentioned at TechEd they are looking at putting planning integration with Design Studio 1.3 as it was a top request on Idea Place.

  3. Michael Starostecki

    Well, I loved the roadmap at first when I saw UNX. as we are way much more flexible with “normal” database, so most of our reports are based on UNX + Oracle. Now reading the Help and Documentation and the PAM there is MS SQL and Sybase IQ?

    I wanted to do Dashboards based on MySQL –> BMC Remedy and provide some cool real time Dashboards from Oracle because our users are on the run and need the data asap also because most of them want to present in the meetings… I mean we are a company of 80’000+ so… BW is there and things take a while here till it is changed… ^^

    Any Idea when DS will support Oracle? or MySQL? version 2.x ? or will it be a SP?

    1. Tammy Powlas
      Post author

      Hi Michael – I don’t have visibility into this myself as I am a customer.

      I read the PAM ( and it states:

      Design Studio supports universes fulfilling the following prerequisites:

      • only relational, single source .unx universes”

      For further updates it says to check the roadmap – I looked at and the roadmap hasn’t been updated since late last year

      I suggest asking this question as a new discussion thread in the space and hopefully SAP will respond.


      1. Michael Starostecki

        Tammy, Yes I did read the PAM, but sadly it came out after the roadmap 🙂

        And telling your supervisor that UNX will be support and the word starts to spread the expectations rise and all of a sudden you have to say, MSSQL only? mhm

        the PAM should come before the roadmap, or the communication has to be changed and people using a certain product informed what features will make it and which will not.

        I already created a blog where I am talking about the good and bad things of DS and I am trying to show what is really missing to be and be mean, because sometimes I get the feeling the the developers lose the objective and go into a direction a certain tool wasn’t meant to be.

        thanks for the words 😀


  4. Madireddy Rahul Reddy

    Hello Tammy,

    I have created a design studio application on desktop with resolution 1440*900 but when I try to view the application on other desktops with resolutions such as  800×600,1024×768,1280×720,1280×1024, the panels and the graphs do not resize themselves. I am using IE9 on all the desktops since that is the standard client browser. Is there anyway to tackle this issue?

    I am using Design Studio 1.2

    If this is the case, isn’t this a huge task to design the same applications for different desktops/laptop users?

    Appreciate your help on this.



    1. Michael Starostecki


      as a short answer to your question: use CSS with min- / max- properties and develop the application as “Responsive Design” it takes a lot more work. Also don’t set static width and height in Design Studio but make it “relative” and use the CSS to identify where to position the elements.




Leave a Reply