Category Archives: Analysis Services 2008

Analysis Services 2008 Personalization Extensions

Introduction SQL Server Analysis Services 2008 introduces a new feature called Personalization Extensions. As said in book online, "Analysis Services personalization extensions enable developers to create new Analysis Services objects and functionality and to provide these objects and functionality dynamically … Continue reading

Posted in Analysis Services 2008 | 3 Comments

SSAS 2008 MOLAP Writeback (2)

Introduction In a recent post, I started investigating around a new Analysis Services 2008 feature: writeback partition with MOLAP storage. Unfortunately, I got stopped by a bug in SQL Server 2008 CTP 5 which disallowed me from committing my updates. … Continue reading

Posted in Analysis Services 2008 | 7 Comments

Connecting to SSAS 2008

Introduction Since version 7 (OLAP Services), a client must use an OLEDB for OLAP (ODBO) provider to connect to an Analysis Services database. Microsoft provides a client setup which embeds this provider plus extra related components, such as local cube … Continue reading

Posted in Analysis Services 2008 | 100 Comments

SSAS 2008 MOLAP writeback-News from Microsoft

In my recent post about SSAS 2008 MOLAP writeback, I couldn’t commit UPDATE CUBE changes on a cube using a writeback partition defined with a MOLAP storage mode. The feedback I posted on MS Connect got a quick response from … Continue reading

Posted in Analysis Services 2008 | 100 Comments

SSAS 2008 MOLAP writeback

Introduction Analysis Services introduced the capability to define a writeback partition with a MOLAP storage (the only choice until now was ROLAP). You can check this whitepapers for a full list of enhancements: http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_bi.mspx This new feature should help getting … Continue reading

Posted in Analysis Services 2008 | 4 Comments