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
Author: devinknight
SSRS – Join Function
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
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
Creating a PerformancePoint 2010 Data Source
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
Getting Started With PerformancePoint
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
SSIS – Event Handler Performance
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
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
Reporting Services 2008 R2 Report Parts
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
Reporting Services 2008 R2 KPI Ready
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
Auditing Report Executions with Free Source Code
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
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
Devin Knight 