Skip to Content

To start with Lumira, the data set has to be formatted properly.
This can be done using pivot tables.

http://www.dummies.com/how-to/content/how-to-create-a-pivot-table-in-excel-2010.html

Starting with the Data Geek Challenge – Sales in a Company, the following few steps would explain, how it was done.


Choose Start all programs and
select SAP Business Intelligence -> SAP Visual  Intelligence

Now you will get below screen, when you select ‘New Document’

VI.pngVI2.png

In the next screen, you will get source CSV, Free Hand SQL, HANA Offline, HANA Online, MS Excel, Universe 3.X and Universe 4.X.

Select and double click on ‘MS Excel’.

VI3.pngVI5.pngVI6.pngVI7.pngVI8.pngVI9.pngVI10.pngVI11.pngVI4.png

Procedure to connect HANA with SAP visual intelligence and visualize the data:
Hana.png

Enter SAP HANA Server Credentials.

HANA Server: xxxxxxxx

HANA Server Instance: 01

User Name: SULABH_USER

Password: xxxxxxx

Then click on “Connect HANA Instance”

Hana1.png

Once the connection is successful, you will get all the available Analytic/Calculation views in right side as shown belowHana2.png

Select the required view (AN_SFLGHT) and click (preview and select data option).

Hana3.pngHana4.png

In the next screen you will have all the attributes and measures available in the selected view. By default all the objects will be selected, if you don’t want any objects for reporting then you can unselect here.

Press Ok to continue.

Hana5.png

Once ‘OK’ is clicked , you will see the Visual Intelligence Workspace as shown below.

Visualize.png

Go to Visualize -> Drag and drop Measures in the Y Axis and Attributes in X Axis (In this scenario the analysis is for Quantity Sold, Unit Price by Business Units). So Quantity Sold, Unit Price measures are added to Y-Axis and Business Unit attribute are added to X-axis. Now the report looks like below:Visualize1.png

Unit Price here has been added to secondary Y-Axis as If its added in the same chart, the values will be too low and the column of unit price wouldn’t be visible because of the negligible values as per the scale.Visualize2.pngVisualize3.png

Chart type can be changed by Clicking on the icons inside the box, as shown below.Visualize4.pngVisualize5.png

We have save the chart by click on “Save” option in Report pane.Visualize6.pngVisualize7.png

We can “share” the same analysis to others using “Publish dataset to HANA, Publish to Stream Work, Publish dataset to explorer, send visualization to mail”
option in “share” screen.

Visualize8.pngVisualize9.pngVisualize10.png

Link to Lumira Cloud: https://cloud.saplumira.com/landing-page.jsp

Create individual ID’s here.

cloud.PNG

The document can be published in this cloud using the Lumira Cloud credientionals, Similarly the published file can be viewed from this Cloud. As of now 1MB space is provided in here.
To know more about it, check the links below, Play around with ti to discover new things.

Calculations & Trellis chart in Visual Intelligence(Lumira)

3 Simple Steps for Calculating Moving Average in Visual Intelligence 3 Simple Steps for Calculating Moving Average in Visual Intelligence

I hope this would be helpful for the starters.

Happy Learning !

To report this post you need to login first.

34 Comments

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

  1. Suseelan Hari

    Hi Sara,

    Good Day!

    Nice analysis! I appreciate all your efforts and hardwork!

    Definitely it will be helpful for freshers!

    Keep sharing new things. Have a nice day!

    Regards,

    Hari Suseelan

    (0) 

Leave a Reply