Skip to Content
Author's profile photo Sara G Ayer

Lumira For Beginners

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 !

Assigned Tags

      34 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Anson John Abraham
      Anson John Abraham

      Hi Sara G

      I was looking for a start in Lumira, thanks for sharing.

      Regards,

      Anson

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Anson .

      Author's profile photo Former Member
      Former Member

      Sara G  :Thanks for the Share 🙂 Yes, it ll be helpful for beginners

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Nethaji
      Glad to know that its helpful.

      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      Hi Sara,

      its really helpful.

      Thanks for sharing it.

      Rgrds,

      Jitendra

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Jitendra

      Happy to know it of some use.

      Regards,

      Sara

      Author's profile photo Former Member
      Former Member

      Good One...Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Naresh.

      Regards,

      Sara

      Author's profile photo ANISH KOSHY OOMMEN
      ANISH KOSHY OOMMEN

      Good One..

      Regards,

      Anish Oommen

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Anish

      Best Regards,

      Sara

      Author's profile photo Rahul Muraleedharan
      Rahul Muraleedharan

      A helpful doc for a beginner

      Thanks Sara G Iyer

      Regards,

      Rahul MB

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Rahul

      Glad to know its helpful.

      BR,

      Sara

      Author's profile photo Amala Srinivasa Rao
      Amala Srinivasa Rao

      Appreciable effort dear, have got basic understanding about Lumira 🙂

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Amala

      🙂

      Happy Learning.

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      Very useful Document,Got basic understanding on Lumira,.,.

      Regards,

      J.Sakthikumar

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Sakthikumar

      Glad to know it was useful.

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you very much Suseelan

      Glad to know it d be helpful.

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      Yes it is. Motivate others it motivate yourself!

      Author's profile photo Arun Kumar Kondoju
      Arun Kumar Kondoju

      Nice Tutorial. We use personal desktop edition of Lumira. Now got some info abt other Data sources.

      Thank you

      AK

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Good tutorial.. Helpful for Beginners

      Author's profile photo Henry Banks
      Henry Banks

      please be aware that the UI has changed substancially since SP12, so this blog could get confusing!

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Henry ,

      I ll update images accordingly.

      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      Good one ... Thanks for Sharing... 🙂

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Hi Sara,

      Once again good and informative blog from you.  Thanks for sharing.

      Nicely presented.

      Regards,

      Krishna Chaitanya.

      Author's profile photo Srinu S
      Srinu S

      Helpful document. Thanks for sharing.

      Srinu.

      Author's profile photo Former Member
      Former Member

      Hi Sara G Iyer,

      Its really useful for beginners like me. Thank you.

      Regards,

      Chandrakanth.

      Author's profile photo Former Member
      Former Member

      Hey Sara, your sharing doc/s always good and knowledgeable. Keep it and try to post some docs about Dashboard.

      Cheers

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Informative document 🙂

      Author's profile photo Former Member
      Former Member

      Hi Sara,

      Great effort.., helpful document for me and also to beginners.

      Thanks,

      Sagar

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author
      Author's profile photo Syambabu Allu
      Syambabu Allu

      Hi Sara.

      Nice Blog and It's very helpful for beginners..like me 🙂

      Thanks,

      Syam

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Syam Babu

      Regards,

      Sara

      Author's profile photo Former Member
      Former Member

      Sara,

      Very nice representation.

      Thanks,

      Lasya