Skip navigation

Business Intelligence

2 Posts authored by: Sean Fesko

Excerpt from the book SAP Lumira, Discovery Edition: The Comprehensive Guide by Xavier Hacking and Martijn van Foeken. Used with permission of SAP PRESS. All rights reserved.

 

Learn how to get raw Microsoft Excel data into SAP Lumira documents.

 

Microsoft Excel spreadsheets are wildly popular, and this won’t change for a long time. These spreadsheets are a simple, convenient way to store, present, and analyze data, as there is no need to set up a complicated database infrastructure to create and use them. Of course, problems arise as soon as spreadsheets need to be up-scaled, to include more and more data, and to be used by more than a single user.

 

SAP Lumira, discovery edition can acquire data from one or multiple Microsoft Excel files. Supported versions are Microsoft Excel 2007 (.xls file extension), 2010, 2013, and 2016 (.xslx file extension). SAP Lumira, discovery edition can retrieve data from one sheet or all sheets of a spreadsheet. Also, the range of rows and columns that need to be imported can be defined.

 

If you want to acquire data from multiple files, then the rows from all files are appended in the same dataset. A new column named Source file is added to the dataset, which states the title of the source file for each record. The first file that you add is used as a reference template for the column definitions. This means that the header is taken from this file if you use the Set first row as column names option.

 

It is important that the other files have the same setup as the initial file. If another file has fewer columns, or the data types of its columns do not match the ones from the initial file, SAP Lumira, discovery edition will not allow the file to be imported. In case another file has more columns, the extra columns are not added to the dataset.

 

To create a new dataset from one or multiple Microsoft Excel files, follow these steps:

  1. Select Microsoft Excel from the Data Source menu on the home page of SAP Lumira, discovery edition. If you want to add a data source to an SAP Lumira document, use the New Dataset option in the Data menu.
  2. Select your Microsoft Excel file or files in the Open dialog.
  3. Click Open to close the dialog window. A new popup window is shown. Here we see a preview of the dataset and further information and settings for this acquisition (see the figure below). If you added multiple files, the additional Source file column is added at the end. The Sheet dropdown menu contains only sheets from the initial Microsoft Excel file.

 

05_001.jpg

 

  1. Change the Dataset Name.
  2. To add more files, use the Add Files button to open the Open dialog window again and browse for additional files. To remove files, you can delete the file location in the Files box or click the Clear Data button to remove all files.
  3. If your Microsoft Excel file contains multiple sheets, select the correct sheet in the Sheet dropdown menu.
  4. Select the Append all sheets option to include all the data from all the sheets. An additional column Source sheet is added to the dataset.
  5. Select Set first row as column names to use the values that are in the first row as the labels for each column in SAP Lumira, discovery edition. If you disable this option, the column names are displayed as Column_<n>, where <n> is the number of the column.
  6. Depending on the setup of the data in the spreadsheet, select the correct Table Header Type. In most cases, a Standard Table (No Transformations) is used. In such a table, all the values are organized in rows, as shown in the left table of the figure below. The right table of the figure below demonstrates how a cross table uses headers in both the columns and rows to organize the values.

 

05_002.jpg

 

  1. Click Show Record Count to display the total number of columns and records in the dataset.
  2. Deselect the columns that you don’t want to import. You can check Use Select All to include all the columns again.
  3. Below the preview table, click Advanced Options. Here you can enable or disable the retrieval of data from hidden columns and rows (Show Hidden Columns or Show Hidden Rows).
  4. Select Detect Merged Cells. With this option, all cells of a merged cell are filled with the value of the merged cell. If you don’t check this option, only the first cell is filled with the value.
  5. In case you selected Standard Table (No Transformations) as the Table Header Type, you can alter the Range Selection to a Custom Range. Enter the coordinates of the top-left and bottom-right cells that contain the data that needs to be acquired (for example, B2:K76) and click Apply. In addition, you can change the number of rows that need to be used as the header.
  6. If you choose Cross Table as the Table Header Type, you can change the number of Columns and Rows that must be used as headers (see the figure below).

 

05_003.jpg

 

  1. Click Visualize to finish the data acquisition and import the data into your SAP Lumira document.

 

Data acquisition is the first step to creating an SAP Lumira, discovery edition story, but Microsoft Excel spreadsheets are only one of the supported data sources. How do you begin your stories?

 

Excerpt from the book SAP Lumira, Discovery Edition: The Comprehensive Guide by Xavier Hacking and Martijn van Foeken. Used with permission of SAP PRESS. All rights reserved.

Follow SAP PRESS on LinkedIn for info on new releases, news, and more!

Excerpt from the book SAP Predictive Analytics: The Comprehensive Guide by Antoine Chabert, Andreas Forster, Laurent Tessier, and Pierpaolo Vezzosi. Used with permission of SAP PRESS. All rights reserved.

 

Take a look at all the steps required to install the SAP Predictive Analytics client.

 

In this blog, we’ll cover all the steps required to install the SAP Predictive Analytics client. We’ll cover downloading the product, system requirements, the installation process itself, and the checks you should perform once the installation is complete.

 

Downloading the SAP Predictive Analytics Client

 

Client versions can be found under the folder PREDICTIVE ANALYTICS CLIENT 3, as shown in the following figure. Please note that you’ll need to select the proper operating system from the dropdown menu on the right.

03_005.jpg

System Requirements

 

The SAP Predictive Analytics 3.2 client can be installed on any of these systems:

 

  • Microsoft Windows Server 2012 R2, 64-bit version
  • Microsoft Windows Server 2016, 64-bit version
  • Microsoft Windows 8 or 8.1, 64-bit version
  • Microsoft Windows 10, 64-bit version
  • Red Hat Enterprise Linux 7.0+ and 7.2 versions
  • SUSE Linux Enterprise Server 11.3+ and 12.0+ versions

 

Some requirements for installing the SAP Predictive Analytics client include the following:

 

  • Free space on hard disk: 475 MB recommended
  • RAM: 1 GB

 

Installation Steps

 

For a Microsoft Windows operating system, double-click on the client executable that you downloaded to start the installation.

The installation wizard will take you through the following steps:

 

  1. In the Corba Name Server Information screen, enter the TCP/IP address and port number of the SAP Predictive Analytics server.
  2. It is followed by the License Agreement and the Select Destination Location screen.
  3. On the Select Components screen, select the Full Installation option.
  4. It is followed by the Select Start Menu Folder and the Select Additional Tasks screen. Finally, in the Ready to Install screen, click the Install button to start the installation.

 

For a Linux operating system, before installing the SAP Predictive Analytics client, you’ll need to ensure that the correct Java Virtual Machine (JVM) or Java Runtime Environment (JRE) is set up on your computer.

 

Learn more about setting up the Oracle JRE at https://docs.oracle.com/javase/8/docs/technotes/guides/install/linux_jre.html#CFHBJIIG.

The SAP JVM can be downloaded from SAP Support Portal.

 

Refer to the Product Availability Matrix (PAM) to see exactly which versions are supported at https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/PAM_Predictive_Analytics_31.pdf.

 

The deployment procedure consists of unzipping the client .tar file in the target location, for example, in soft/:

 

$ gunzip -c </directory/containing/the *.TAR> | tar -xvf –

 

Checking the Installation

 

When the installation is complete, you should launch the client and connect to the SAP Predictive Analytics server to verify that the connection works. At the same time, you can check that the proper license is also in place on the server.

 

You can verify the version of the server in the About menu of the client, as evidenced by the figure below. If the authenticated server is running correctly, the Modeling Server Status field will display Modeling Server running. This panel also allows you to see the product version of the connected server.

 

You can also check that the proper licenses are in place on the server by looking at the tabs Generator Licenses, Component Licenses, and Data Access Licenses.

03_006.jpg

Starting the Client on Linux Operating Systems

 

To launch the client in Linux and connect to the SAP Predictive Analytics server to create predictive models, use the following command:

 

$ AutomatedAnalyticsClient_<SYSARCH>_v<version number>/KJWizardCORBA/

KJWizardCORBA-Authenticated.sh <Name of the server>

 

Related Resources: The SAP Predictive Analytics Client Installation Guide: http://bit.ly/2hyfo9E

 

Excerpt from the book SAP Predictive Analytics: The Comprehensive Guide by Antoine Chabert, Andreas Forster, Laurent Tessier, and Pierpaolo Vezzosi. Used with permission of SAP PRESS. All rights reserved.