Monthly Archives: March 2012

MDX Query Parameterization for displaying Last 12 month’s SSRS Report

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, While working with SSRS reports for displaying some financial data; many a times we have to display data for particular time-frame. Or most commonly – last 12 month’s data. I am talking about the case where you are pulling data from SSAS Cube using MDX queries. In this particular example, I need to display SSRS report for last 12 month’s data from SSAS Cube. So I need to provide 2 things: StartDate and EndDate. But as the default expected behavior of the Report requires EndDate to be today’s date so we have to dynamically configure today’s date in … Continue reading →

A Set of Boon Tools – SSAS DMVs in SQL Server 2012

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, As you must have heard or started using DMVs (Dynamic Management View) available in SQL Server to get information about local server operations and server health. But today I would like to focus specially on DMVs for monitoring SSAS (SQL Server Analysis Services) and dig-down to find out how powerful it can be. DMVs for SSAS are known as “Analysis Services Dynamic Management View“. We can query these views by simple T-SQL SELECT statement. When use these views, they exposes analysis services schema rowsets in form of table, hence information presented will become self-explanatory. Major benefits of using … Continue reading →