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

On my visualization, I am forecasting order quantity:

The green bar shows my forecast of order quantity.

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

The Edit Calculation option appears

Then I can change the forecasted periods:

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

Irshaad Bijan AdatiaTammy,

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?

Tammy PowlasPost authorI have not tried that – you? ðŸ™‚

Tammy PowlasPost authorI just tried that with a ratio – I don’t see a way to edit that calculation.

But it works with the calculation above.

Irshaad Bijan AdatiaI 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.

Tammy PowlasPost authorAgree, but why does the screen/drop down say “Edit Calculation” on the prediction/forecast?

Andrew FoxHi 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.

Manikandan SrinivasanSp13.. coming out very soon ..

Andrew FoxHi Tammy,

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