With PowerPivot in Excel 2010 you will find a fancy new formula language called Data Analysis Expression (DAX). DAX is used for extending what you
Recently I inherited a set of SSIS packages that did a pretty simple calculation for age. It used the following expression, which could just as
Often when designing a Reporting Services with parameters you may be required to display those parameter values on your report. This is beneficial when you
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
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
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
In a previous post I wrote about getting started with PerformancePoint 2010. In that post you learned about what PerformancePoint is and where to open
PerformancePoint is a great tool for monitoring and analyzing the performance of your business at a high level but also has the ability to dig
Event handlers are a great tool for managing errors and other events that occur during the execution of a package run. Using event handlers can
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
Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be help for displaying KPIs in
As I begin to explore more and more of the new feature that will be available in SQL Server 2008 R2 I can’t help but
Have you been looking for a way to measure report performance? Want to know who accesses your reports most frequently? Well there are some free
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
Devin Knight 