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’
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’.
Procedure to connect HANA with SAP visual intelligence and visualize the data:
Enter SAP HANA Server Credentials.
HANA Server: xxxxxxxx
HANA Server Instance: 01
User Name: SULABH_USER
Password: xxxxxxx
Then click on “Connect HANA Instance”
Once the connection is successful, you will get all the available Analytic/Calculation views in right side as shown below
Select the required view (AN_SFLGHT) and click (preview and select data option).
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.
Once ‘OK’ is clicked , you will see the Visual Intelligence Workspace as shown below.
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:
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.
Chart type can be changed by Clicking on the icons inside the box, as shown below.
We have save the chart by click on “Save” option in Report pane.
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.
Link to Lumira Cloud: https://cloud.saplumira.com/landing-page.jsp
Create individual ID’s here.
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 !
Hi Sara G
I was looking for a start in Lumira, thanks for sharing.
Regards,
Anson
Thanks Anson .
Sara G :Thanks for the Share 🙂 Yes, it ll be helpful for beginners
Thanks Nethaji
Glad to know that its helpful.
Hi Sara,
its really helpful.
Thanks for sharing it.
Rgrds,
Jitendra
Thank you Jitendra
Happy to know it of some use.
Regards,
Sara
Good One...Many Thanks.
Best Regards,
Naresh K.
Thank you Naresh.
Regards,
Sara
Good One..
Regards,
Anish Oommen
Thank you Anish
Best Regards,
Sara
A helpful doc for a beginner
Thanks Sara G Iyer
Regards,
Rahul MB
Thanks Rahul
Glad to know its helpful.
BR,
Sara
Appreciable effort dear, have got basic understanding about Lumira 🙂
Thanks Amala
🙂
Happy Learning.
BR,
Sara
Very useful Document,Got basic understanding on Lumira,.,.
Regards,
J.Sakthikumar
Thank you Sakthikumar
Glad to know it was useful.
BR,
Sara
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
Thank you very much Suseelan
Glad to know it d be helpful.
BR,
Sara
Yes it is. Motivate others it motivate yourself!
Nice Tutorial. We use personal desktop edition of Lumira. Now got some info abt other Data sources.
Thank you
AK
Good tutorial.. Helpful for Beginners
please be aware that the UI has changed substancially since SP12, so this blog could get confusing!
Thanks Henry ,
I ll update images accordingly.
Good one ... Thanks for Sharing... 🙂
Hi Sara,
Once again good and informative blog from you. Thanks for sharing.
Nicely presented.
Regards,
Krishna Chaitanya.
Helpful document. Thanks for sharing.
Srinu.
Hi Sara G Iyer,
Its really useful for beginners like me. Thank you.
Regards,
Chandrakanth.
Hey Sara, your sharing doc/s always good and knowledgeable. Keep it and try to post some docs about Dashboard.
Cheers
Informative document 🙂
Hi Sara,
Great effort.., helpful document for me and also to beginners.
Thanks,
Sagar
Thanks everyone,
rajesh bethamcharla
Krishna Chaitanya
Srinu S
chandra kanth
Arshiyan -
Satendra Mishra
Sagar Bhagwan Mahesuni
I hope it was useful.
Regards,
Sara
Hi Sara.
Nice Blog and It's very helpful for beginners..like me 🙂
Thanks,
Syam
Thank you Syam Babu
Regards,
Sara
Sara,
Very nice representation.
Thanks,
Lasya