|
|
 |
|
Viewing report
|
|
|
|
Microsoft SQL Server Analysis Services 2005
The OLAP Report, Feb 2007, Pages: 56
The 2005 release of Microsofts mass market OLAP server, including a preview of Analysis Services 2008 (codenamed Katmai) and PerformancePoint Server 2007
Nigel Pendses review of Microsofts mass market OLAP server now includes previews of Katmai (SQL Server 2008) and PerformancePoint - the financial analytical application scheduled for release in late 2007
Although more than two years later to market than Microsoft had originally announced, SQL Server & Analysis Services 2005 have represented a significant advance on the previous releases in many areas. For example, data access capabilities, including from relational sources, have improved greatly.
This review evaluates the extended scope of Analysis Services including:
- Its close integration with SQL Server 2005
- Improved security features
- Extended time-series intelligence.
It also explores the implications of the replacement of Data Transformation Services by Integration Services, and explains other new features including the move of MDX calculations from the client to the server and the resulting scalability characteristics.
Although Analysis Services offers a greater scalability and new features, the review warns that it is now a much more technical product than its predecessor making the product more suitable for professional developers, rather than end users.
Among high-scoring features, the review describes its database structural flexibility, security and multi-user capabilities. There is also an assessment of its relatively low scoring performance in respect of its portability support and exception alerting. Despite the market leading position of this product, beware of problems with patchy local support provided by Microsoft for multidimensional technology.
Customers who bought this item also bought
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Microsoft SQL Server 2008 Bible
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Data Mining with Microsoft SQL Server 2008
Mastering SQL Server 2008
Microsoft Office PerformancePoint Server 2007
SQL Server 2008: How Does it Measure Up?
Beginning Microsoft SQL Server 2008 Programming
Professional Microsoft SQL Server 2008 Administration
Microsoft SQL Server 2008 Administration with Windows PowerShell
Microsoft Bids PerformancePoint Server 2007 Adieu (Analyst Opinion)
Mastering SQL Server 2005 Reporting Services Infrastructure Design
|
|
|
|
