BSO - Calculation script - How to set variables/command/functions which go one year back?
Hello everybody,
I want to built up a calculation script in a BSO-Cube.
The script should copy values from one measure to another when the condition is true.
Description:
When the condition in january 2014 is true, the script should write the value in January 2015
Explanation:
CY = CurrentYear
LY = LastYear
I want to calculate all the values of the past, so I need a variable/command/function with it I go one year back.
I want to replace "2014" and "2015" with variables/commands/functions to calculate it with every year.
"ValueLY"
(IF(@ISMBR ("January"))
IF("2014"->"Check-Account"->"AC"==1 ) "2015"->"ValueLY"="2014"->"Start_Value";