MDX Query Parameterization for displaying Last 12 month's SSRS Report
User Rating: / 0
PoorBest 
Written by Khilitchandra V. Prajapati   
Friday, 29 June 2012 20:07

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.

Read more...

 

Tags: mdx, ssrs
 

Data Warehouse Explorer