Skip to Content

SAP Lumira is a data analysis and manipulation tool which can perform real-time analysis on any data volume. It offers various chart and graph options like bars, lines, pies, geographic chart, scatters, maps, tables and other charts which caters to various data visualization needs.


I have prepared a simple tutorial to consume data from an excel spreadsheet and create a 3D Column chart.

Steps to build visualization

1. Connect to data source

1.1. Click on MS Excel (data file used is an excel spreadsheet)

/wp-content/uploads/2013/06/p1_234242.jpg

1.2. Choose the required data acquisition options

  1. Data sheet to be consumed
  2. Data columns to be included
  3. Other options

/wp-content/uploads/2013/06/p2_234243.jpg

2. View and organize columns and attributes

    From the attributes list, identify the attributes for measures and hierarchies.

2.1. Manually create measures

      Right click on attribute and click on create a measure option.

/wp-content/uploads/2013/06/p3_234244.jpg

2.2. Manually create hierarchy

2.2.1. Choose from the options for hierarchy creation as required

/wp-content/uploads/2013/06/p4_234248.jpg

2.2.2. Choose the hierarchy levels as applicable

/wp-content/uploads/2013/06/p5_234249.jpg

 

2.2.3. Accept the hierarchy propositions

/wp-content/uploads/2013/06/p6_234250.jpg

Alternatively, enrich all feature (highlighted in the above screenshot) can be used to apply possible enrichments.

3. Choose a working view and chart type


I have chosen 3D Column Chart to display Annual Revenue by Customers during the five year period.

/wp-content/uploads/2013/06/p7_234252.jpg

Steps involved in creating this chart are explained further.

4. Build your chart step by step

4.1. Drag and drop Revenue to Y Axis 1 under the Measures section

/wp-content/uploads/2013/06/p8_234254.jpg

4.2. Drag and drop Year attribute to Legend color under Dimension section

/wp-content/uploads/2013/06/p9_234255.jpg

4.3. Drag and drop Customer attribute to X-axis under Dimension section

/wp-content/uploads/2013/06/p10_234256.jpg

The above visualization clearly displays the Annual Revenue by Customers over the 5 year period.

5. Save the visualization

Click on the save button as shown.

/wp-content/uploads/2013/06/p11_234257.jpg

Visualization is saved as highlighted in the above screenshot.

6. Share the Dataset/Visualization

As shown below, Dataset can be exported as file, published to HANA, Explorer and StreamWork.

Visualization can be shared via email, published to StreamWork.

/wp-content/uploads/2013/06/p12_234258.jpg

Some of the other visualizations that I created for this dataset are:

1. Seasonality in Revenue – Column Chart

/wp-content/uploads/2013/06/p13_234259.jpg

2. Customer loss or gain – Column Chart

/wp-content/uploads/2013/06/p14_234266.jpg

3. Annual Revenue trends – Line Diagram

/wp-content/uploads/2013/06/p15_234267.jpg

4. Revenue from top 3 customers for a given division, year – Table chart

/wp-content/uploads/2013/06/p16_234268.jpg

5. Revenue by division, year – 3d Column Chart

/wp-content/uploads/2013/06/p17_234269.jpg

6. Net sales from various customers for a given division – Pie Chart

/wp-content/uploads/2013/06/p18_234270.jpg

7. Revenue by country, customer and year – Table Chart

/wp-content/uploads/2013/06/p19_234271.jpg

I hope this tutorial was helpful.

Please refer below link for more information.

http://scn.sap.com/docs/DOC-29107

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Henry Banks

    Hi,

    Any chance you could update your screenshots?   it’s the old ‘visual inteligence’ user interface, and these images are very small resolution (don’t get bigger when you click on them)

    regards,

    H

    (0) 

Leave a Reply