Business Intelligence

Creating Crosstabs in SAP Lumira, Discovery Edition

Like most tasks within SAP Lumira, discovery edition, you can create a crosstab completely by using drag and drop functionality.

 

In this blog post, let’s look at how you can create a crosstab, and what kind of customizing options are available.

 

Adding a New Crosstab

To create a new crosstab, follow these steps:

  • Insert a new chart on the canvas and select the Crosstab option.
  • You can start adding dimensions and measures on the crosstab component on the canvas. In this case, we want to use some detailed features. Maximize the crosstab by clicking the Maximize button.
  • Drag the Revenue measure into the Measures box.
  • You’ll see that, by default, another Measures object appears in the Columns box. This object can be moved to the Rows box if you want to see the measures in the rows. For now, just add the Genre dimension to the Rows and Year to the Columns as shown in the figure below.
Add Crosstab in SAP Lumira

 

Formatting

You can adjust the look of a crosstab. This includes not only the way the elements of the crosstab are visually displayed, for example using coloring, but also how the values of the dimensions and measures are presented, for example without decimals.

 

You can enlarge the width of a column by dragging the column border between two columns. To rename the title of the crosstab, just double-click it or right-click it and choose Rename Title.

 

By right-clicking on any element of the crosstab, the associated context menu will pop up. Here you can find the Formatting options for that part of the crosstab. This includes the Font Type, Font Size, Alignment, font weight (Bold), and style (Italic), as shown in the following figure.

 

Formatting Crosstab in SAP Lumira

 

Furthermore, there are options to change the Font Color and the Background Color. There are four areas that can be formatted individually: Headers, Row objects, Column objects, and the Result area. Note that this kind of formatting is in no way related to the values themselves. For that functionality we can use conditional formatting.

 

Customizing Crosstab in SAP Lumira

 

The context menu also contains a Display option. Here you can change whether only the Text value of a dimension member, or also the Key value should be shown. You can also show both and choose the required order.

 

Display Options for Crosstab in SAP Lumira

 

The Number Format option (see below) determines how a measure value should be displayed in the result area. Here you can set the Scaling Factor, the number of Decimal Places, and how the Units and Scaling Factors should be represented in the crosstab. For this last option, you can choose between Display Both in Header, Display Units in Data Cells, or Do not Display.

 

Number Format for Crosstab in SAP Lumira

 

The next figure shows these three options side by side.

 

SAP Lumira Crosstab Comparison

 

Conclusion

With the information outlined above, this blog post has given you a better idea of how to create a crosstab in SAP Lumira, Discovery Edition. Whether you’re creating or formatting a crosstab, you now have the skillset to help make your data pop in various visualizations.

 

Editor’s note: This post has been adapted from a section of the book SAP Lumira, Discovery Edition: The Comprehensive Guide by Xavier Hacking and Martijn van Foeken.

Recommendation

SAP Lumira, Discovery Edition: The Comprehensive Guide
SAP Lumira, Discovery Edition: The Comprehensive Guide

Are you looking for a better approach to data visualization? Learn what tools SAP Lumira, discovery edition gives you to create interactive charts and infographs! Start by acquiring your data, either offline or live, and explore the available data manipulation actions. Next, create charts, from heat maps and scatter plots to bubble charts and geo maps. Export your data, integrate with SAP BusinessObjects BI, and take a look at your mobile options to get the most out of SAP Lumira, discovery edition!

Learn More
SAP PRESS
by SAP PRESS

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP CX, intelligent technologies, SAP Business Technology Platform, and more!

Comments