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]

In this article we will examine how to design a Calculated Member using Cube Designer in SQL Server Analysis Services 2012. [More]

In this article we will examine how to design a Drillthrough Action using SQL Server Analysis Services 2012. The Drillthrough Action will include a Condition and multiple Drillthrough Columns. [More]

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]