Microsoft Dynamics SL vs. Oracle Hyperion (legacy)

For a small to mid-size business, MS Dynamics SL is effective. We are capable of managing our finances with a very low risk of error. We have worked with MS Dynamics for almost 15 years and have more than doubled the size of our business in that time with very few issues from the program. We have exponentially increased our revenue and reporting demands and have found SL to be very dependable and stable. The program does have the occasional glitch and those are sometimes outside of the realm of expertise of our IT department. SL support is excellent, but their timeliness is not as urgent as ours.

Incentivized

Well suited: For use in multiple offices around the world. I was able to obtain financial reporting data from 5 foreign offices and then consolidate their data with 3 domestic USA offices to prepare a consolidated financial statement. Less Appropriate: Translating the financial value for consulting services could be a bit challenging because that required human interaction and judgement. It would have been great to be able to set up some software to be able to interpret this and let it run for all future project work revenue projection.

Incentivized

• Provides flexibility for complex project based cost accounting
• Strong and flexible allocation processer for cost allocations, markups, and pricing
• A "Flexible Billing" module under the project controller series that allows for multiple billing formats ranging from fixed price schedule of values, T&M or Cost Plus, and scheduled billing.
• Flexible reporting with options using Crystal Reports, SSRS, a Quick Query tool, and ability to tie into MS Office tools such as MS Access and MS Excel
• Tight integration with Financials, but also the ability to integrate with modules such as Sales Order, Inventory, and Field Service
• Customization abilities ranging from a VBA (visual basic for application) foundation to allow customizing existing forms to the ability to use the SDK (Software Development Kit) to build more complex customizations that integrate with Dynamics SL.

Incentivized

• This product handles budgeting by Employee and/or Position very well. It is highly flexible and allows Hyperion administrators the ability to develop a planning application that fits a variety of different business needs.
• It is great at calculating benefits using business rules to automate the population of these fringe costs in the overall budget planning process. This greatly reduces user error.
• It allows you to seed the operating budget based on changes to key drivers, such as percentage increases, flat dollar increases and more detailed changes using business rules.
• Allows visibility into the plans for each unit across the organization, rolled up into an overall budget for the campus.
• It handles the creation of budgets with multiple chartfield segments or dimensions, which most other budgeting systems cannot handle well. It can aggregate these very quickly.

Incentivized

• Reporting in the Project module is lacking functionality. I understand that most companies have specific needs when it comes to tracking project information but the standard reports are not good.
• I would recommend a product like Management Reporter that is for Projects only. Project Reporter should allow users to pull in all Project related data into reports.
• Fixing suspended batches. Obviously all of us users have experienced this mess. SL knows what needs to be corrected and there could be some step by step fixes in a separate repair module to do the steps we do in Query Analyzer.

Incentivized

• One pain point for us is the consolidation and translation process. Needing to translate the data over and over again is frustrating and there is no visibility into how many users are running a translation. If multiple users attempt to translate the same data set, say goodbye to your performance but you have no way of knowing! (Unless you want to pull up a task audit which is not a very realistic expectation). It has the been the quickest way for us to bring the system to it's knees. The consolidation process performs in direct correlation to the complexity of the calculation/consolidation rules. So, while the product is extremely flexible, you still have to be careful how you design your rules and calculations to make sure that you do it on the smallest subset of data as possible to avoid large processing times. This makes sense, but requires some significant expertise that most organizations do not have in-house.
• The Hyperion Financial Reporting product is ridiculously outdated and clunky to use. The interface for designing reports is not intuitive, and not easy to modify once a report is built. I think there must be a strategic decision to move away from it and go to something more like Oracle BI because I just can't understand why in the world they don't update the reporting product. It also requires a significant level of expertise to be able to use. Not a great solution at all if you want multiple end-users to create reports in something other than Excel. Nobody except the HFM admin (which I used to be) in our company even touches this module.
• Another pain point is the amount of IT support that is required to run this thing, and again, specialized knowledge of Hyperion products and how they work is required for IT to adequately support it. This goes for application servers and the Oracle database that the applications are running on.

Unfortunately, Dynamics' lack of ability to smoothly integrate with our CRM system is causing us to look at other solutions. The efficiencies that we gain by using Dynamics for our day to day accounting are lost in the constant headaches of getting sales quotes to import properly into the system for invoicing. Another major issue for us has been budgeting and reporting. We currently do all of our budgeting and board reporting in Excel, which is too time consuming and inefficient, especially when a system as robust as Dynamics should easily be able to handle this relatively simple task.

Incentivized

We're in the middle of the road because we are not sure that other products on the market fit the bill for what we need yet. Hyperion is expensive and burdensome from an administrator and maintenance standpoint, but it still seems to be the best solution for what we need. Show us an equally capable SaaS consolidation product and we'll talk again.

I rate it a 10 because we have removed the fields we don't need so users can really crank the data into the system. The software was designed for the professional services firm in mind but does a tremendous job for construction firms and "blended" companies that are both distribution firms but project centric as well. Perhaps they drop ship inventory to a project where their employees or subs need to work on a project for example.

Incentivized

We have had only one unplanned outage for 2 hours in the last 30 months. We shut down for 30 min to 1 hour once a month, but that is for Microsoft OS updates to the servers. Being a 24/7 world wide operation, the reliability is really important. We do get an 8 hour window on the weekend that we can be down for a short period to install Microsoft Dynamics SL updates, but we do not have many of those. On our last version upgrade, we shut the users out at 9:30 am and were fully operational in less than 6 hours. The upgrade was New SQL server, New SL server and 2 new Citrix servers.

Incentivized

Support is only used when needed, so unfortunately ,they get all the odd issues. It's a difficult business, but Microsoft and our firm do a great job of meeting customer needs. We get routine feedback that our support services are very good.

Incentivized

The premium support team provides much needed dedicated customer service which we are after for what we have paid for this service. We are satisfied with the service and support and do not have any instance where there was an issue that requires escalation to get the right support team. Though the incidence of major issues that requires the premium support are less, we prefer to keep this as a safety net.

Incentivized

Just to let it take its course. The implementation for me once I became a part of my former organization was pretty seamless. Just get to know the basics and call the support team to ask questions if you need help on an issue, should they arise. They are ready, willing, and able to help!

Incentivized

Of the comparable mid-range ERP systems, Dynamics SL competes at the lower end based on price, but also above the high-end based on flexibility, data, and reporting. Being able to stay with the same core accounting from a $100 million dollar company to a $3 billion dollar company shows the range of capabilities.

Incentivized

I use Oracle Hyperion Enterprise Performance Mangement because the company I work at requires me to use it in the Financial Planning sector as most of their data is stored in it. I am open minded and ready to use other performance management tools created by Oracle if my work permits.

Incentivized

Since the backbone of the database is MS SQLServer, the database can be easily scaled.

Incentivized

• More time is spent on manipulating reports which can and should be automated.
• Lack of electronic invoicing process and other green technology features creates more cost on printing and storage costs.
• The lack of a user friendly interface requires more training and a bigger learning curve for staff.

Incentivized

• Oracle Hyperion allows us to automate and consolidate financial data that used to be performed manually in spreadsheets. From that perspective the ROI is huge.
• Oracle Hyperion functionality is extensive and allows us to perform most functions for planning, consolidating and reporting on our financial data.
• One negative with Oracle Hyperion is that it is complicated to implement and maintain. It takes expertise at all levels (infrastructure and management) to realize the benefits from it.

Incentivized