Part 4 of this series, Shahfaisal Muhammed brings another method of deploying your SSAS projects to a new server: the synchronize database method. The rest of the series covers other methods.  Read more...

When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?  Read more...

This technical note describes the consolidation options, considerations, and best practices for Microsoft® SQL Server® 2008 Analysis Services that the SQL CAT team has derived from working with Analysis Services customers. In this technical note, we also discuss an Analysis Services load balancer solution that one of our internal customers uses to load balance queries from Microsoft Excel® and SQL Server Reporting Services clients across multiple query servers to increase query performance and provide availability.  Read more...

Part 3 of this series, Shahfaisal Muhammed brings a common method of deploying your SSAS projects to a new server: backup and restore. The rest of the series covers other methods.  Read more...

Many companies have a very rigid development lifecycle for all products or solutions they develop.  Deploying to each of these...  Read more...

After a great presentation from Brian Knight at the NYC User Group, Robert Pearl summarizes some information about SSAS and when it makes sense to use this subsystem. And why you might want to attend that next user group meeting.  Read more...

Continuing with this series, Shahfaisal Muhammed brings us another method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.  Read more...

In part 1 of this series, Shahfaisal Muhammed brings us one method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.  Read more...

A sample chapter from a new book on Analysis Services. Check it out and see if this is the book for you.  Read more...

Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.  Read more...

In this post, we will look the steps to backup a SQL Server Analysis Server Database. After logging to the Analysis Services, in...  Read more...

Join BI Architect Bill Pearson in this introduction to Security in Analysis Services 2008. Here we explore security concepts and implementation, and look forward to hands-on practice with security in other articles of this subseries.  Read more...

Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I...  Read more...

BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.  Read more...

This is part four in the series of blog posts that will help in building a library of calculations you...  Read more...

This is part three in a series of blog posts that will help you build an arsenal of MDX calculations...  Read more...

This post is a part of a series of blog posts I am writing to give you a Batman-like Utility...  Read more...

Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube.  That...  Read more...

Step by step to create a Decision Tree and how to understand the results showed by Analysis Services  Read more...

I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?  Read more...