Creating and using MDX Stored Procedures - ADOMD.NET Server Programming

In this session we'll show you how to extend the functionality of Analysis Services and MDX by developing .NET stored procedures (previously called user-defined-functions). We will be using the ADOMD.NET server components to develop our custom Multidimensional Expressions (MDX) functions and stored procedures, which will run on an instance of SQL Server Analysis Services (SSAS). [More]

Create a custom expression to handle dynamic Fill Colors on Sparkline series values, using Reporting Services (SSRS).

In this session we'll show you how to change a Sparkline series fill color when value(s) are either positive or negative. This session demonstrates how to work with Sparkline’s using SQL Server Report Builder 3.0 for authoring and designing the report. [More]

Creating a simple Key Performance Indicator (KPI) using SQL Server Analysis Services (SSAS) 2012

A KPI is a quantifiable measurement for gauging business success. In Microsoft SQL Server 2012 Analysis Services (SSAS), a KPI is a collection of calculations, which are associated with a measure group in a cube, that are used to evaluate business success. [More]