Imperial UK Implementation – Days 3-5


Tagetik CPM software solution for budgeting and planning



Ironed out the last of the instances where mapping did not correspond with the legacy system. In many respect tagetik was doing what it had been asked to do, but this was an example of how to get tagetik to interpret those times when we don’t abide by our own rules.
We constructed the statistical codes which did not exist in Tagetik and created an upload routine to enable us to populate the statistics. This was more of an example of how to populate them and we left the day with the intention of creating something that would enable us to bulk upload.
We created an upload format that would enable us to upload actuals and plan data into these scenarios on a bulk basis. In other words we would be able to load the 750k lines representing the history going back to January 2012 in one go. A second pass with the same system would enable the same to be done for the plan data.  What is critical in all cases is that the data is held in a format that is understandable by Tagetik. In other words if you are holding your plan data in a normalised database table then the journey is relatively straightforward.
For many businesses their data will not be held in this format and the challenge may well be a difficult on which will involve converting data which is essentially held in months running from left to right with no coding, to one where all plan items have line items coded as per the general ledger using the accounting convention and the periods effectively run from top to bottom, on top of each other. Additionally, the system would need to be capable of similar operations in respect of statistical data. Finally, the tagetik model only works off cumulative data.This is quite normal and avoids the need to hold multiple instances of the same data, but it is far from straightforward to convert a monthly plan and balance sheet to a cumulative one.  With the latter in mind any business undertaking this will need to ensure they have either the data or data skills to move from their legacy systems to Tagetik.
Whilst this might seem daunting it is also the reason why excel legacy systems are so unwieldy. They hold both data and reporting in the same place, with all the risks around data integrity to go with this.



Read next post:

Share this post!