Monthly Archives: February 2008

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

SSAS Performance Seeker Bag Pack

Introduction One of the things I have to deal with in an Analysis Services project is performance improvement: faster query, using minimum resources, with maximum concurrency. Performance problems can sometimes be tricky to identify. I’ve set up a bunch of … Continue reading

Posted in Performance | 4 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

Foreword

Hello, My name is Michel Caradec, and I’m pleased to join the Microsoft Analysis Services blog community. I have been working for more than 10 years now as a software engineer in the Business Intelligence area. My main fields of … Continue reading

Posted in Uncategorized | 51 Comments