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
Author: devinknight
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
SSIS to SQL Server Data Type Translations
I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS data types. At first glance
SSIS Source and Destination Assistants
In several previous posts I have described some of the usability changes that will come with the next release of SSIS. Annotations Data Flow Grouping
SSIS Annotations
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali. In previous posts I wrote about
SSIS Data Flow Grouping
There have been several usability features that have been added to SSIS in the latest CTP. One of these features is Grouping in the Data
SSIS Resolve References
One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z) is the new resolve reference
SQL Server 2012 no DTS support
The end has come! We’ve been told for several years the vNext of SQL Server will no longer support DTS and it appear that that
Date Dimension Using Computed Columns
Picked up this nice script from a client last week. Use this script below to create a Date Dimension for a data warehouse that is
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
Devin Knight 