We are now part of Eviden, discover more...

Recently, a customer mentioned to us that there was some difficulty that executives were going through in interpreting some charts. That got us thinking and helped us realise the true power of Trellis charts that was the answer to the problem.

In this customer’s case, the dashboard was designed using SAP DesignStudio 1.2 & we were restricted(due to the tool’s limitations) to using traditional charts to represent complex multi-dimensional data. But, that changed with the advent of Sap DesignStudio 1.3 which brought along with it, the Trellis charts that made the data interpretation a lot easier.

Here is the sequence of steps on how to use Trellis charts. A business use-case follows too.

Drag a chart on to the canvas. Under the properties of the chart, navigate to ‘Chart Type’ and choose ‘Additional Chart Types…’. We have used a Trellis Bar Chart here. If a data source has been linked to the chart, the dialog box that pops up will list the dimensions and measures available in the data source.

Trellis Charts in SAP Design Studio 1.3

In ‘Chart Population’, use the appropriate measures and dimensions, to design the trellis chart. The properties under ‘Chart Population’ are:

  • Primary Values – These can only take measures. These are the values in the chart.
  • Axis Labels – These are the axis labels in the chart.
  • Chart Multiplier – This represents the dimension according to which information is grouped and indexed.
Trellis Charts in SAP Design Studio 1.3

Consider a case where an executive would like to track his company’s profit / loss in different regions, across 4 years.

  • Key Figure to be displayed is profit / loss
  • 4 Years – 2011, 2012, 2013, 2014
  • 4 Regions – Midwest, Northeast, South, West

This is the initial view of the data source (here, a BEx query).

Trellis Charts in SAP Design Studio 1.3

Configuration must be done as shown. The conditional variable in this case, region (ZR_REGKY ), is to be set as the multiplier. This means grouping will be done by region, and each region will appear in one column since we are multiplying by columns.

Trellis Charts in SAP Design Studio 1.3

This is the output we get:

Trellis Charts in SAP Design Studio 1.3

The power of trellis charts becomes apparent when we need to compare key figure values on more than two dimensions. Let’s step up the scenario one notch and compare profit / loss for each product group across different regions for multiple years. We have a data source that looks like this:

Trellis Charts in SAP Design Studio 1.3

This is where setting up the trellis chart gets a tad bit tricky.

Trellis Charts in SAP Design Studio 1.3

Going by the traditional setup for the same data, we didn’t see much of a difference – the additional dimension was merely concatenated to the existing one. This is quite a nag for the user, who has to scroll to be able to view all of the data.

Trellis Charts in SAP Design Studio 1.3

While trying to best what we had on hand, we came across a small option hiding under ‘Additional Properties’ of the chart.

Trellis Charts in SAP Design Studio 1.3

By restricting the number of values shown per column under multi-layout, we were able to bring the chart into a very neat format where data would be shown organized in a way that users will quickly be able to comprehend. The result of using the option was this.

Trellis Charts in SAP Design Studio 1.3

Combined with the use of alerts and drilldowns, these charts have proved capable of providing quick clear insights, when comparative analysis of multidimensional data is needed.

Read more blogs from SAP BusinessObjects Design Studio category here.

Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192


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!