SAP Design Studio 1.4 is now GA and it offers loads of new exciting features. With every release, the tool is getting bigger and better and so are the Application Designer and the What’s New guides ! Here is my take on most of the new features.
The one feature that really intrigued me was ‘Online Composition’. In fact, this was the first feature I tried out, in SAP Design Studio 1.4.
Users can now save navigation states as portable fragmented bookmarks which can be used in other applications by leveraging the ‘Fragment Gallery’ and ‘Split Cell’ components. Fragment Gallery looks more like the ‘Sliding Picture Menu’ in SAP Dashboards (formerly Xcelsius). The Split Cell component is used to display the contents of the Fragment Gallery component. All you need to do is just drag and drop the saved scenario from the Fragment Gallery onto the Split Cell component.
We can have any number of Split Cell containers as seen below. Each of these charts is in a Split Cell Container and they are dragged from the Fragment Gallery at the top.
For more information on Portable Fragment Bookmarks and Fragment Gallery refer this blog.
The Undo Feature
One feature that I really missed in SAP Design Studio was a reset button. Until now, we had to write code to clear the filters, manage visibility of components etc, which was very tedious. But now SAP has introduced new methods to undo and reset the navigation in your analysis application.
In SAP Design Studio 1.3 we had a feature called Personalization where users could set personalized views as their initial view. In addition to that, users can now ‘undo’ navigation and selections in their analysis application using State.backOneStep() and State.backToStart(). This is very useful in scenarios where users want to reset their dashboard to the initial state or trace back their navigation.
Note: Before we use these methods, it is important to set the new Application Property called ‘Maximum Number of Steps Back’ (Behavior section in the Application Properties window) to an integer value. This is initially defaulted to zero and hence might not work. So ensure that you have specified the number of steps to undo.
There are a number of enhancements that have been added to the Crosstab component. To start with, we can enable context menu at run time, which provides a number of options such as sort dimensions, change member display, filter members, drilldown, swap axes among others. This looks similar to the options available in the BEx Analyzer. Users need to add the ‘Context Menu’, which is available as part of ‘Technical Components’, to use this feature.
During run time, users can right click on a particular member to view the context menu.
One issue I face with this feature is that, sometimes when I try to right click on a member, I get a pop up of the browser menu.
The look and feel of the Crosstab component has also been enhanced. In the prior versions, there was an issue with viewing all dimensions when there were a number of dimensions in the Crosstab, since scroll bars appeared only for measures and not for dimensions. This has now been overcome using a new property called ‘Max width of header area’. We can specify the maximum width that can be occupied by the dimension (header) area and a scroll bar appears when it goes beyond the specified width.
However, when the width of the header is set to ‘auto’ and when the actual width of Crosstab is too less, the measure columns seem to disappear. Nevertheless, this is a very nice feature (screenshot below).
You can also ‘show/hide’ repeater texts for the Crosstab members (screenshot below).
We still don’t have the ability to wrap header titles in Crosstabs. Hope this feature is included in the next release. The mobile experience with Crosstabs is a lot better compared to the previous versions. But I am facing a few issues with the context menu pop up on mobile.
Apart from the Fragment Gallery and the Split Cell Container mentioned earlier, we have another new component – the Checkbox Group – Checkboxes grouped together, to function as a multiple selector component. We now also have the Component Search feature in the Components view. Finally !
Another personal favorite is the tooltip feature. We can now add tooltips to basic components like buttons, selectors, images, and input fields.
Dimension Filter and Filter Panel Component
A new property called the ‘Desktop Popup Style’ has been added to the Dimension Filter component. This can be set to true. I did not find much of a difference in the look and feel, except for the placement of the buttons ‘Apply’, ‘Back’ and ‘Show Selected Members’.
A new property called ‘Drag & Drop’ has been added to the Filter Panel properties. You can drag and drop objects between rows, columns and free characteristics, in the navigation mode of the Filter Panel. This is not available in the ‘only filtering’ mode. This again reminds me of the BEx Analyzer output.
Report to Report Interface
We can now jump from the SAP Design Studio application to target reports defined in the BW system. This is part of the Context Menu (Technical Components).
Global Script Functions
Another much awaited feature in SAP Design Studio is the ability to reuse functions. This is made possible using Global Script Functions. This is also a part of the Technical Components. For more information on Global Script Functions, check out this these 2 blogs – Global Scripting in Design Studio 1.4 and 1.4 new features: Getting familiar with the Global Script Function
Real Time Dashboards
We can now create visualizations with streaming data, based on near real-time connection to SAP HANA or SAP BW. This can be achieved using a combination of a SAP Design Studio extension for an SAP ESP (Event Stream Processor) Data Source, Time Based Line chart as a chart extension and the Timer custom component.
Apart from these, another notable feature is that we can now set margins as ‘auto’ during run time, using scripts. This can be done using ‘Layout.AUTO’ as seen below.
New methods to search Data Sources, get filter values applied in measures, get variable value, get count of page book etc. have also been introduced in SAP Design Studio 1.4
CVOM Chart Extensions
You can also install new chart types, developed with the SAP Lumira SDK, in SAP Design Studio. These are listed under Additional Chart Types for the standard chart component. For more on this, check out this blog – CVOM Extensions in SAP Design Studio 1.4.
Custom Data Sources:
One thing that a lot of us have been waiting for is support for Excel as a data source. Now we have the Data Source SDK which can access local data sources, web services etc. These custom data sources can be used by the SDK components for visualizations. I am currently exploring this feature. More updates on this soon.
For information on Data Source SDK check out –Design Studio SDK (1.4) – Datasource SDK Test
To conclude, SAP Design Studio 1.4 looks a lot more promising with all these new and exciting features. And this makes SAP Design Studio not the next best thing, but The best thing !