This is part of the SAP Lumira Discovery blog series.
Crosstabs are commonly used in representing and organizing raw data. They are best suited for displaying simple relationship between the qualitative and the corresponding categorical value and help in providing both summary and granular level details which sometimes charts fail to convey.
Let’s look at some of the new features in SAP Lumira Discovery crosstab:
- Context Menu
- Swap axis
- Number formatting
- Conditional Formatting
- Sorting/ ranking
- Look and feel
- Calculated key fig
1. Context Menu
A major upgrade from the older version is the enhanced context menu. Just right click and one can access all the important feature/functionalities of the crosstab.
2. Hierarchical Drilldown
Unlike the previous version, the new cross tab in SAP Lumira Discovery comes with robust drilldown and interaction capabilities. Following functionalities can be achieved using hierarchies in crosstab:
Drill up – Helps you drill a level up the hierarchy
Drilldown – Helps you drill a level down the hierarchy
Drill By – Similar to drill down operation. The only difference is that it displays the initial level along with the one below.
Drill Path – It helps choose the drilldown path in case the dimensions have more than one hierarchy drilldown paths.
3. Swap Axis
Just like the crosstab in SAP Lumira Designer the swap axis option has been included in the SAP Lumira Discovery Crosstab as well. Thus, giving the user the ability to toggle axis on runtime.
4. Number Format
Now it is easier formatting numbers in crosstab using the number format property where one can setup their own scaling factor and decimal places with the display options.
5. Conditional Formatting
Just like other components in SAP Lumira discovery, the crosstab can now leverage the conditional formatting rules set for the whole dashboard in general instead of component specific conditional formatting rules. Also, one can enable, disable and edit conditional formatting rule on runtime, thanks to the new context menu-
In SAP Lumira 1.X you would have noticed that one could filter only on the dimensions present in the crosstab. With SAP Lumira 2.0 this limitation has been overcome. One can now filter on any dimension present in the data source irrespective of it being present in the crosstab.
7. Sorting and Ranking
Sorting and ranking has become simpler than before as there is no need to go to the explore mode like the earlier version. Simply right click and sorting and ranking options pop up.
8. Look and Feel
The new crosstab just got a UI/UX upliftment with various formatting options. A simple right click will let you access a galore of formatting options.
- Font – Font Type, Size, Bold/Italic and Color
- Background Color
Note: It is now easier for designers to directly enter the hex values in the color pallet to change the background and font color
Overall the calculations have remained same, except for becoming readily accessible under the context menu
The following are the runtime calculation which can be created in the crosstab:
- Running Calculations
- Moving Average
- Percentage off
- Difference from
- Custom calculation
So, to sum it up, the crosstab has become more robust in terms of interaction, look and feel. Thus, giving the end users easier navigation and enhanced run time capabilities.
For interesting use case on SAP Lumira Designer crosstab using VBX please refer – Images within table in SAP Lumira Designer