I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013.  If...  Read more...

Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics. Using the GUI:...  Read more...

If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...  Read more...

A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...  Read more...

I used to think naively that IIF is an innocent little function that can only do good and help me...  Read more...

Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is...  Read more...

As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...  Read more...

Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also...  Read more...

Many companies have a very rigid development lifecycle for all products or solutions they develop.  Deploying to each of these...  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...

Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I...  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...

I attended a presentation recently from Steven Wright of SQL Sentry on Analysis Services (SSAS) memory management and it was...  Read more...

When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...  Read more...