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

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!

Related Posts

Anaplan awarded best-in-class ‘Integrated Business... Anaplan, the Smart Business Platform™, received the CIO HONOUR® award for best-in-class “Integrated Business Planning Platform” as voted on by Singapore’s CIO c...
Anaplan App Hub: Your premier destination for plan... What if we told you that a place exists where high productivity and fast planning are fueled by data and unlimited apps that span all departments and industries...
Anaplan’s 2nd release of 2015: The best of both wo... Personal productivity tools, like Office® Excel, have their limitations. Take, for example, revenue forecasting for a typical products and services company. For...

Share this Story

Leave a Reply