Idea: best practice guide formula editing

Dec 09, 2016 at 02:38 PM


avatar image

Hi all,

I keep on struggling with more complex formula's ij the formula editor. An example is the "difference-from-calculation". The dialog box indicates it requires a Time-dimension, which I have in my model, yet I cannot select it in my drop-down. Probably this is due to certain restrictions that I don't know (I;e. lowest grain possible is Month ??)

Wouldn't it be a great idea to have a little best practice guide with samples of the most commonly used dimensions? For Lumira these exist and they are a great help and inspiration for anybody. The guide shouldn't be to complex; just 4 or 5 pages with some common examples:

- how to do a running sum

- how to use the difference from calc

- how to set-up a calculated dimension

- etc etc


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
John Leggio
Dec 20, 2016 at 07:30 PM

Hi Iver,

Good idea. I will check with the team to see if that's something we can create.

Have you read the online help: Calculation Editor


This resource is also good:


And these videos:

Work with formulas and variables: SAP BusinessObjects Cloud (1.0.52)


Create calculated and restricted measures in stories: SAP BusinessObjects Cloud (1.0.54)



10 |10000 characters needed characters left characters exceeded
Skip to Content