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).
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
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
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
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.
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
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.
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.
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)
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.
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.
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.
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
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
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
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?
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 firstname.lastname@example.org for more information.
Thank you to Eric Schemer and Jie Deng for supporting ASUG with this webcast.