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.
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:
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:
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.
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.
Select Freehand-SQL,choose the Salesforce.com JDBC connector from database type in the connection details, validate the connection.
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.
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:
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
38 | |
19 | |
13 | |
13 | |
11 | |
10 | |
10 | |
10 | |
8 | |
8 |