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
Tag: SSAS
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
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
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in
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
MDX Utility Belt of Calculations Part 3
This is part three in a series of blog posts that will help you build an arsenal of MDX calculations that you can have ready
MDX Utility Belt of Calculations Part 2
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility Belt of MDX calculations. With
Devin Knight 