What is new in Design Studio 1.3 ASUG Webcast
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
Related:
ASUG Annual Conference – Add Dashboarding/Design Studio to Your Agenda
Design Studio will be part of the ASUG Annual pre-conference on June 2nd:
SAP BusinessObjects BI 4.1, SAP BW, and SAP BW on HANA – All in One Day Hands on Full Day
For more details see Preview of 2014 ASUG Annual Conference: Focus SAP Integration with SAP BI BW ERP/ECC and Analytics SIG
Hi Tammy, nice blog.
In DS 1.3, will be available other components? For example, the Gauge will be available?
thanks.
Andrea
Hi Andrea,
Thank you for reading/commenting.
It wasn't specifically discussed in the webcast and I don't see it in the roadmap slides. My guess is to look at SDK extensions
Andrea,
Archius ChartsPLUS offers different kind of gauges for Design Studio. You can find more details on our solution at the link below.
http://archius.com/chartsplus-for-sap-businessobjects-design-studio/
Thanks.
Deepu
Hi Deepu,
If I use Archius ChartPLUS I do not need of using design studio SDK because in ChartPLUS I will get more charts, panels, gauges etc..? Am I right?
What about the performance of tool if more components are added from ChartPlus?
I would recommend my Company to go for Archius if it as we expected
Regards,
Mathivanan M
Hi Mathivanan,
Please see my answers below:
If I use Archius ChartPLUS I do not need of using design studio SDK because in ChartPLUS I will get more charts, panels, gauges etc..? Am I right?
DS: Yes, if you use ChartsPLUS you don't have to create custom SDK components, you can use the ChartsPLUS add-on like a regular Design Studio component without having to write any code.
What about the performance of tool if more components are added from ChartPlus?
DS: ChartsPLUS will not affect the performance of the application, that will depend on the design of the application, number of data sources etc.
Thanks.
Deepu
Nice Blog - Thanks Tammy! 🙂
Hi Tammy,
thanks for the information.
Is Planning (BW IP) supported with DS 1.3 and NW 7.31? Or is Nw 7.40 required?
Thanks,
Markus
The SAP help at http://help.sap.com/businessobject/product_guides/AAD13/en/ds13_whatsnew_en.pdf doesn't specify which BW version needed for BW IP - you do need DS 1.3
To use the unified planning model you do need to be on BW 740 per 0207 Latest News on SAP BusinessObjects Design ... | ASUG (slide 28)
Hi Tammy,
is there any SDK available for DS 1.3?
My requirement is to create DS reports using SDK (programmaticlly).
Thanks
Amit
Check out the SAP help guide for SDK at http://help.sap.com/businessobject/product_guides/AAD13/en/ds13_dev_guide_en.pdf
Michael Howles has written several great blogs regarding the SDK as well.
Thank you Tammy for reply.
I already have looked on this PDF. Its more about creating custom extensions and then deploying in DS.
But my requirement is to creating a report from scratch in DS using code.
I am looking of any SDK through which a can create report from scratch. Might be I am asking some stupid question but I am completely new for this SAP world.
Thanks
Amit
I am not an expert in this area. However please check the blog posts here to help: Mike Howles
Thanks Tammy. I will do so.
Hi Tammy,
thanks for this overview.
I guess I found a bug in DS 1.3 concerning Line Charts and "on click" property:
I have a page containing graphs with different chart types –
mostly “Line” or “Column”.
When clicking on the graph I´m jumping to a different page
which is showing the values in a crosstab.
From this crosstab page I can jump back to the graphs page
using a panel as a button with “On Click” property.
If I´m jumping from a Column chart to the
crosstab and back to the graph it´s no problem.
If I´m jumping from a Line chart to the
crosstab and back it´s looping always back to the crosstab page – I can only
restart the application.
I tested this while changing a not-working Line chart into a
Column chart – and it worked.
In our BO PROD Server (which is still on version 1.2 ) I
can use the existing application without problems no matter if Line- or Column
charts.
In the BO DEV Server 1.3 this problem is existing now.
What we are trying now:
Promote the application (which is now under DS 1.3) from BO DEV Server to BO PROD Server.
Then we will see:
a.) If the bug will come again – which would point
to the Design Studio 1.3 Client.
b) If the bug wouldn´t come – then it´s a problem
with the server version.
Do you have any idea or proposal ?
Best regards
Emanuel
Hi Emanuel - would you please post this as a new discussion in the forum? Other members will likely have some ideas to assist.
Thank you,
Tammy
Hello Tammy,
Thanks for the very informative blog. i was going through the admin guide and i found the following sentence which suggests to me that planning applications are not mobile yet. Can you please shed some light on this? "With SAP BusinessObjects Design Studio you can create desktop browser applications for planning business data" .
This suggests that the planning applications work only on desktop browser. With out current client, What we are trying to achieve is , try to somehow create an approval process with design studio as interface. for example: user clicks on an approve button which writes back data.
Hi - thank you for reading
Is this a question about planning? If so I recommend asking this in the discussion forum.
I am not currently using planning so I can't answer this.
Tammy
Hi Tammy,
In Q&A sections, you said Design Studio 1.3 is compatible BI 4 SP5 or greater.
But is Design Studio PAM showing BI 4 SP8 or greater.
Is first statement still correct ?
Thanks,
Sesha.
I would go with what is in the PAM as that is the official document.
Hi tammy,
Is the patch 00 for BIP - Addon SP0 contained in the SP1 ?
Thanks .
Andrea
Yes, I believe it is all cumulative. I can't find the exact response where SAP replied to this though.
Yes ,, It is commulative,,, it will update/new install with sp01
Hi Tammy,
In one of the screenshot above, there are dropdowns to select Scaling and Decimal place which can be selected by user during runtime.
Is this feature available in DS 1.3 now ? I could not find out.
Regards,
Kesavan.
Yes, this is available now.
You can use the ad hoc template to try it out
Hi Tammy,
The Planning dashboard which you have shown in the article is really fascinating.
Would be very nice of you if you can guide me to any How To.. doc on which teaches how to create a Planning Dashboard with User Inputs functionality & shows how to recalculate the planning after entering the overall measure, trigger planning function and distribute it by raising the price.
Thanks
Pradeep.
Hi Pradeep - I am not using planning myself, so I can't do that. There are some nice SAP Design Courses courses at the Learning Hub at training.sap.com to help with that, or you can check the free tutorials at Official Product Tutorials – SAP BO BI Suite