SAP Lumira 1.0 SP11 – New features at a glance

By Manikandan Srinivasan, Andreas Krause and John Mrozek.

Here is a preview of some of the new features in the soon to be released SP11 Lumira Desktop.

1.     New Data Sources

With SP11, we connect to several datasource-  OData, SFDC, Generic JDBC, GreenPlum, HANA JDBC, PostgreSQL SQL Anywhere, SAP ERP6, mySAP ERP 2004, SAP R/3 release 4, MySQL, Sybase ASE

Some Examples below:

SAP ERP Connector:

This section contains a description of the connection test results from SAP Lumira to a SAP ERP ECC 6.0. The tests were done via the Free-hand SQL option in SAP Lumira with the use of a SAP JCO Connector.

There are 4 types of Infosets available in a SAP ERP system:

1. Infoset based on a data retrieval program (can
   be internal or external program)
2. Infoset based on a direct read of a base table
3. Infoset based on a logical database
4. Infoset based on a join between different tables

Step-by-Step Procedure

Open SAP Lumira and create a new document.  Then select Freehand-SQL as data source

In the Freehand SQL select SAP ERP 6 JCO connector. Type in the connection details

Before using the connection a validation of the connection is required. Validate the connection to see the results as in the screenshot below.

Now the different Infoset types can be tested. In the following the results for the 4 standard Infoset types and Infoset names are described.

1. Infoset  with a data retrieval program as data source . Infoset:„ /FSCMA/CDM_10”

Select under Catalog->Global->Infoset: /FSCMA/CDM_10
and create a Freehand SQL query like:

Select * from “Global”.”INFOSET”.”/FSCMA/CDM_10”

Preview the data and afterwards acquire the data.

After starting the acquiring process a progress bar pops up.

When the data acquisition was successful the data should be displayed as in the screenshot below.

2. Infoset  with a base table as data source „ /SAPQUERY/AM27”

Same steps as in the test before are taken. First select Freehand-SQL, type in the connection details, validate the connection and connect to the ERP system.

Select under Catalog->Global->Infoset: /SAPQUERY/AM27
and create a Freehand SQL query like:

Select * from “Global”.”INFOSET”.”/SAPQUERY/AM27”

Preview the data and afterwards acquire the data.

After starting the acquiring process a progress bar pops up

When the data acquisition was successful the data should be displayed as in the screenshot below.

3. Infoset  with a logical database as data source „/SAPQUERY/DEMO_FLBOOKING”

Also here same steps as in the test before are taken. First select Freehand-SQL, type in the connection details, validate the connection and connect to the ERP system.

Select under Catalog->Global->Infoset: /SAPQUERY/DEMO_FLBOOKING and create a Freehand SQL query like:

Select * from “Global”.”INFOSET”.”/SAPQUERY/DEMO_FLBOOKING”

Preview the data and afterwards acquire the data.

After starting the acquiring process a progress bar pops up

When the data acquisition was successful the data should be displayed as in the screenshot below.

4. Infoset  with joined base tables as data source „ /SAPQUERY/DEMO_FLIGHTS”

Select Freehand-SQL, type in the connection details, validate the connection and connect to the ERP system.

Select under Catalog->Global->Infoset: /SAPQUERY/DEMO_FLIGHTS and create a Freehand SQL query like:

Select * from “Global”.”INFOSET”.”/SAPQUERY/DEMO_FLIGHTS”

Preview the data and afterwards acquire the data.

After starting the acquiring processa progress bar pops up.

 

When the data acquisition was successful the data should be displayed as in the screenshot below.

Restrictions: In Sp11, SAP Lumira support Infosets without Parameters.  Support for this and other formats such as SAP Queries will be available in future releases.

Salesforce Connector:

Select Freehand-SQL,choose the Salesforce.com JDBC connector from database type in the connection details, validate the connection.

ODATA Connector:

SAP Lumira also has Odata support in Sp11. In this example, we will show you how to connect to dataset from Microsoft Azure Market place (http://datamarket.azure.com/).

The data set used in this demo is

2006 – 2008 Crime in the United States (Data.gov)

published by: Government of the United States of America

Extraction of offense, arrest, and clearance data as well as law enforcement staffing information from the FBI’s Uniform Crime Reporting (UCR) Program.

Select Freehand-SQL & choose  the Generic OData 2.0- OData Connector

Once the connection is established, connect to the data set

Enrich and Visualize the data:

To get gradient colors in Lumira, right click on the legends and notice the color palette pop up. This will not work with HTML5 based visualizations. ( Check with Geo, heatmaps/treemaps etc.,)

Also, you now have the ability to control the font size for individual charts within SAP Lumira.

2.    Edit Query Enhancements for Universe.

With Sp11, users have the ability to edit the query and add/remove universe objects for exploration purposes.

Select the measures and dimensions required and acquire the data:

Click on Data Edit Source

Remove country and select few more dimensions

Notice, the new columns after acquisition:

3.     Union of Datasets

With this release, users can now do a union of 2 datasets as part of data merge.

In this example, I have 2 different excel spreadsheets with the same structure for 2 different quarters and instead of merge, I choose the union operation to combine the 2 data sets.

Acquire data from 1 data source, click on Merge and add the 2nd data set.

Click on the union button and perform the union operation.

4.     Batch edit of connections

With SP11, users can view all the connections defined for SAP Lumira and the documents associated with each connection, from the Connections tab available on the Welcome page. They can also change the target data source for locally defined connections, and disassociate selected documents
from connections.

1. Open the SAP Lumira Welcome page.
2. Click the Connections tab in the sidebar of the Welcome page. The Connections pane lists all of the connections available, the Documents pane to the right of the Connections pane, lists the documents which utilize each connection. Each document displays its last modified date. 
3. Double click a local connection in the list to show its target data source. Users can browse to and select another data source if required.

Part 2:  http://scn.sap.com/community/lumira/blog/2013/06/05/sap-lumira-10-sp11-new-features-at-a-glance-part-2