Get the last 5 Days, for each Month of the Year using MDX query

In this session I'll show you how to script a query in MDX to get the last 5 days, for each month of a chosen year. After we test the query, we'll validate aggregate values for the first couple of months using a basic MDX query. [More]

Create Dashboards using PerformancePoint Dashboard Designer (SharePoint 2013)

In this article we'll show you how to create a Dashboards using PerformancePoint Dashboard Designer for SharePoint 2013. We will connect to the "AdventureWorksDW2012" cube, using an Analysis Services data source connection. [More]

Add conditional formatting to your PerformancePoint Services Analytic Grid, by defining a custom Scope calculation from within Analysis Services (SSAS)

Ever wonder how to provide conditional formatting to your PerformancePoint Services Analytic Grid? For example, you may want change the fore-color for measure values to green for positive values and red for negative values. [More]

Creating a New Named Set using SQL Server Analysis Services 2012 Cube Designer

In this session we'll show you how to create a Named Set in Analysis Services 2012 Cube Designer. We'll explain what a Named Set is, the difference between Static and Dynamic Named Sets and finally, demonstrate how to define a Named Set using Analysis Services 2012 Cube Designer. [More]

Calculate Growth from Prior Period values, using the ParallelPeriod (MDX) function

In this session I'll show you how to use the ParallelPeriod function in MDX to query the change in growth between two periods (e.g., last year and current year). This function is really useful while navigating through different periods such as year, month, quarter and semester. For example, this could be useful in providing business analysts with growth trend analysis for products and/or services. [More]

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]

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]