Implementing MDX Drillthrough in SSRS

Let’s say for some reason your users want to implement MDX DRILLTHROUGH statement (equivalent to the cube action provided by most OLAP browsers) in SSRS. Here’s a step-by-step way to implement this. For the purposes of this walkthrough, we are using the standard AdventureWorks Analysis Services database. You can obtain this and the related DW…

3

MDX Studio Quick Tips

Recently I had to use MDX Studio for some MDX query tuning. 2 quick tips: Latest download link for MDX Studio can be obtained from the support forum at http://ssas-info.com/forum/3-mdx-studio/ The earlier versions of MDX Studio are referenced from Mosha’s website at http://www.mosha.com/msolap/mdxstudio.htm Also very quickly, if you are finding that the Perfmon section in…

0