Change Model End of Fiscal Year Setting while preserving all data in order to align week 53

Due to a new controling entity, in our main budget model, we need to change our 'End of Fiscal Year' setting from 'last Sat in Jan' to 'Sat nearest end of Jan.

Our current set-up gave us a week 53 in January 2016, but our new controlling entity requires us to align our financial calendar and budget a week 53 in January 2018.

Updating our model time settings has the undesirable effect of removing all historical and forecast data, perhaps as the time periods are incompatible? Is it possible to update the model time settings without losing all model data?

Accepted answers

ChrisWeiss

Hi David,

Not sure if anybody has had success preventing that kind of change from removing all data (I have not). One option to consider would be to create a new model with your updated time settings, and then import the data from your current model into the new model including any necessary data transformations in either the source or target models.

Happy to provide more details if you'd like, hope that helps!

All comments

ChrisWeiss

DavidKidd

Hi Chris,

Thanks for the reply. I think the option of creating a new model and doing a mass export/import is the path that we are going to head down, it's good to get some assurance that this is a sensible approach.

Regards

David

DavidSmith

Hi David

I’m assuming that the data in Wk 53 FY16 will need to be mapped (to Wk52 FY16 or Wk1 FY17). If so that causes a problem when trying to map model to model, because you can’t manually map time:time.

So I think an export/import is the only solution:

For each data module:

Export the data to .csv
Find and Replace "Week 53 - FY16" to whatever the new week is
Create an import from the file back into the module

Once done for all modules, copy and archive the model (just in case!) and change the timescale

Then for each module run the import from the text file

If you need to apportion Wk53 – FY16 (e.g. split the value into Wk52 FY16 AND Wk1 FY17) that will require some additional logic

Create some additional modules (for each data source) to calculate the split of Week 53. This will need to include the new aggregated values for the weeks either side of Week 53. I would create line items with the labels for the target weeks
Export the data for the split
Create an import
Export the data from the original module as above
Create the import as above

Copy and Archive the model, change the timescale and run the imports from the original modules; Week 53 – FY16 doesn’t exist in the new timescale so the original data won’t come in

Then run in the data from the “split” export files and it will overwrite the original weeks that are part of the apportionment and replace them with the new value incorporating Week 53

I hope this helps.

David

DavidKidd

Hi David,

Thanks for the response.

I am going to map the data in FY16 Wk 53 back into FY16, in order to preserve the FY16 yearly totals.

I am going down the export/import path. I have duplicated the model, changed the Fiscal year settings in the target model (which then deletes pretty much all module data), and am now importing data back into the target model from the previous model using the Anaplan functionality.

This throws out errors where there is a conflict on time e.g. where the FY16 wk53 does not exist in the target model. I am saving the .txt output and I will apportion this to FY16 in the target model at a later stage, which will be the tricky bit. Your suggestion is helpful and I reckon I'll be doing something along those lines.

Cheers,

David

DavidSmith

Hi David

Yes, Wk53 FY16 will be missing so those values will fail and will need to be incorporated into FY16

I'm glad the suggestion was helpful, even if time consuming!

David

Quick Links

Can you help?

Unanswered questions

ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…