PPS 2007 vs FRx Forecaster

Posted on января 7, 2009
Filed Under Microsoft, PerformancePoint Server

Не совсем актуально для России (ибо у нас MS Forecaster не продается), но очень хороший пост — PerformancePoint Planning vs. FRx Forecaster. Приведу табличку оттуда:


FRx Forecaster


Out-of-the-Box Solution Yes No
Model Types Supported Four (4) total types that have been preconfigured to handle Expenses, Revenue, CapEx & HR (one of each) Unlimited types can be created and they can be whatever you can dream, but no models are provided out-of-the-box
Number of Models Supported Four (4) models per company (as detailed above) with unlimited companies supported Unlimited, but no models are provided out-of-the-box
Supports Linked Models Yes, but only within the four model type structure above Yes
Supports Allocation Models Yes Yes
Supports Multiple Currencies Yes Yes
Number of Dimensions Ten (10) maximum across all models and companies with nine (9) being user definable and one (1) needed to handle time Unlimited
End User Interface Web interface or FRx Forecaster client Excel 2003 or Excel 2007
Use Excel Formulas / Functions During Data Entry No Yes
Supports Spreading / Calendarization of Values Yes and it does it quite well No, but back-end PEL rules or Excel functionality can be implemented to assist the user
Approval Workflows Yes Yes
Workflow Statuses Unlimited and configurable Fixed
Workflow Alerts via Email Yes Yes
Audit History by Cell Yes and available from within the user interface Available, but requires creation of custom reports that are run separately
Copying of Budget Versions Yes and is a built-in function Yes, but requires development of custom PEL rules
Data Storage Structure SQL Server table with all data for all models in a single table SQL Analysis Services and SQL Server tables with each model having a unique cube and series of tables
Reporting Tool(s) Reporting is limited as the tool is geared towards budget capture and approval. FRx Financial Report Writer can be utilized PerformancePoint Excel Add-In, Excel pivot tables, Management Reporter, SQL Reporting Services, PerformancePoint M&A components
Integration to/from Other Data Sources Limited and primarily GL level data only Unlimited and can include both dimension members and fact data
M&A Components Available None as FRx Forecaster is a budgeting / forecasting solution only Yes and therefore provides a complete performance management suite
Short Term Solution (<3 Years) Yes Yes
Long Term Solution (3+ Years) No as it is being phased out in favor of PerformancePoint Yes
Deployment Ease/Speed (Scale 1 — 10) 8 out of 10 as working within a set framework means quicker deployment 5 out of 10 as you can create whatever you like, but you are starting with a blank canvas
Deployment Power/Potential (Scale 1 — 10) 5 out of 10 as you are forced to work within the existing framework that has been pre-developed for you 7 out of 10 since the product is still at v1.0 and lacks some features, this should be a 9 after v2.0 is available


Leave a Reply


Spam Protection by WP-SpamFree