Skip to Content

World Premiere of Design Studio 1.2 – Sharing the Knowledge from SAP TechEd

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.

1fig.PNG

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.

2fig.PNG

Figure 2: Source: SAP

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

3fig.PNG

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.

4fig.PNG

Figure 4: Source: SAP

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

5fig.PNG

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.


6fig.PNG

Figure 6: Source: SAP

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

7fig.PNG

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


8fig.PNG

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.

9fig.PNG

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.

10fig.PNG

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

11fig.PNG

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

41 Comments
You must be Logged on to comment or reply to a post.
  • 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?

    Thanks,

    Satyam

  • 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?

  • 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?

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

      I read the PAM (service.sap.com/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 service.sap.com/roadmap 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.

      Tammy

      • 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 😀

        Michael

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

    Regards,

    Rahul

    • Rahul,

      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.

      Cheers

      Michael