Skip to Content

Eric Schemer, SAP Product Owner for Design Studio and the Analysis clients, kicked off this webcast. Please note that the usual disclaimer applies that statements made here are subject to change and anything planned is subject to change.

Eric said that since general availability they have over 1000 customers who have downloaded Design Studio

In a surprise for attendees, SAP also provided a sneak peek of the functionality for the next version of Design Studio 1.1 (more on that later).

/wp-content/uploads/2013/01/1fig_177447.png

Figure 1: Source SAP

Eric reviewed the positioning of BI clients and how see Design Studio in the larger BI product family

Products are clustered in 3 areas:

1) Discovery & Analysis – developing there and shipping to market

BI clients – self service

Data access to personal data sets and data driven visualizations

2) Reporting:

Cluster reporting products – install based – Web Intelligence & Crystal Reports which are page driven, report driven.  They provide a number of graphic and static reports versus ad-hoc data exploration

3) Dashboarding

In middle of Figure 1 is Dashboard & Application design environments in one offering

It is targeted to key user, technical, not just IT but also a more technical savvy users to build professional applications. It is used both for standard desktop & mobile world, providing sophisticated apps & dashboards

Design Studio is the product to which will merge Dashboards & BEx Web Application Designer (WAD) functionality

/wp-content/uploads/2013/01/2fig_177448.png

Figure 2: Source: SAP

Today there are three products in the Dashboards and Apps category.  Design Studio is the forward moving product for application design.

Dashboards is from BusinessObjects perspective and is more related to bringing in arbitrary data sources and building dashboards on any type of data.

BEx WAD (not pictured) is heavily used with BW – key dashboard building environment for BW.

/wp-content/uploads/2013/01/3fig_177485.png

Figure 3: Source: SAP

Three major scenarios of visualization strategy are shown in Figure 3.  One is professionally authored – classic BI tools – key users build apps and deploy apps to a broader audience.  This is where Dashboards & WAD come from.

Business Analyst driven world which is more ad-hoc, simple; they are not full-fledged sophisticated design, lightweight intuitive – catering for business user and day to day user

SAP also sees dashboarding & authoring in Self Service area – lightweight users working with the products but not requiring deep functionality

/wp-content/uploads/2013/01/4fig_177486.png

Figure 4: Source: SAP

Figure 4 shows the map to tools.  For professional authored dashboards Design Studio is the key product with Dashboards merging into Design Studio.

Dashboarding in a business user world Visual Intelligence (non-BW market) with Analysis Office & Analysis OLAP – BW market

Self service includes Explorer & Exploration Views and tight integration with Visual Intelligence.

/wp-content/uploads/2013/01/5fig_177487.png

Figure 5: Source: SAP

Three products in Analysis client family; taking over the scenarios you used to build with the BEx offering

Design Studio is the premium successor to Bex Web & BEx WAD

BEx Web has Analysis for OLAP

BEx Analyzer has Analysis Office

Analysis Office also has an integrated developer & app building approach – you can use Analysis Office to build Excel based application and dashboards.  It also caters for business analyst as it has crosstab and exploration capabilities

Analysis OLAP and Design Studio will come together over time. 

Analysis OLAP will be based on Design Studio functions. 

/wp-content/uploads/2013/01/6fig_177494.png

Figure 6: Source: SAP

Figure 6 is to provide clarity to BEx.  There are still a lot of questions and misconceptions around BEx.

The BEx tools are in maintenance and are shipped with every new BW release

The BEx maintenance release corresponds to BW release (e.g. 730) comes with a new install of BEx 7

For example, if SAP ships BW 740 will include a new instance of BEx and maintenance would correspond to BW 740 release.

No end of life planned for any of the BEx tools.  BEx investment is safe.

BEx Query Designer will stay as key semantic model for BW and this will not change.

Analysis Office already offer conversion for BEx Analyzer 3.5 & 7

Down the road, SAP plans to offer migration/conversion for WAD to Design Studio (planned)

/wp-content/uploads/2013/01/7fig2_177496.png

Figure 7: Source: SAP

Figure 7 shows current architecture.  Analysis & Design Studio sit on the same access layer.  BI Consumer Services (BICS) was built for BEx and it is being leveraged by Analysis against BW and instance on HANA native.

You can use Analysis & Design Studio to connect to HANA

You can use it to connect to BW ABAP layer

BW on HANA as shown on the left side of Figure 7. 

/wp-content/uploads/2013/01/7fig_177498.png

Figure 8: Source: SAP

Leveraging tight integration technology, you can use Analysis 1.3 you can copy and paste sheets into Design Studio, apply an iPad template. See http://scn.sap.com/docs/DOC-34488 for more information on this.

/wp-content/uploads/2013/01/8fig_177499.png

Figure 9: Source: SAP

Two installers come with product (for installation instructions please see this video by the CSA team.)

The Designer is installed on the desktop

With just the design tool you can deploy & connect to mobile (designer only) – for test reasons

Once go live with Design Studio you install additional add-on to BI4 platform.  The Design Studio  runtime is on BI platform – take the apps from desktop and publish on BI platform and scale them to end users.  You can then deploy to BI Launchpad and BI4 mobile.

/wp-content/uploads/2013/01/9fig_177500.png

Figure 10: Source: SAP

What you see is what you get as you see in Figure 10.  You always build and design with live data, always see the same layout.

With HTML5 SAP will add more mobile devices

/wp-content/uploads/2013/01/10fig_177501.png

Figure 11: Source: SAP

Figure 11 shows the initial view editor that provides some lightweight data modeling in Design Studio – no need to go back to Query Designer

/wp-content/uploads/2013/01/11fig_177502.png

Figure 12: Source: SAP

Figure 12 shows a roadmap of where will be with Design Studio 1.1 which is planned for Q2 this year.  Mid-term is planned for later this year, and future is after that.

Design Studio 1.1 will have enhanced charting, more animated charts, chart properties

Controls such as filter components, scripting, variable prompting (today it can’t deal with mandatory variables)

It will have interoperability with Analysis OLAP

It will ship DS with just BW  (no BI platform) and a HANA native deployment – no BI / BW platform

SAP is working on the first SDK for custom visualization and is offering a beta program for customers and partners in Q2.

SDK will go in GA in mid-term

The plan is to offer universes as an additional data source later this year.

We saw a great demo of Design Studio 1.1 and if time allows will post more on that later.

Question & Answer:

Q:  I am not seeing any mention of SAP Visual Composer. Can Eric talk about where it fits?

A:  Visual Composer is no longer in development; since acquisition of BusinessObjects investment phased out – no new features added to VC

________________________________________________________________

Q:  So position of Analysis as an ‘application’ from Design Studio sounds exactly like Bex Web and WAD

  A:  Yes

________________________________________________________________

Q: Analysis, Edition for OLAP and Designer studio are mutually exclusive from a use case perspective? i.e. Analysis edition for OLAP can be used for AD-Hoc and for professionally authored ones, Design studio is the option?

  A:  Yes, but we want to base them on the same technology, that would potentially mean that you could even change behaviour and features of A OLAP with the Design Studio

________________________________________________________________

Q: A default WAD template can be used for a BEx Web Query, can a Design Studio “template” serve the same purpose?

  A:  Will provide this template functionalities in the next releases.

________________________________________________________________

Q:  Are there any enhancements for BEx after 7.3 or will it just be maintained?

A:  It’s in maintenance, meaning support for new browsers or new BW backend platfrom are built in but no new “real” features

________________________________________________________________

Q: Are BEX Web Apps continued to be supported as well.

A:  Yes, Bex WAD is continuing to be supported

________________________________________________________________

Q: Does Design Studio use IGS like WAD?

A:  Design Studio is using the CVOM charting like other BusinessObjects product is doing.

________________________________________________________________

Q: Design Studio appears to be limited to IE 9.0 .  Is that the plan going forward or will it be available for IE 8 as well?

A:  The runtime of Design Studio can also on IE8 with some minor limitations due to HTML 5 technology. On Design time you need to have IE9.

________________________________________________________________

Q: any plan in future for design studio for android user as now ipad only ?

  A:  Yes, this is planned for release 1.1.

________________________________________________________________

Q: Is there a requirement for ie version for zen/designer – what about other browsers?

  A:  ZEN Design time needs IE9. On runtime the browser IE, SAFARI, Firefox is released. you can check that again in PAM on SAP service Market place.

________________________________________________________________

Q: BW version dependency of >7.x?

A:  7.x will do, no need for 7.30

________________________________________________________________

Q:  What is driving ie9 need? We have seen ie9 as very problematic itself.

  A:  HTML5 –> we need the latest and greatest to be the latest and greatest 🙂

________________________________________________________________

Q:  [question] Will Design Studio support Chrome browser?

  A:  Yes, Design Studio 1.0 is also released for Chrome browser

________________________________________________________________

Q: Is the designer installable on Citrix client rather than on user’s pc?

  A:  Citrix is possible.  a couple of customers already installed ZEN in Citrix enviroment

________________________________________________________________

Q: Is it possible to install the designer with IE 8 only?

A:  Today no that is not possible with the designer – you need IE9

________________________________________________________________

Q: Can you install designer on Chrome, or Firefox, if you don’t have IE 9?

  A:  Design time of Design Studio needs IE9. for end user Design Studio can be run within Firefox, safari, IE and chrome

________________________________________________________________

Q: I think Eric said earlier that eventually Xcelsius and Design Studio were merging.  Is there plans for a conversion wizard from Xcelsius to Design Studio?

A:  Conversion support is planned for the future releases. But it maybe not in a WIZARD mode

________________________________________________________________

Q: Can i hide components at design time so i have one front of me where i want to work on .. ” Design Time”

  A:  this is coming

________________________________________________________________

Q: I see SSAS again as a potential data source. Will it only support SQL Server 2008 and later or is it back reaching to SQL Server 2005?

  A:  direct SSAS access is not enabled yet, it would likely be only with 2008

________________________________________________________________

Q: Can dashboard developed with Design Studio be deployed to Android devices?

  A:  It’s HTML5 so theoretically yes, but we have not fully tested and hence not officially support that yet

________________________________________________________________

Q: How will design studio write to ABAP tables in the future?

A:  RFC

________________________________________________________________

Q: In addition to Bader’s question, I think SAP needs to publish a list of features and controls from an Xcelsius dashboard that cannot be converted over. This helps us in planning tremendously.

  A:  yes, as we move ahead we will see more of these type of recommendations

________________________________________________________________

Q: can we expect mid term to be atleast Q4 2013?

  A:  planned mid term is Q4 this year

________________________________________________________________

Q:  How does Design Studio competes against Xcelsius?

  A:  they merge, today DS is for BW/HANA, XCE is more for other data sources

________________________________________________________________

Q:  is any flex in design studio as  dashboard is having flex 4(maybe)

  A:  absolutely not. flex is a no go

________________________________________________________________

Q: INteroperability – Can we jump from Design Studio to WebI or Analysis? Can the results of a WebI report be consumed by Design Studio?

A:  not yet

________________________________________________________________

Q: Dashboard has a limitation on how much data we can keep in it without impact on performance. Is there any limitation with Deisgn Studio on number of rows?

  A:  no limit

________________________________________________________________

Q: which BOE version (BO 4.0 SP4 or higher?) required to publish these applications

  A:  4.0 SP5

________________________________________________________________

Q: Sorry I was late, Design Studio is the replacement of webirichclient?

  A:  no, it has nothing to do with WebI, it’s about XCE & BEX WAD merging

________________________________________________________________

Q:  Please define midterm and Future, with regard to the roadmap slide.

  A:  midterm Q4 2013, future beyond 2013

________________________________________________________________

Q: which release will support all data sources?

  A:  DSL is planned for 1.2, anything else is too early to say…

________________________________________________________________

Q: as right now there is no app for design studio but if i have the url of the design studio dashboard  can i see my report in android web application ??

  A:  as it is HTML5 yes, but it’s not officially supported and tested yet…

________________________________________________________________

Upcoming ASUG Webcasts on Design Studio:

If you are not an ASUG Member and are interested in a trial membership please e-mail trailmembership@asug.com for more information.

Thank you to Eric Schemer and Jie Deng for supporting ASUG with this webcast.

To report this post you need to login first.

9 Comments

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

  1. Bhanu Gupta

    A must read blog for anyone interested in Design Studio and dashboarding 🙂 Thanks to Tammy and the ASUG BI team for channeling so much good information to the community – product updates, features, roadmaps, demo and detailed Q&A – plus the summary blog!

    (0) 
    1. Tammy Powlas Post author

      Bhanu – thank you for your kind words and thank you for supporting ASUG.  I forgot to mention the great work/support of ASUG volunteer Joyce Butler who moderates the most webcasts for ASUG 🙂

      Tammy

      (0) 
    1. Tammy Powlas Post author

      Hello,

      Thank you for your interest.

      The webcast was open to ASUG Members only and it is not possible to share the webcast.

      If time allows I will try to write about the features we saw.

      Regards,

      Tammy

      (0) 
  2. Mikhail Budilov

    Thank you Tammy,

    Seems to be DS will be not bad product in next year ?

    universes,

    bw-ip, PAK

    RRI and so on.

    But hope it will be more stable and bugless, not as others BO brothers.

    (0) 

Leave a Reply