Acquire a Dataset and Create a Visualization in SAP Lumira Cloud for BusinessObjects 4.1

  • by Adam Getz, Manager – Business Intelligence, CGI Federal
  • June 5, 2015
Learn how to import a basic dataset into SAP Lumira Cloud and how to create simple visualizations based on the imported dataset. These features are demonstrated in SAP Lumira Cloud, a cloud installation of SAP Lumira.
Learning Objectives

Reading this article you will learn how to:

  • Acquire and import a dataset for SAP Lumira Cloud
  • Build a basic visualization in SAP Lumira Cloud based on the acquired dataset
Key Concept

SAP Lumira Cloud is a relatively new end-user application within the SAP BusinessObjects 4.1 suite that provides data visualization and discovery capabilities. Fundamentally, SAP Lumira Cloud is a self-service user application that allows organizational analysts and decision makers to access, transform, explore, and visualize data in a highly intuitive format. SAP Lumira Cloud can be used to prepare data from multiple sources, visualize the data, and then compose sharable stories from those data visualizations. Moreover, users of SAP Lumira Cloud can quickly build data visualizations with just a few clicks in order to discover hidden insights within the data.

SAP Lumira Cloud is a Software-as-a-Service (SaaS) solution that helps business users visualize, make sense of, research, and better present their data. With SAP Lumira Cloud, users can rapidly import data from a data file and accurately convert the data into various graphical visualizations so that the data can be analyzed from many perspectives and views. The benefit of SAP Lumira Cloud is that allows business users to quickly acquire access, view, and examine data in a secure cloud environment with minimal involvement from IT personnel. In this article, I provide step-by-step instructions for how to acquire a dataset by importing from a data file, and how to construct a basic graphical visualization based on the dataset. In the example, I use a comma separated value (CSV) file as the data file, and I demonstrate three different ways to construct a column chart visualization from the fields in the dataset.

How to Acquire and Import a Dataset

In this section, I demonstrate how to create a dataset within SAP Lumira Cloud from a data file. It is possible to create datasets from Microsoft Excel workbooks (.xlsx) or CSV files in SAP Lumira Cloud. However, the number of columns in the Excel workbook or CSV file must not exceed 1,000. SAP Lumira Cloud supports integration with Excel 2007 or later.

Adam Getz

Adam Getz currently serves as a Manager, Business Intelligence for CGI Federal. In this position, he is leading a large business intelligence and data warehousing implementation for a federal client.  He is a thought leader in the field of information technology and an expert in the deployment of leading business intelligence, database management, and data integration products. He has presented at a variety of local, national, and international events, including the 2006 BusinessObjects International Conference, 2007 Oracle BIWA Summit, 2008 Oracle Open World, and 2010 and 2011 ASUG SAP BusinessObjects User Conferences. In addition, Adam is the creator and main author of, a website, portfolio, and blog that provides rich technical and functional content to business intelligence and data warehousing professionals. He has also published numerous technology white papers that have focused on various topics within business intelligence and data warehousing. Adam currently serves as the chairperson of the Washington DC Business Objects User Group.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.