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

16. July 2013 Hans Esquivel Analysis Services , Analysis Services Tabular Mode , Multidimensional Expressions (MDX) Comments (0)
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]

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

11. February 2013 Hans Esquivel SQL Server , Analysis Services Comments (0)
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]