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]

Create a Reporting Action, using SQL Server Analysis Services (SSAS) 2012 Cube Designer

In this session we'll show you how to create a Reporting Action using Analysis Services 2012 Cube Designer. We'll explain what a Reporting Action is, how to create one in SSAS 2012 and finally demonstrate how to render a SQL Server Reporting Services report by executing the Reporting Action from Excel. [More]

Improve query performance for aggregated and joined data with Indexed Views, using SQL Server 2012

In this session will describe how to improve your query performance by using SQL Server 2012 Indexed Views. We'll provide a brief overview of Indexed Views, review performance gains achieved from Indexed Views, applications that benefit using Indexed Views and finally illustrate an example Indexed Views usage. [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]

Display TreeView list of Reports, Datasets and Report Parts using Report Server Web Service EndPoint (ReportService2010)

Recently, I've had a few requests for how to display a TreeView list of Report Parts from SQL Server Reporting Services Report Server Web Services. This article will demonstrate how to query a list of Reports, Datasets and Report Parts using Report Server Web Service EndPoints. For this session we'll be using the ReportingServices2010 EndPoint. [More]

Create a Custom Report Template for SQL Server Reporting Services (SSRS) 2012

In this article we'll show you how to create a custom Report Template for use with SQL Server Reporting Services. What is a Report Template? A Report Template is a custom defined .RDL file which you save to the ReportProject folder of SQL Server Data Tools (SSDT). The custom Report Template will render in the list of available Report Templates to choose from within SSDT. The benefit is Reusability and Brand Standards for authoring business specific reports. [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]

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]