Looking for an FRx, MR, or Forecaster alternative or replacement?

For the record, I am a huge supporter of Microsoft's CPM solutions, which currently include FRx, MR and Forecaster.  While these solutions generally serve most CPM needs, there are certain CPM requirements that cannot be addressed well by these solutions.

Prophix CPM is a scalable enterprise level CPM solution that can handle 7 of these more challenging requirements:

1. Combine financial & operational models to link key business drivers to budgets & forecasts
2. Facilitate complex planning and forecasting scenarios
3. Improve reporting speed
4. Facilitate a robust workflow to help manage the budgeting cycle
5. Automate the dissemination of reports and budgeting templates
6. Fully automate and schedule administrative functions (i.e. loading of data, etc)
7. Reduce administration to facilitate more frequent forecasting and timely intervention

If you're looking for a replacement for any or all of these solutions, Prophix CPM should make the short-list. Contact me or view the autodemo for more information.

Dilbert and Why to Not Budget using Excel

For many smaller organizations with simple budgeting/forecasting needs, Excel works just fine.  However, as Dilbert points out below, there are certainly drawbacks to using Excel:





For organizations with more complicating needs, the value of a using a dedicated CPM solution for budgeting/forecasting and financial/management reporting are myriad, including:
- Simplify and better control the budgeting process
- Reduced administration of the budgeting cycle
- Increased collaboration
- Real time version control
- Mitigate speadsheet ‘mis-calculations’ and ‘overrides’
- Better manage security
- Historical tracking/audit of changes
- Integrated financial/management reporting solution to facilitate variance reporting
- Simply reforecasting administration

Forecaster 'Missing Link' Found!

With Microsoft's recent release of the Forecaster Data Transfer Tool, a 'missing link' in the Microsoft CPM solution has been delivered.  

This is excellent news and means that we no longer have to rely on a manual Excel based method to feed Forecaster data into Dynamics GP.  Instead, this process can now be automated. 

It also allows Management Reporter to report on Forecaster data via Dynamics GP versus directly as can be done in FRx.

Best of all, this tool is free! 

For more information, visit the Microsoft Dynamics CPM blog or CustomerSource.

Note: The tool is compliant with GP2010.

Migrating to Management Reporter (MR) from FRx when Upgrading to GP2010

Most of FRx’s core functionality is already built into Management Reporter (MR), including multi-company consolidation, multi-currency and AA integration. As such, many organizations using FRx could migrate to MR today along with GP2010 upgrade. 

Note:  Organizations do not have to migrate to MR with a GP2010 upgrade; however, an upgrade to GP2010 is required to use MR.

Having said that, a review of FRx functionality currently being used to ensure there are no surprise functionality gaps that may pose an issue upon migration is a good idea!

While this information is constantly changing, a current snap-shot of functionality gaps is outlined below:



'Not Yet' in MR:

Feature Pack 1 (FP/SP1), which is scheduled for fall 2010, is expected to have the following functionality:


• Translations (based off GP translations enhancement which is not yet in GP2010)


• Forecaster integration that will be more advanced that FRx’s

Feature Pack 2 (FP/SP2) which has a 'distribution' theme, scheduled for spring/summer 2011, is expected to have the following functionality:


• Sharepoint integration


• Email


• Drill down to GP (inquiry screen and possibly SRS reports)

'Not Currently Planned' for MR:

I believe the only ‘real’ deal breaker here is ‘row linking’ which is used in a small percentage of advanced FRx design environments.  However, a few other items, such as 'report manager' and 'effective dates' are also currently not planned to be incorporated into MR.  That may be somewhat misleading though, as MR may incorporate different more advanced functionality that would handle the same type of situations and much more.

 'Different' or 'Improved' in MR:



Many features in MR are improved or different.  A few of these items are listed below:


• Translations (SP1)


• Forecaster integration (SP1)


• No Webport – Report Library (Current) or Sharepoint (SP2)


This is not a complete list.  I hope to blog about these features in the future, so stay tuned!

Introducing Management Reporter

Management Reporter (MR) is Microsoft's Corporate Performance Management (CPM) platform for its Dynamics ERP solutions. It has been available for Dynamics GP2010 for about a month (See Microsoft's official Press Release).

CPM is a Business Intelligence (BI) capability area covering:

• financial reporting,
• consolidations,
• planning,
• budgeting and
• forecasting

In short, MR is FRx on steroids! In fact, MR is much more than that. It is more than a new graphical user interface, the entire product has been rebuilt from the back end (how it accesses data) to the front end (the user interface). It is the foundation upon which the future of Microsoft's CPM solutions will be built and that is very exciting!
MR effectively replaces FRx for users on Dynamics GP2010 and above. However, some advanced FRx reporting design capabilities are slated to be delivered in the fall of 2010, so not every FRx installation can migrate to MR today. Remember, patience is a virtue!
If you're worried about migrating from FRx to MR, don't be, because Microsoft has built a migration path/tool. Of course, each situation is unique and some manual updating of reports may be requried in some circumstances.
In case you are wondering, MR is currently slated to encompass the planning, budgeting and forecasting capabilties of Microsoft Forecaster by 2011, thus effectively replacing that product as well. As with FRx, a migration path will be available. So, your current investment is safe!
A final word of praise for FRx... FRx has been the industry leading financial reporting package for nearly 20 years. I think we all agree that it is a great product, but it is based on old technology and I think we can also agree that it needs more than just a facelift to carry it into the future. That, together with Microsoft's vision to build the industry leading CPM solution on a common platform, is essentially the raison d'être for Management Reporter.
Warning: Management Reporter may cause financial report designers to renew their excitement for creating financial reports.