At Visual BI, we are constantly tasked with unique visualizations requested by our customers which challenge the boundaries of what is possible in standard SAP Design Studio/ SAP Lumira Designer. This often leads to a  mashup of Standard SAP Lumira Designer and Visual BI Extensions(VBX) to create visualizations that bring in a lot of value by helping them solve their business problems.

 

Problem Statement

To achieve the following use case, we would need to customize the data labels to display dimension names instead of measures. Such customization would require a lot of scripting and CSS using standard scatterplot in SAP Lumira Designer. This could be easily achieved using the Visual BI extensions(VBX) Scatterplot.

Scatter plot in SAP Lumira Designer

You could also be more creative and replace the county labels with flag images, like one below.

Scatterplot with Images in SAP Lumira Designer

Scatterplot

Scatterplots are mainly used for correlation analysis between 2 measures. They help us understand the relationship between the measures by plotting them on X and Y Axis respectively. This way each data point is an intersection of the 2 values being analyzed which are represented with different symbols and color, depicting distinct groups in some use cases. Further, they are also used for outlier analysis and clustering

Let’s look at the step by step process of fulfilling the above requirement

 

How to create a Scatterplot using Visual BI extensions (VBX) ?

Sample Data

 Sample Data for scatter plot

 

Step 1: Drag the Visual BI extension (VBX) Scatterplot to the canvas and navigate to the Data Series Property Tab.

  • Enable Data Labels
  • Set the Series color to white for all the dimension members (#FFFFFF)

Sap Lumira Designer , Visual Bi extensions

Sap Lumira Designer , Visual Bi extensions

 

Step 2: Navigate to the Legends tab and disable the Legends

Sap Lumira Designer , Visual Bi extensions

 

Step 3: Next navigate to the Title tab and set the Title formatting properties as follows:

  • Title Text
  • Alignment (for more flexibility use Horizontal and Vertical offset)

Sap Lumira Designer , Visual Bi extensions

 

Step 4: Navigate to the CSS Tab, check the Custom Theme property and copy the following script.

Sap Lumira Designer , Visual Bi extensions

Sap Lumira Designer , Visual Bi extensions

 

Step 5: Navigate to the Subtitle Tab and uncheck the subtitle option

Sap Lumira Designer , Visual Bi extensions

 

Step 6: Set the X axis properties as follows:

  • Set the Label suffix to %
  • Set the Title text and alignment
  • Set the grid line to color – No fill

 Sap Lumira Designer , Visual Bi extensions

 

Step 7: Navigate to the Y Axis Tab and set the properties as follows:

  • Set the prefix to €
  • Set the Title text and alignment

 Sap Lumira Designer , Visual Bi extensions

 Sap Lumira Designer , Visual Bi extensions

 

Our scatterplot is ready

 Scatter plot in SAP Lumira Designer

 

You could also create the same by using a Bubble chart with similar customization.

However, Bubble chart requires 3 measures as compared to scatterplots which require only 2 measures. To achieve the above use case using bubble charts, you would need to create a dummy variable for the bubble size.

For innovative use case on bubble charts click here  

Click here to download a FREE 15-day trial of Visual BI Extensions for SAP BusinessObjects Design Studio/SAP Lumira Designer.

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