Archive | Analysis Services

Get The MAX Date From A Cube Using MDX

Here's the goal: populate a sql variable with the max date from one of the dimensions in a cube. It takes a little bit of unusual code but it's relatively simple so pay attention! It's probably important to note this code is assuming you are using a smart key for your date dimension (e.g. the […]

We Don’t Need No Duplication: Eliminating the Visual Studio “Do Not Ignore Duplicate Key errors” warning.

So when I open up a SQL Server Analysis Services Project in Visual Studio and it gives me the warning "Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration so that it is not set to IgnoreError." I thought to myself: "That's a good idea." I ought to do that. […]

Resolving Analysis Services “The provider ‘SQLNCLI.1’ is not registered”

I know. While everyone else is moving on to SQL 2012 here I am upgrading a SSAS 2005 cube to SQL Server 2008 R2 Analysis Services. I can hear Garth imploring me to "Live in the now man!" So as I went about the mundane task of upgrading a cube from a really old version […]

Formatting MDX and DAX: Free Online Tool From Microsoft

Ever cut and paste a mess of generated MDX from Excel? How about a coworker who doesn't know how to use the "tab" key when working in SQL Server Management Studio? I came across this no frills online MDX formatter from "Microsoft Labs" and have been using it for the last few days to clean […]

Clearing the SQL Server Analysis Services Cache

Preparing to do some MDX performance testing?  Step one for each and every test should be to clear the cache.  This will ensure you are seeing the performance results without the benefit of having data already loaded up in memory.  How do you empty the MS SQL Analysis Services cache prior to running your query?