- Home
- Finance
Finance TopicsFinanceOperationsFinancial Planning & AnalysisEquity FinancingDebt FinancingM&A and Joint VenturesCorporate GovernanceStock OptionsMarketingTaxMoreFinance News
Switzerland's second-largest bank, Credit Suisse Group AG, recently announced that it plans to cut 109 - Accounting
Accounting TopicsAccountingAccounting ConceptsAccounting StandardsFinancial StatementsAuditRevenue RecognitionAccounting RegulationsAccounting Close ProcessAccounting Policies & ProcessesTechnical AccountingAccounting News
The financial crisis of 2008 considerably altered debate over economic growth and prosperity. Now, it appears that the events of the last ... - Treasury
Treasury TopicsTreasuryElectronic PaymentsWorking Capital ManagementCurrency & Foreign Exchange (FX)Treasury Services ManagementShort Term InvestmentsTreasury News
In response to the increased use of mobile banking - Technology
Technology News
The United States government will soon begin deploying customized Android OS-powered mobile devices to federal agency and military ... - Careers
Careers News
The chief financial officer of Hibbett Sports, a sporting goods retailer, recently announced that he plans to retire on June 1, and the company ... - Directory & Reviews
Ideas for a CFO Replacing an excel-based budgeting/planning process?

Posted Sat, 08/21/2010 - 3:52am by Sonn Nguyen (CFO)
Details
I am CFO of a cellular network operator in Vietnam. I'd like to replace our current excel-based budgeting/planning process with Adaptive planning or the similar. Does anyone here use AP and give me some assessment on this with regards to Reliability, performance, easy-to-use, useful features etc, especially on security issue when we put our very sensitive and confidential company data on the 3rd party server.
If you know about better solution, please advice me.
Thank you in advance & best regards
Sonng
- Application development
- Budget and Forecast
- Excel
- 3256 reads





Comments
Adaptive Planning
Sonng,
I have used Adaptive Planning since 2005 for several companies. As far as up-time I have not had an experience yet where the service was down, they guarantee 99.9% uptime. I am not sure of your budget for an offering but AP is a great fit for small to mid-sized business (SMB). The current version is very user friendly and works great in conjunction with NetSuite as well as other offerings in the SMB segment.
1 out of 1 members found this useful
Adaptive Planning
Sonng,
We have been partnering with Adaptive Planning for a few years now and have completed some of their largest implementations to date. We also have had clients who have outsourced parts of their FP&A process to us where we have actually run Adaptive Planning on their behalf. So we know AP from both an implementer's and end-uer's perspective.
If Adaptive Planning can meet your requirements (and it usually can for most SMB's), it is a great value. Apart from the planned downtime (around twice a year & this occurs late at night over the weekend), I have never experienced Adaptive Planning being down.
I have seen AP perform very well in large user count environments (~150 users) -- in fact, I have witnessed no noticeable difference in performance for clients with few users (<10) vs many users (>100).
It is generally very easy to use for end users. Although there is a little longer learning curve (as you'd expect for any software) for administrators -- especially those who want to leverage AP's functionality to its fullest.
AP has built in security around user-based permission controls.
If you want to learn more feel free to reach out to me directly at bill.aiken@abacistgroup dot com.
Host Analytics
I definitely understand replacing spreadsheet applications – we have seen tremendous value from moving to a CPM application. As CFO of Host Analytics we of course use all the Host Analytics CPM suite modules internally - Budgeting and Planning, Financial Consolidations, Reporting, Dashboards and Scorecards.
If you want to contact me to discuss further please contact me at 650-249-7110 or email at kbattles at hostanalytics dot com.
Best, Kelly
AP vs Hyperion
Thank you all for your advices. Do you know the most convincing advantages of AP vs Hyperion? I know the cost is lower but would like to know more about their features. In addition, how is easy to integrate AP with other BI applications.
AP vs Hyperion
You are correct Sonn about AP being much cheaper than Hyperion. As a general rule of thumb, I tend to think of AP (both software + implementation) being about 1/10th the cost of Hyperion.
Now, Hyperion (e.g., Planning) certainly delivers significantly more functionality. But many, many users do not leverage even a majority of the functionality of Hyperion, so if you don't need it, why pay for it?
I have multiple clients who are using AP with some sort of BI application (including Hyperion Essbase, Cognos BI). The least expensive (not counting internal labor expense in the equation) option is to move the data between the BI system and AP via a CSV file (i.e., manual upload of a spreadsheet with the data mapping between fields defined during implementation). This is actually a pretty quick process even though it is manual.
If you don't like this inexpensive manual option, then Adaptive Planning does offer some API's to integrate the systems. But there is a separate subscription for the API above and beyond the subscription for AP itself.
Hope that helps!
AP vs. Oracle Hyperion
Sonng
I actually did a comparison of the two products not too long ago. The following might be a bit wordy...
Product History - Adaptive Planning is a more modern application built “after the internet”. Oracle has many products in this area, generally aged in nature, including acquisitions of Hyperion and Brio. The Oracle legacy is multiple products and higher costs with greater complexity and risk.
Products - When acquiring Oracle ensure you acquire ALL the products needed to meet your requirements. Customers should be extremely diligent in understanding Oracle product list and each products purpose, relevance, cost and value.
Deployment Options - Implementing hosted solution avoids associated hardware, software and IT (installation, upgrade management, etc.) costs. Note that components of Hyperion can be hosted under a traditional ASP model.
Single solution for budgeting, forecasting and reporting-Adaptive Planning provides a single solution. Hyperion’s most equivalent product (Hyperion Planning) is a combination of modules and datasets. IT expertise needed for administration and understanding underlying calculations/DB structures and associated tuning and maintenance. Integration tools need to be acquired to ensure Hyperion products can “talk to each other”.
Reliability-Adaptive Planning is “always on” and available. Essbase requires downtime (recalculation, database tuning/maintenance, updating system structures, etc.).
Ease of Use-Significant training and education is required to implement and manage Hyperion. Essbase requires unique skills.
Cost of Licensing- Adaptive Planning’s SaaS pricing allows their customers to start with an inexpensive deployment, develop and expand their application and invest alongside value creation. Typically, AP's subscription is less than the ongoing maintenance for Hyperion Planning.
Frequency/Cost of Upgrades-Upgrades to Adaptive Planning are included with the subscription fees. Oracle typically will include upgrades within annual maintenance but have periodically charged exceptional/migration fees with major upgrades so customers should be aware that there may be unexpected potential future costs. Customizations may not upgrade successfully (e.g. needed custom script).
Cost of Services and Risk-Adaptive Planning implementations are typically fast (average implementation time is less than 20 consulting days). Hyperion Planning implementations are typically of greater length/slow and customers often never complete their implementation. References should be used to compare cost and risk.
Implementation and Support-Adaptive Planning’s size and SaaS/renewal focus ensures AP provides superior service. Support is provided by teams with the same training and expertise as implementation consultants (escalation allows for immediate involvement of your implementation team if appropriate). Adaptive Planning provides unlimited and free access to training videos, materials and documentations including training on all new features.
Flexibility-Adaptive Planning allows centralized and unique cell-based calculations for sophisticated modeling. Hyperion Planning is more formally centralized so regional/local requirements may not be able to be modeled easily/may require custom code.
On The Fly-Hyperion Planning is unable to absorb typical “on the fly” processes (e.g. adding new accounts, departments, versions, business rules) without significant administration effort and offline time.
Calculations-More complex cross functional business rules and relationships may require custom coding to deliver in Hyperion Planning.
End User-AP's purpose, simple and consistent built web interface allow zero footprint deployment. Excel may appear to be easier but has issues (synchronization of offline, control of template, replication, speed of performance, etc.). Hyperion Planning has many interfaces (further complexity added if deployed alongside other Oracle products).
Ongoing Costs/ROI-As written in the Wall Street Journal, 2002, Microsoft stated that “the initial purchase is usually only 5% of the total cost of owning and maintaining a program”. Oracle implementations are extremely expensive initially, but when the total cost of ownership is examined all customers should consider the expected benefits/savings versus total cost of investment.
Hope that helps.
1 out of 1 members found this useful
Host Analytics is a good option
Sonng, we implemented Host Analytics about 4 years ago and have been very pleased. We too were looking for a solution that would take us out of the Excel maze and into a modern and manageable world. But we also had to manage the training gap to a newer tool. We looked at Hyperion but just couldn't make the numbers work.
Host wound up being incredibly robust in features for an amazing price point comparatively. The tool also bridges the gap of folks moving off of excel with options like direct uploads from excel to the db. In addition, they were able to meet all of our needs on security. We are a private company so we had a tough road to convince our executive team that our data would be safe in Saas environment. The HA folks helped us address that concern and its been great. Reliable, and fast.
Implementation time was quick as well- which matters when you are constantly budgeting. In any case, I would recommend a look at Host Analytics, it worked out well for us.
Practical Assistance
Hello Sonng,
We can provide some practical assistance with your assessment if you would like. I am CEO of ABM Systems, an accredited Adaptive Planning Implementation partner. I have staff with Vietnamese language skills who can assist in guiding you through demo models and the various features, whilst addressing any questions you have. We can also provide some coaching to assist with any proof of concept modelling you wish to undertake. You can contact me via greg at abmsystems dot com if you would like.
Caveat
Although I found AP very advanced, be forewarned that it is not a web based excel. All of their formulas are different than excel and it takes some training to get used to it. I found the AP team very helpful in getting up to speed, but must say I was initially disappointed that the formulas were more difficult to manipulate than I anticipated.
Hyperion vs AP
Dear all,
Thank you for your really helful & valuable advice. I think AP or Host is good solution for my company.
Do you know if they can adapt to the company growth or change i.e in size, complexity, or the way we do budgeting/planning & reporting i.e. by departments, customers, products or approval path?
Thanks & regards,
Both Host Analytics and Adaptive Planning are flexible
One of the "old stories" that traditional planning providers tell you is that SaaS apps are "one size fits all" and thus inflexible. Nothing could be further from the truth. SaaS apps are built on a much more modern architecture than traditional platforms and are built specifically for user-controlled-customization. I would say you will have more adaptability than you may need with either solution. Easiest thing, of course, is to just call them both up and let them shoot it out! Good luck.
why change?
What is your motivation for changing?
1 out of 1 members found this useful
Essbase
I have not used Adaptive Planning, but we put in Essbase (the underpinnings or guts of Hyperion) to manage planning and serve as a consolidation tool. If you haven’t looked at Essbase, please do so. It is a cheaper solution than Hyperion and is more flexible to do planning and analysis. With a multi plant set up, but no foreign currency issues, we put this in for much less than $100K.
Leveraging Essbase vs AP
I agree with Patrick. However, it is important to have an IT group that understands the features and functionality of Essbase and how that matches with the needs of Finance/Accounting. If CFO's see their data expanding in scale and want to build custom reporting and planning tools, Essbase is the way to go. But the key here is having the in-house IT (or consultants close by) to optimize the cubes and develop integration schemes that allow for interoperability.
The end question the CFO has to ask is can he/she meet his/her requirements with a pre-packaged solution. If the CFO anticipates growth in data, analytics and planning needs that exceed that of AP, then go straight to Essbase. AP or Essbase really depends on the company’s requirements coupled with a vision for the future.
I have some presentations that help compare Essbase planning process to classic spreadsheet approaches.
http://www.curtisneumann.com/wp-content/uploads/2011/09/CFOMagazine_HighPerformanceDriverBasedModelingatATT_081511.pdf