Skip to Content

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

/wp-content/uploads/2013/06/freesql_227092.png

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

/wp-content/uploads/2013/06/erp6screen_227156.png

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

/wp-content/uploads/2013/06/erp62_227157.png

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.

/wp-content/uploads/2013/06/infoset_227158.png

After starting the acquiring process a progress bar pops up.

/wp-content/uploads/2013/06/scansource_227162.png

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

/wp-content/uploads/2013/06/datashot_227163.png

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.

/wp-content/uploads/2013/06/praq_227164.png

After starting the acquiring process a progress bar pops up

/wp-content/uploads/2013/06/prescan_227168.png

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

/wp-content/uploads/2013/06/diplaye_227169.png

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.

/wp-content/uploads/2013/06/prchoir_227170.png

After starting the acquiring process a progress bar pops up

/wp-content/uploads/2013/06/scansource_227162.png

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

/wp-content/uploads/2013/06/showmoi_227175.png

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.

/wp-content/uploads/2013/06/proq_227176.png

After starting the acquiring processa progress bar pops up.

/wp-content/uploads/2013/06/scansource_227162.png 

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

/wp-content/uploads/2013/06/nudderdone_227177.png

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.

/wp-content/uploads/2013/06/sforce_227178.png

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

/wp-content/uploads/2013/06/dg_227179.png
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.

/wp-content/uploads/2013/06/ucr_227184.png

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

OD.png

Once the connection is established, connect to the data set

/wp-content/uploads/2013/06/connectin_227189.png

Enrich and Visualize the data:

/wp-content/uploads/2013/06/vizualizin_227190.png

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.,)

/wp-content/uploads/2013/06/grading_227191.png

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

/wp-content/uploads/2013/06/facting_227195.png

2.    Edit Query Enhancements for Universe.

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

/wp-content/uploads/2013/06/xplorin_227196.png

Select the measures and dimensions required and acquire the data:

/wp-content/uploads/2013/06/quirin_227197.png

Click on Data Edit Source

/wp-content/uploads/2013/06/edition_227198.png

Remove country and select few more dimensions

/wp-content/uploads/2013/06/removeshun_227199.png

Notice, the new columns after acquisition:

/wp-content/uploads/2013/06/columnin_227200.png

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.

unionButt.png

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.

/wp-content/uploads/2013/06/bedit_227205.png

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

To report this post you need to login first.

13 Comments

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

  1. Karen Studley

    Hi, 

    Picking up on the new capability to schedule refreshes of the Lumira documents using the Agent… just to confirm, when the data changes over time and the document is refreshed does the user have to go back into the document and repeat the cleansing actions done using the manipulation tools manually?   Are these able to be automated at all in Lumira rather than the source systems/files?

    Thanks

    K

    (0) 
  2. Julien Delvat

    I can’t make the OData connectivity work, despite checking documentation and demos in youtube.

    The source is:

    http://data.cityofchicago.org/OData.svc/emtn-qqdi

    I was able to use it in Excel with the Power Query extension.

    Here are the steps:

    – in Lumira 1.19.0

    – Create New Dataset.

    – Query with SQL,

    – Generic OData 2.0

    – Service Route URI: http://data.cityofchicago.org/OData.svc/emtn-qqdi

    – Click on Connect,

    – Error Message: OpenConnectivity driver error. Server error 400. Expect a dataset with key predicate (request = /OData.svc/emtn-qqdi/$metadata).

    Any clue what’s wrong here?

    (0) 
    1. Sharon Om

      HI Julien

      Our team spent some time looking into it but we need more info to properly investigate. We would appreciate it if you can raise a ticket for us.

      Thank you.

      (0) 
      1. Tammy Powlas

        Hi Sharon, Julien,

        Just an observation from my side – I can’t connect to the City of Chicago’s OData Service using the Information Design Tool either – similar error

        I wonder if the City of Chicago’s OData service is using V2.0 ?   I can connect fine with Lumira 1.19 & IDT with other OData V2 data sources

        (0) 
        1. Antoine CHABERT

          Hi all,

          Just a side-note: IDT and Lumira are using the same ODATA driver capabilities behind the scenes (connection server). So it is expected that failure or success happens on both sides.

          @Julien, can you please attach the detailed log file from Lumira? it is found here: C:\Users\I051666\AppData\Local\Temp\sapvi\logs. Replace I051666 by your Windows user.

          Thanks

          Antoine

          (0) 
      2. Julien Delvat

        Hi Sharon,

        Thanks for your time. I have create ticket 960999 2014 with title

        Lumira Desktop: Unable to access OData from City of Chicago

        I’ll let you know the answer from the development team.

        Tammy Powlas Thanks for your help.

        (0) 

Leave a Reply