Skip to Content
Author's profile photo Tammy Powlas

How to Predict the Future in Lumira SP12

I have been exchanging ideas with Sam Ko about how to predict using Lumira.  Then someone asked this morning how this Visual Intelligence 1.0.4 tutorial works in SP12:

At first, because the navigation has changed, I couldn’t easily find it.  Looking at the help, the functionality was still there.

1filter timehierarchy.png

In the above, I already have a time hierarchy and filtered for United States only.  Perhaps I want to use past data to predict expected order quantity in the future.

2fig drag order date.png

In the measures I drag over order quantity,and then drag over the order date / month as the attribute for the axis.


Then select the dropdown by measure and select Predictive calculation > Forecast


I select 12 periods to forecast in the future.


In the above you can see forecast order quantity is the green bars and it is predicting into 2014.

But a bar chart doesn’t easily help you detect trends.


I switch to a line chart and also add linear regression in orange.

For more details on how this works, please see SAP Lumira (formerly SAP Visual Intelligence): … | SCN

So now, maybe I might dive in and predict/forecast some NFL games with Lumira, along with Sam Ko – I could’ve used it today for some of the games.

Related links:

Get Your Data Geek Badges Today! by Anitay Yuen

Ashish Morzaria – #SAPTechEd 2013 Speaker of the Week – Lumira will be covered at TechEd

Meet the ASUG TechEd Speaker Dennis Scoville – Empowered Self-Service BI with SAP HANA and SAP Lumira

Official Product Tutorials – SAP Lumira – now updated for SP12

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      I was just looking for this in SP12, since I used this in SP11.

      SP12 also brings in much familiar formula box.

      It would be great if we have custom hierarchy feature for Attributes, besides Geo and Time hierarchy.



      Author's profile photo Former Member
      Former Member

      We will be adding this feature soon.


      Author's profile photo Former Member
      Former Member

      Thanks for the update Mani

      It was pleasure talking to you at Labs around Lumira on Wednesday at BI Strategy and Innovation Day. SP12 is really up to notch and I am sure with upcoming finer enhancements will make this product even more solid.



      Author's profile photo Former Member
      Former Member

      Also yes It would have been very interesting to see prediction on the Bronco Vs Cowboys game! Its just getting too exciting! 🙂

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Agree with you on this - game is very exciting now

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Nice Analysis and I like the video attached to that.


      Hari Suseelan