To configure a chart in SAP Design Studio, we often need to edit the initial view of the data source and this requires us to switch between data source modification and chart property windows. SAP Lumira Designer changes the way we customize our charts by introducing a new chart configuration window. Apart from changing various chart properties, we can also modify the data source within this window and quickly see how the visualization changes.

The Chart Configuration Window

In SAP Lumira Designer, the chart-specific properties that were earlier located in the Additional Properties window is now moved to the new Chart Configuration window. The option to select the chart type is removed from Properties tab and we can now change the chart type inside the Chart Configuration window.

Data Source Modification using Charts Configuration - 1

When we open the Chart Configuration window, we have options to change the chart type, swap or rearrange measures and dimensions and modify properties of different parts of the chart such as the axes, legends, tooltips, etc. For more details on chart formatting properties refer to our Chart Property Editor blog.

Data Source Modification using Charts Configuration - 2

Data Source Modification

Within the properties of the chart, you should notice an additional option labelled “Allow Data Source Modification”. This property will allow us to modify the dimensions/measures in the rows/columns of the data source from within the Chart Configuration window.

Data Source Modification using Charts Configuration - 3

Once the Data Source Modification property has been enabled, when users navigate to the Chart Configuration window, they should be able to see the option to add or remove objects to the axes of the chart.

Data Source Modification using Charts Configuration - 4

Let’s consider an example where we have ‘Sales Amount by Region’. Now, we want to change the chart around to display ‘Cost Amount’ and ‘Profit / Loss’ in addition to the Sales Amount. We can achieve this by using the option to add additional Dimensions/Measures to the Chart’s Data Source from within the Chart Configuration window.

Data Source Modification using Charts Configuration - 5

Once we’ve added the additional measures, our chart should look like the one previewed in the screenshot below:

Data Source Modification using Charts Configuration - 6

The Chart title automatically changes based on objects that are added. If required, we can change the title using the ‘Properties’ tab within the Chart Configuration window.

The Properties tab can be used to modify different parts of the chart such as the legends, labels, axes, tooltips etc.

Data Source Modification using Charts Configuration - 7

The Chart Configuration window allows developers to preview a chart even when the Data Source linked to the chart has not been loaded (i.e. ‘Load in Script’ has been set to ‘true’).  However, when using the Chart Configuration window for Data Source modification, there are a few pointers to keep in mind:

  1. Adding or removing dimensions/measures within the chart configuration window affects the original data source. So, any other component linked to the data source will be affected.
  2. When ‘Allow Data Source Modification’ is set to ‘true’, users will also be able to modify the data source using the ‘Chart Feeding Panel’ during run time.
  3. Any background filters set on the data source cannot be edited.

Conclusion

The Chart Configuration options within SAP Lumira Designer has integrated the additional properties of a chart from previous versions of SAP Design Studio with certain additional options such as being able to swap dimensions between rows and columns and even change the chart type, all within one single window. But it also introduces newer options such as the ability to modify even the data source through the configuration, as we’ve just seen.

Got questions? Click here to get in touch.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com