Skip to Content
Author's profile photo Tammy Powlas

How to Edit a Calculation in Lumira

On Twitter, Andrew Fox asked how to edit a calculation in SAP BusinessObjects Lumira SP12

On my visualization, I am forecasting order quantity:

/wp-content/uploads/2013/10/1forecast_298491.png

The green bar shows my forecast of order quantity.

To edit the calculation, I click the down arrow next to the Forecast: Order Quantity:

/wp-content/uploads/2013/10/2editcalc_298492.png

The Edit Calculation option appears

Then I can change the forecasted periods:

/wp-content/uploads/2013/10/3change_298508.png

Be sure to add SAP TechEd Session Using Lumira with BW and SAP HANA to your TechEd agenda – one session is already full.

Assigned Tags

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

      Tammy,

      This is a great post! Thank you

      Another way that we interpreted asking how to change a calculation is:

      when you create a calculated measure -- are we able to edit the calculated measure's calculation after we've created it?

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

      I have not tried that - you? 🙂

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

      I just tried that with a ratio - I don't see a way to edit that calculation.

      But it works with the calculation above.

      Author's profile photo Former Member
      Former Member

      I think the best use of terminology in these cases would be

      Using 'prediction' to describe the measure you're using in the above tutorial, and

      Using 'calculation' for the measures that are created within Lumira's interface.

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

      Agree, but why does the screen/drop down say "Edit Calculation" on the prediction/forecast? 

      Author's profile photo Former Member
      Former Member

      Hi Bijan,

      Your interpretation is very close to my issue. 

      If you manually create a New Calculated Measure, sum(a*b) for example, in the prepare window a new measure becomes available in the measures list on the left side of the screen. Annoyingly an additional column is not created in the prepare window so you can't validate the formula is giving you incorrect results. If you use the new measure in a visualisation and feel the formula you have typed in is incorrect you need to go back and edit it to say sum(b*a) for example, but there appears no way of doing this.

      Author's profile photo Former Member
      Former Member

      Sp13.. coming out very soon ..

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Thanks for taking the time to share your findings after our chat via twitter, great content as always.