Order of months in calculation?
Hi experts,
In an EPM environment I have a Period dimension (Dense) and periods are Jan, Feb and Mar.
If I do a fix (@Relative(“Period”,0))
Sales = “Goods Sold” * “Price”;
ENDFIX
What will be the order of months in which Essbase will do calculation i.e. which month (Jan, Feb or Mar) will get calculated first?
Also, can we restrict Essbase engine to calculate Feb first and then Jan or so, except for making it in a different fix?
Any quick input is highly appreciated.
Thanks & best regards,
Jitendra