What is new in Design Studio 1.3 ASUG Webcast

TammyPowlas · ‎05-06-2014

Below are my notes from today's ASUG webcast. The usual disclaimer applies that what is planned for the future is subject to change.

Similar slides were shown here BI2014 Design Studio 1.3 Planned Updates and Design Studio Overview Roadmap

Overview:

Design Studio is not a 1:1 replacement for either SAP BusinessObjects Dashboards or Web Application Designer (WAD) yet

Design Studio is What You See Is What You Get

Microsoft & Sybase are data sources for UNX; this will change in the future

Design Studio 1.2 brought the Design Studio SDK

Coming with Design Studio 1.3:

BW IP and BPC unified model with BW 740
Native HANA deployment, which does not use BICS
SDK in 1.2 wasonly deployable on BI Platform. – in 1.3 – deploy anywhere – BW or HANA
Share charts with SAP BusinessObjects Lumira – 1.3 extended
Bookmarking – save navigation state of application
Not in DS 1.3 – coming in SP – support Lumira SDK
Advanced table formatting – those familiar with BEx, WAD, take for granted – setting scaling factors, turn on/off hierarchy display, turn on/off totals – available in the properties pane or scripted and connected to events and dynamic at runtime
Scripting language improved – support for loops and arrays as well as sorting for arrays
Printing: whatever you see is what you get – maybe in future a printable flag in the properties
Conditional formatting
Install Lumira Visualizations (coming in a later support pack)
Prompt enhancements
Bookmarking/personalization will work on BIP (BI Platform) and locally too

Planning Support in 1.3:

Planning supports for input-ready measures, add new lines, execute planning functions & sequences

It does not yet support cell locking – coming in future

BPC Unified Model in BW740 is supported

Source: SAP

We've seen this slide before, but today I learned that you can select booked values or master data values

This is helpful if the end user is on a slow connection and does not wait for round trip to the server.

Source: SAP

In the future, SAP plans to round off gap list with WAD – context menu, RRI, drag & drop

Offline is not likely in 1.4

Geomaps are coming in the future; delay right now due to licensing issues

InfoGraphics support for Infographics similar to Lumira infographics coming in 1.16

Long-term includes migration support for BEx Web & XCelsius. SAP said they will need communication with the communities to determine what are the most important scenarios to transport

Lumira Integration is coming further down the line

SAP plans to continue to close the gap list between Design Studio and XCelsius

They said they they understand those who know Excel and not JavaScript – plan to make the ramp “more accessible”

Demo:

Source: SAP

The above shows a Fiori-style dashboard with tool tips

Click on one of the charts and the following appears:

Source: SAP

The screen above shows set scaling and setting decimal places

Source: SAP

The above shows recalculate the planning after entering the overall measure, trigger planning function and distribute it by raising the price

Question and Answer

Q: Is it possible to receive an advanced (beta) version of 1.3?

A: Unfortunately the answer is no.

________________________________________________________________

Q: My understanding is if we have Xcelsius license then we are free to use design studio. can you please confirm if this true?

A: Yes, for most licenses this is true, please contact your account executive if you do not see it on SMP

________________________________________________________________

Q: Will SAP offer migration options to Xcelsius and not just through the APOS add-on?

A: This is something they are investigating - they have had some proof of concepts - similar to way Analysis Office approaches problem.

________________________________________________________________

Q: Will Design Studio 1.3 support displaying Medium Text from a Bex Query? Currently it only allows Text and Value.

A: Don't think this has changed - this is BICS

________________________________________________________________

Q: Are hierarchy node variables supported?

A: Those are supported today - see SAP BusinessObjects BI4 - Supported BEx Query Elements

________________________________________________________________

Q: Is there a language reference with examples for the Design Studio scripting language?

A: Have Designer Guide that explains script language - other than that it is JavaScript

________________________________________________________________

Q: Is Printing in DS 1.3 browser based or PDF based? Is there an option to download the dashboard output to Excel or PDF?

A: It is WYSIWYG - browser based

________________________________________________________________

Q: Ok, what about PDF or Excel download? Will this functionality be available? Not the dataset the visualizations.

A: Design Studio today supports an export to Excel. PDF support is not there - will be WYSIWYG in 1.3

A: Most end users have option to print to PDF

________________________________________________________________

Q: What is the lower BOE version compatible with Design studio 1.3?

A: BI4 SP5 or any version BI4.1

________________________________________________________________

Q: Advance Scripting,, like if i want to get top 10 records from result of 100 records which came when i called DS_1. i should not go back and create a new view or bw query to achieve this

A: Open query in Analysis Office, top 10 - Smart copy

________________________________________________________________

Q: Will we have the ability to create custom columns in script

A: Not yet

________________________________________________________________

Q: Will there be any additional enhancements to DS SDK in Design Studio 1.3(other than netweaver deployment)?

A: Not in 1.3 - coming further down road yes