All Analysis Services dimensions have a default All member that represents all the members for a particular attribute. For example, let’s say you have a
Category: SSAS
SSAS – Preserve Measure Null Values
Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in measure data of a fact
Testing SSAS Security in Excel
There are many posts available that describe how to test Analysis Services security from inside the development environment. Today I would like to share a
SSAS Dimension Attribute Discretization Methods
Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is often forgotten. Basically what discretization
SSAS Understanding Multiple Security Roles
In a previous article I showed how you can create dynamic security in SSAS. This is a great way to make all security table based
MDX – Color Formatting on All Measures at Once
In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services measures you create. Recently I
SSAS – Defining Attribute Relationships in 2005 and 2008
Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions. The benefits of creating attribute relationships are multifold. It
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that’s been useful to me recently. This MDX statement creates a named set of the
MDX – Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic is needed to be built
SSAS Cache Warming with an SSIS package
There are several techniques that can be used for performance tuning Analysis Services. You may already be familiar with the typical methods used like Partitions
Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also have another little feature that
Analysis Services Performance Optimization Tips
Over the last few weeks I have focused most of my blog energy into writing a couple articles. So I wrote about something I was
MDX Utility Belt of Calculations Part 4
This is part four in the series of blog posts that will help in building a library of calculations you can use as a reference
Devin Knight 