Spread values evenly across Period dimension using @xwrite
Is it possible to spread values evenly across the Period Dimension (Jan:Dec) using grid spread like what is available in forms?
For example, I have Labor data sitting at Period BegBalance and I want to copy this into the Finance Cube's Period Full Year and have the system spread back 1/12 of the total copied amount to each child (Jan, Feb, Mar, etc.)
We currently do not budget to Full Year in the Labor cube, but may have to pivot to Full Year if this is not possible.
Thanks in advance!
Version (include the version you are using, if applicable):