In the data flow steps here,
In the
"MAIN"
group, create a
"Calculation: Data flow"
step, select
"CONFIGURE LAYOUT"
and add the
"SET - DE - Future Years"
Cube as data block
"a"
and the
"SET - DF - Actual Years"
Cube as data block
"b"
.
Set the
"Target"
as
"b: SET - DF - Actual Years"
and set
"Expression"
to
"1-a"
.
I guess my question is, why is the expression set to "1 - a" where a is future years and we're trying to establish actual years. Why isn't the express "a - 1"? if the planning year is 2023, then say the actual year is 2022, then wouldnt a - 1 make more sense?