Blogs / SAP / SAP BusinessObjects / SAP Design Studio / Data Source Modification through Chart Properties in SAP Lumira Designer

Data Source Modification through Chart Properties in SAP Lumira Designer

Sep 11, 2017

SHARE

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 through Chart Properties in SAP Lumira Designer

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 through Chart Properties in SAP Lumira Designer

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 through Chart Properties in SAP Lumira Designer

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 through Chart Properties in SAP Lumira Designer

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 through Chart Properties in SAP Lumira Designer

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

Data Source Modification through Chart Properties in SAP Lumira Designer


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 through Chart Properties in SAP Lumira Designer

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.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!