Posts tagged HTML5
Today SAP Dashboards Service Pack 05 is released on the SAP SCN marketplace. Of course I downloaded it right away.
The first thing I noticed on SCN is that it is a real Service Pack, not a full installation. So you can install it quite fast.
I installed it on Windows 7 and when you do this, the first time you start xcelsius.exe, you might receive an error message (C++ runtime error). Just right-click the xcelsius.exe file and select “run as administrator”. You only have to do this the first time. I encountered this issue before and already wrote a short blog about it in the past.
Object browser enhancement
SAP added a search box to the object browser pane. For me, this is great since I often have dashboards with lots of objects.
For example, when you enter “actual”, all objects with that name will be shown.
This (simple) feature has been on my personal wish list for quite a while now so I’m glad this feature has made it into this SP05 release.
Mobile compatibility panel
Of course, the main new features are to be found in the mobile and HTML5 support topic. One of the new features in this area is the whole new ‘Mobile compatibility panel’. This panel is new, next to the existing panels (components, query browser, object browser).
If you have an existing dashboard model and you open the mobile compatibility panel, all object names are shown, including a icon to tell if they are supported for mobile export.
In my (quite simple) dashboard example, the print button and sparkline object aren’t supported. This results in not displaying the objects in the dashboard in preview mode. The print functionality is integrated into the SAP BI mobile app so you might not need a separate print button anymore.
You can see in my example above, that the object names contain a number behind the name label. This means there is an error or a warning. In this case, the warnings apply on custom colour and theme settings of the used objects. Only one theme is supported for now, the Nova theme.
Next to this, you can see that there is a general comment, which suggests to change the canvas size to the optimal iPad screen resolution.
The preview button has also changed. It now has two mobile related options. Fit to screen and orginal size.
After you select one of the available options, a iPad case surrounded dashboard will be shown, including the ability to test the interactivity of your dashboard model. Here comes some magic.
Since your navigating the dashboard with your fingers, and not a mouse, it can be tricky to see what line you are watching. SAP added a extra feature, which makes it able to easily analyse the data on mobile devices by showing a ‘mouse-over’ help screen showing relevant info.
Saving to platform
The options for saving your dashboard have also changed. You now have the option to save your dashboard as a flash file, as a mobile file, or both.
One of the SAP developers even put a little ‘easter egg’ or real mistake into this SP05 version. He probably was a Borat fan. See the menu option for ‘Save to platform as > Dashborads object for desktop only’.
iOS optimized font types
If you navigate the properties of the objects, you’ll also notice that some new font types are added, specifically for mobile use.
Support of most used components
I’ve made a little test dashboard with a subset of the components I personally use the most in dashboard projects.
In the design mode, this looks as follows.
If we now check the mobile compatibility panel, we’ll see some errors and warnings.
Note that the spreadsheet table, connection refresh button and horizontal bullet chart aren’t supported. Furthermore, there are some specific warnings regarding the combo box settings. It doesn’t support the number of labels displayed, six in my case.
If we preview it in mobile, you’ll get the following result.
- The bullet chart has disappeared
- The alert functionality in the combination chart is removed
- The design of the buttons has changed
- There was a warning on the amount of labels of the combo box, but they are all selectable
- The refresh connections button has disappeared
- The spreadsheet table has disappeared
I’ve also tested some basic dynamic visibility functionality by using a toggle button to change the visibility of a graph and this worked.
Other general test results:
- The value component is not supported
- The area chart component is not supported
- The list builder component is not supported
- Mouse over interaction for buttons and graphs aren’t supported
- HTML formatting for text boxes is not supported
- Animated entry effects for objects aren’t supported
In general, quite a large set of components is supported in this first release. SAP announced that more components will be supported in the near future. Most of the unsupported components or properties are not critical.
Check the updated help section of SAP Dashboards to see all details on what is and what isn’t supported.
Support for data connections
All connections using the data manager are not supported.
For example, the BICS SAP Netweaver BW connection type through the ‘data manager’ is not supported for mobile. For SAP BW, only SAP BW connections using the query browser are supported. This means you’ll need to re-build all your connections through the query browser. This can result in quite some rework.
If you open the data manager, it states “These connections are not supported on mobile devices”. This means you’ll always have to use the query browser instead of the data manager if you want to use mobile dashboards.
I’ve tested the performance by opening existing SP02 dashboards in SP05 and the results are disappointing in some test cases. The time to open a dashboard is around 5x as long as in SP02 and starting a published dashboard also takes about 5x as long. I encountered the same performance issues while testing SP04 (FP3) in the past versus SP02.
Since performance is one of the core factors for user acceptance, this can be quite an issue. I hope to hear from you if you encounter the same performance issues. In the past, I’ve already logged SAP support calls for the bad performance in SP04 (FP3) but SAP couldn’t reproduce the performance issues.
What are your experiences?
Important update: The performance issues only exist when using custom themes. If you use default themes like Nova, performance is not different from other SP versions.
Prerequisites for use on iOS devices like iPad and iPhone
There are some important technical prerequisites for being able to view mobile dashboards on for example iPhone and iPad.
1. SAP BI 4.0 enterprise platform with SP05
You’ll need 4.0 SP05 for using mobile dashboards.
2. BI Mobile server installed on your enterprise platform
The BI Mobile server handles the synchronization between your mobile device and BO enterprise platform. It checks which BI content (Webi reports, Crystal reports, Xcelsius dashboards and in the future SAP Design Studio (ZEN) documents) is made available for mobile use. Next to this, it passes the parameters set in the opened BI report/dashboard and communicates this with the Enterprise platform and returns the data.
3. SAP Dashboard Design SP05
The SP05 version includes the new mobile panel, compatibility checks and publish to mobile modes.
4. The iOS app SAP BusinessObjects Mobile for iOS version 4.4 (planned release is December 15th 2012)
You’ll need the app for viewing the dashboards on a mobile device since the app includes the HTML5 wrapper.
The overall architecture looks as follows:
I’ve tested this new SP05 version for about two hours now and I must say I’m quite positive about the first results. Of course I’m waiting for the release of the iOS app SAP BI Mobile 4.4 so that I can actually deploy to a mobile device but up till then, this looks positive.
The main concern is rework for existing ‘data manager’ connections.
SAP does show they’re still investing in this existing dashboard product and finally some real innovation and enhancement is in place. If you look at the current state of SAP Design Studio, I think Xcelsius still is the best dashboard solution in SAP’s portfolio for the upcoming years.
A smart guy called Joseph Warbington discovered a way to test your dashboard in HTML5 and get the HTML5 ‘source’ files without publishing to the platform. He uses the temp folder of Xcelsius. Very smart
Check this page to find out how to do this.
The SAP BusinessObjects 4.4 mobile app will be released on December 15th 2012.
SAP press release: click here
This blog post has made it into a official SAP note on SAP Dashboards SP05. That’s funny .
On November 13th, the SAP BusinessObjects BI Suite 4.0 Service Pack 05 will come available on the SAP Service Marketplace.
With this, a preview of the HTML5 export for SAP Dashboards will be included. Since the 14th of November is my birthday, this looks like a nice ‘blue’ SAP present.
Important note! With this release, you won’t yet be able to publish to mobile devices. The technical prerequisite for this is the SAP BI mobile app version 4.4. This version isn’t available yet but is expected somewhere in or near Q4 2012.
So what can you do with this update? You can play around in SAP Dashboards designer mode to get acquainted with the supported components, UI enhancements etcetera. Great to see that SAP is really enhancing this product.
Make sure you’ll note this date in your agenda and start downloading the software right away!
If you’re interested in some pre-launch distributed information, make sure you’ll check the following links.
Update November 12th: Service Pack 05 is available on SCN, one day earlier Thanks to Xavier for the hint!
This blog will be updated regularly with SAP BusinessObjects Analysis edition for application design (ZEN) content and resources. If you have useful resources you want to share, send me a message and I’ll add them to the list.
Since this is a new product, more content will start popping-up on the internet very soon, especially since the launch of the product beta. I’m trying to stay on top of this product, since it is positioned as SAP’s future ‘Dashboard solution’. Today (June 3 2012) I have not seen any info on the visual design aspects of the solution to give me some benchmark and comparison material to SAP Dashboard Design / Xcelsius. Time will tell.
For now, gain knowledge and wisdom by checking out the resources below.
Video: Dashboarding Statement of Direction webinar recording (Youtube)
Blog: My personal ZEN wishlist including interesting wishes in the comments
Q&A: Anita Gibbings does the Dashboard Statement of Direction follow up > great value!
There is lots of stuff we’d like to see in a new version of SAP Dashboards / Xcelsius. Probably the HTML5 version will focus mainly on HTML5 export functionality so lets stretch the wish list towards ZEN (I don’t want to type that 2314 counting character official product name).
If I look at SAP Dashboards / Xcelsius I’d love to see the following features being made available in a next version of SAP Dashboards or the new product ZEN. It is quite a wish list and I know that some of these things can be fixed with some creativity, but I’m looking for out-of-the-box functionality.
Here it comes..
- Help screen pop-ups / mouse overs
Now this is possible but requires to much tricks. The time of paper documentation is moving behind us. I’d like to see functionality to easily build integrated help functionality. With this I mean that I don’t need to create a background menu, transparent background to show over the dashboard, 10 custom label objects, a ‘close-window’ push button and some dynamic visibility logic to start the circus. Just provide help menu’s which are easy to configure.
- Decent printing options
I shouldn’t rely on 3rd party solutions for being able to print the dashboard the way I want it, including some simple annotations.
- Decent commenting options
This is not supported. Connecting to a remote database and store/retrieve comments is possible, but too much customizing.
- Flexible change of chart type (like in Webi)
I often use the Combination Chart just in case I want to change the chart type afterwards from line to bar chart. If I don’t do this, I’ll need to reconfigure the cell binding, properties, alignment, etcetera. Webi handles this much better.
- More developer-friendly drag and drop of components and objects
The amount of time you spend to align, resize and position objects can be reduced if this is improved. Selecting objects and moving them around sometimes works a bit buggy. Please fix this.
- New version of the Open Document Statement integration protocol. This should be ‘point-and-click’ easy
I shouldn’t need to be able to read HTML parameters for connecting BI content. Sure, it works OK and offers great functionality but this should be done like a ‘walk down the park’ instead of a ‘walk down the HTML parameter trial-and-error hell’. Make this point-and-click easy with a decent user interface.
- Easier integration between multiple dashboards
Jumping from one dashboard to another including parameters should be easy. This way you should be able to scale your development team without loosing interactivity. Now you often have one big sized dashboard with longer load times etc. Of course you can tune this with dynamic visibility, connection settings etc but cutting one dashboard into smaller pieces can have quite some advantages. Now this is possible, but only for advanced developers.
- Better support for custom fonts (include more than 1 custom font in the dashboard model)
The typography topic for dashboards is often completely skipped. I’ve seen and designed dashboards with a well designed typography model which really made a difference. Now the support for custom fonts is limited. If a user hasn’t got the used fonts on his machine, you can embed them in the dashboard. However, you can only embed one font. And flipping between serif and sans-serif for large headers and titles on one side and small lables and subtitles on the other side requires more than just one font.
- Debug mode for errors
Solving issues is often a complex process. An empty chart pops up. What’s going on? Does the connection not retrieve any data? Is the table range not large enough? Doesn’t the filtered row object pick the right label? Is the chart binded to the wrong cells? Is there a dynamic visability issue? Is there an authorization issue for the user? Is there no data at all in the source? And so on..
An advanced developer will be able to find the issue but this can require quite some time. I have been laughing quite often when an empty error dialog screen popped up in Xcelsius. Laughing only lasted for seconds, than the frustration came..
- CSS editor for easy theme and template creation
Xcelsius has some out of the box themes. Editing these themes is not possible for the average developer. In the installation folders of Xcelsius, CSS files are stored which contain all the styling. I’d like to see a modern CSS editor in which you can load, edit, save and share CSS templates. This way dashboard development can be taken to the next level.
- More flexible and detailed property options for all components
From a design perspective, Xcelsius falls short in some area’s. It does a real great job in the first 95% but as a die-hard, you also want to slam those last 5%. For example, a combination chart has no alerting options (comes in FP3). Setting markers in line charts (sparkline chart excluded) is only possible for every value on the X-axis. I, the designer, want to be able where and how the markers should be applied. For example one on the highest or lowest, and one in the end, not just everywhere.
The default legenda looks just ugly. I want to be able to make a more sophisticated legenda. And why can’t I set the scale range for the microchart? Now two charts cannot be compared since they can have a different scale range. Not to speak about the number of times I had to copy multiple graphs on top of each other to be able to create the chart looking exactly the way I wanted it to do. And for charts with a scale from negative to positive values I want to be able to make the X-axis line for the ’0′ Y-value a bit thicker but I’m only able to make the bottom X-axis line thicker (the lowest value line). This is just a small set of examples of stuff you just wanted to be able to configure slightly different, with a big positive impact on the user experience.
SAP Dashboards / Xcelsius has surprised me time after time by it’s flexibility and ability to realize requirements by applying ‘tricks’ and ‘voodoo magic’. This makes it that I love the product. Possibilities sometimes look endless. But when someone has to support this magic dashboard full of MS Excell spells and dynamic visibility voodoo, you may loose some friends.
Therefore I like to see some of this magic back in the standard component properties and menus. What does your wish list look like?
Live blogging in bullet style…
SAP Dashboards Enhancements:
- FP3 will bring drill from SAP Dashboard Design model to SAP Transaction to empower action-driven dashboards
- SAP Dashboards is not a Deski case because there is no ‘Webi’ replacement
- Not clear when SAP Dashboards will be ‘replaced’ by ZEN
- Still money being invested in SAP Dashboards features and mobilization
- First focus on mobility support
- Looks like there isn’t many being upgraded in the development area
- Focus more on new visualizations (Waterfall chart and alerts for combination charts)
- Focus more on performance and stability
- Mobilized version of SAP BO Dashboards will be released to improve mobile functionality
- SAP for now points towards partners to get SAP Dashboards on mobile devices as long as they haven’t released their own HTML5 version
- Offline access to dashboards will be made available
- Overview of mobile features in slide below
- Great amount of SAP Dashboard components are supported in HTML5 version
- ZEN Preview and beta around summer 2012
- ZEN Ramp-up planned for end of 2012
- ZEN GA somewhere in 2013
- Initial release of ZEN focusses on SAP HANA and SAP BW multidimensional models including hierarchies
- HTML5 SDK being looked into to be able to develop custom HTML5 components
- ZEN only available through SAP BusinessObjects BI 4.0 platform, not on older versions
- ZEN will be a client development tool to create dashboard models, then distribute through platform
- ZEN stands for SAP Business Objects Analysis, edition for application design
- ZEN will have a SDK
- ZEN is the ‘new’ web application designer
- Uses Eclipse technology
Conversion of SAP Dashboards to ZEN
- There is a plan to bring SAP Dashboard models into the ZEN solution
- It should be a seamless integration (duh?!)
- No needed redevelopment is talked about
- ZEN output / visualisation is natively HTML5
I will share all slides from the webinar after I’ve received them.
More info on ZEN can be found here.
Update May 10, 2012:
ASUG Webcast summary on ZEN. Lots of information.
Update June 2, 2012: