|

Identifying Top MDX Queries running in SSAS environment

SQL Server has management studio reports, performance dashboard reports to identify top cpu, duration, io queries which is possible due to the DMVs viz sys.dm_exec_query_stats which is available to track the queries. However with SSAS, we do not have any DMV similar to sys.dm_exec_query_stats which tracks and captures the statistics of the queries fired against…

| |

Unable to use Calculated Measures in MDX inside Category Groups of Chart Report Item in Reporting Services

Recently, one of our customers came across an interesting issue which many of us face while working with Reporting Services which fetches the data from Analysis Services cube using MDX. So I thought I will share this in this blog post for the benefit of the community. We have a following MDX query with Calculated…