Why were SQL Server 2005 and TM1 chosen?

Why Microsoft's SQL Server 2005?

This latest version of SQL Server is a significant advance over previous versions and provides a powerful, highly scalable database plus a complete stack of additional software. This all now matches other leading vendors, but at a much lower cost.

SQL Server 2005 is highly scalable, easily capable of managing terabytes of data.  Click here for much more information and many examples.

SQL Server 2005 also includes SQL Service Integration Services (SSIS), a set of powerful tools for ETL (Extract, Transform & Load) processing. This is the very latest in ETL software, with a graphical interface allowing complex processes to be written quickly to extract data from many different systems. 

For more information, see SQL Server 2005 and SQL Server Integration Services.

 

Why Cognos' TM1?

  • Customers are very enthusiastic about TM1, particularly its speed and easy of use. Very fast response times - with one of the fastest data load/pre-calculation times available today (from an independent survey, OLAP Survey 6)
  • Fast to implement: TM1's median implementation time is 2.5 months (from the same independent survey), compared to 4-5 months for most other leading vendors
  • Proven tools for financial management: what-if analysis, planning, budgeting and forecasting
  • Supports enterprise Business Intelligence solutions, designed to complement data warehouses and supports industry standards for integration
  • Provides write-back capability to data (very rare in OLAP software) which is essential for planning, budgeting and forecasting applications
  • A single platform for all the bank's management information needs with powerful tools for analysis, presentation and reporting, including scorecards and dashboards

Click here for more information about why Granville Associates chose TM1. This includes information from the OLAP Survey 6 and feedback from TM1 customers.

For more information about TM1, see Cognos' web site.