copy between versions - current year to next year

Is there an easier or faster way to copy data from FY21 Forecast version to FY22 plan version without copying it module by module? Also, I need to keep the current FY21 plan intact. so the result on plan version should be FY21 plan + copy of FY22 Forecast. This is a model level change.

Lag function doesn't work on version formula if you have summary enabled on line items. I have a huge model with over 400 modules. Any ideas?

Accepted answers

All comments

Misbah

@himanshu.badhai

There are two ways thru which we can change/update the data at model level i.e., Bulk Copy and Version Formula

Bulk Copy would have done the Job, if it was only copying the data. But it is basically merging/combining the data of two different versions. Hence won't apply in this case

Another way was to have a formula written in Version formula editor

Edited: As a matter of fact - you can mention Years in Version Formula provided there are certain prerequisites maintained. You may have to hardcode it and later you can remove the formula and your numbers will remain intact

Create a New Version and write the formula in it

Misbah

himanshu.badhai

@Misbah awesome! awesome! awesome!

I haven't tried it on the actual model. But I did a POC and it seems to be working

Involves some hard-coding but will do the job.

Step-1: create a new version "Next Year Plan" and write this formula-

IF ITEM(Time) < TIME.'Jan 22' THEN Plan ELSE IF ITEM(Time) = TIME.'Jan 22' THEN Forecast[SELECT: TIME.'Jan 21'] ELSE IF ITEM(Time) = TIME.'Feb 22' THEN Forecast[SELECT: TIME.'Feb 21'] and so on...

step-2: bulk copy "Next Year Plan" to Plan

Thank you for your help.

himanshu.badhai

Unfortunately this solution will only work if all of your modules use Time and version dimension. It throws error for modules that use version as a dimension but not Time. Modules without version and Time are fine.

Misbah

@himanshu.badhai

That's exactly what I was talking about. If we are referencing Time in Version formula then that is the pre requisite.

I wish I had better response for you.

Misbah

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…