Skip to Content
Author's profile photo Tammy Powlas

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

Assigned Tags

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

      I'm really looking forward to these sessions at TechEd AMS. Thanks Tammy

      Author's profile photo Former Member
      Former Member

      Thanks for sharing Tammy! Good to see many improvements in 1.2

      Author's profile photo Jeroen van der A
      Jeroen van der A

      thanks Tammy,

      great read.

      Was there any additional comment about the 'enhanced scripting' other than the initialize variables?

      Jeroen

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

      You get that in the hands-on in EA260 πŸ™‚

      If I have time I will try to blog about that before the week is out.

      I highly recommend EA260 hands-on Design Studio 1.2 in Amsterdam if you are there

      http://sessioncatalog.sapevents.com/go/agendabuilder.sessions/?l=57&sid=7376_33753

      There is only one session.

      Author's profile photo Former Member
      Former Member

      That's why there's a seat with my name on it πŸ™‚

      Author's profile photo Jeroen van der A
      Jeroen van der A

      i'll try to be there too πŸ™‚

      Author's profile photo Rama Shankar
      Rama Shankar

      Good info - Thanks Guys!

      Rama

      Author's profile photo Former Member
      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?

      Thanks,

      Satyam

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

      I am not familiar with SSAS  or Hyperion as data sources but it is planned to have UNX support

      Author's profile photo Former Member
      Former Member

      Thanks Tammy.

      Author's profile photo Rama Shankar
      Rama Shankar

      Tammy:

      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.

      Thanks,

      Rama

      Author's profile photo Former Member
      Former Member

      Rama,

      As you can see in the article, UNX is supported from 1.2, which will be available somewhere in November..

      Sjoerd

      Author's profile photo Rama Shankar
      Rama Shankar

      Svan,

      Thanks. My bad - I did not read in detail. I am excited to exploit this .UNX connectivity - thanks Tammy and Svan!

      Rama

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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.

      Author's profile photo Yun Jung Jang
      Yun Jung Jang

      Hi Tammy..

      Thanks for sharing. How about DB2 and Oracle?

      Design studio 1.2 will support DB2 and Oracle as UNX universes?

      Many Thanks,

      Yun

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

      Hi Yun,

      I don't know the specifics on that, but will ask at the Reporting 2013 conference tomorrow and will share what I find.

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort

      Hi,

      the plan is to support relational, single source BI 4.1 Universes (UNX)

      regards

      Ingo Hilgefort, SAP

      Author's profile photo Yun Jung Jang
      Yun Jung Jang

      Thanks, relational means Oracle or DB?

      My team tested ramp-up version yesterday, only SQL Server supported.

      Many Thanks for your information.

      Yun

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort

      Hi,

      official list of supported data sources will be listed in the PAM when the product is GA

      Ingo

      Author's profile photo Former Member
      Former Member

      Hi,

      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,

      Sjoerd

      Author's profile photo Ingo Hilgefort
      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.

      regards

      Ingo Hilgefort, SAP

      Author's profile photo Former Member
      Former Member

      Ingo,

      Actually. It seems it is very correct, see Design Studio 1.2 help file:

      https://pbs.twimg.com/media/BZn2st7CIAAnJRE.jpg:large

      Sjoerd

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort

      Hi,

      for the list of supported platforms each of our products has a PAM.

      here is the PAM for Design Studio 1.2 :

      https://websmp108.sap-ag.de/~sapidb/011000358700001013822013E

      regards

      Ingo Hilgefort, SAP

      Author's profile photo Former Member
      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)

      http://help.sap.com/businessobject/product_guides/AAD12/en/ds12_user_en.pdf

      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?

      Author's profile photo Former Member
      Former Member

      Tammy,

      Do you know the SPS requirement on BI 4.0/4.1 platform for Design Studio 1.2?

      Thanks.

      Deepu

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

      I do not - I recommend watching/looking at the PAM when it is released at service.sap.com/PAM

      Author's profile photo Former Member
      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?

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

      We have an ASUG webcast on this topic Wednesday - hopefully we'll hear more then.  Thank you for reading and commenting

      Author's profile photo Former Member
      Former Member

      Hello Tammy,

      in the webcast on Wednesday, was there any mention of the integration with BW-IP? Can you throw some light on the same.

      Thanks.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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.

      Author's profile photo Bharath Ramamurthy
      Bharath Ramamurthy

      Hi Tammy,

      Yes. BW-IP is one of the top priorities for 1.3

      Regards,

      Bharath

      Author's profile photo Former Member
      Former Member

      Thanks for sharing these Design Studio preview news.

      Author's profile photo Former Member
      Former Member

      Seems 1.2 GA version is now available to the public on the market place!

      Author's profile photo Michael Starostecki
      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?

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

      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

      Author's profile photo Michael Starostecki
      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 πŸ˜€

      Michael

      Author's profile photo Madireddy Rahul Reddy
      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  800x600,1024x768,1280x720,1280x1024, 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

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

      Rahul,

      Would you please create this question as a new thread on discussion forum, so others may assist? 

      Thank you,

      Tammy

      Author's profile photo Michael Starostecki
      Michael Starostecki

      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

      Author's profile photo Alfons Gonzalez Comas
      Alfons Gonzalez Comas

      Hi Tammy,

      Any idea about future plans to provide UNX query support to SAP BI 4.0 platform (SP 9/10?) -currently 1.2 release only supports UNX on 4.1 platform-.

      Thanks,

      Alfons

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

      Hi Alfons,

      I do not know about this

      I hope SAP responds to your discussion thread