Well designed Anaplan for FP&A models are simple, logical and fast. To get the best return we must spend 'sparsity dollars' wisely....Here's why!
We use what we call modelling cohorts to effectively organise and structure our clients data. We advocate using a concept we refer to as sequential consolidation to move and prepare our clients data through their models from record to report. These ideas help us spend our sparsity dollars with wisdom.
An archive is core to how scenario planning functionality should be developed in your Anaplan models...
An archive is a location within the model which is disconnected from all live processes and retains data which can be retrieved via a mapping. The retrieval can be part of a scenario planning functionality or simply used to hold historical forecasts and budget for future reference.
Workspace capacity constraints are major issue for most Anaplan model designs. So, what can we do to minimise or mitigate the issue?
Here are a few design ideas we have implemented while working to redesign, redevelop and rebuild several large enterprise wide FP&A models for some of our global clients.