Creating Roll-up Models That Link – Quick Time-Saving Tips

By Jill King

August 20, 2012

Blog post by Jill King - Anaplan Pre-Sales In my previous position our company had 20 individual department models that were rolled up into a variety of views. As expected, each department owner wanted their results; the 2 managing VP’s wanted the results of their 10 departments, and the Chief Marketing Officer wanted a consolidated view of the total of the 20 departments. CREATING ROLL-UP MODELS THAT LINK TO UNDERLYING INDIVIDUAL MODELS The only way to get this data rolled up was to link to each of the individual files. The VP’s view consisted of linking 10 excel models cell by cell to roll up the P&L. The CMO view linked to each of the VP roll-ups. Anytime a change was made at a department level model, we had to go into the VP and CMO roll-ups to update the links to capture the change.  These files were very large and often had time-out issues that took hours to research. Anaplan Solution No links required! In Anaplan, department structure can be set up to have roll-ups at any level allowing the data to flow real-time. Executives and analysts have a real-time view at every level, including down to department level, if needed, with just a click of the button. Estimated Monthly time savings = 2-4 hours Quick Time-Saving Tips is updated every Monday on the Anaplan Blog. Interested in having Jill @jilleking review a tedious task or want to submit your own Time-Saving Tip? Tweet us at @anaplan and let us know!

Jill King

Jill King, President and CEO at Twelve Consulting Group Jill has 9+ years leading Accounting and Finance initiatives within large enterprises including United Health Group, CarVal Investors and UBS Global Asset Management. Jill is an expert in building automated and efficient financial models across a broad set of use cases.

Jill King's posts >