Ungrouping Column using DAX in PowerPivot or SSAS Tabular

To start this blog post, let me first explain the problem. Consider a scenario where you receive an excel sheet or data in the following format Category SubCategory Bikes Mountain Bikes Road Bikes Touring Bikes Components Handlebars Bottom Brackets Brakes Chains Cranksets Derailleurs Forks Headsets Mountain Frames Pedals Road Frames Saddles Touring Frames Wheels Clothing… Continue reading Ungrouping Column using DAX in PowerPivot or SSAS Tabular

Recovering from cryptic errors thrown when importing from PowerPivot

I am borrowing this title from one of the blog post from Cathy Dumas, since this post is just the extension of her blog post which she posted for resolving the error thrown while creating a SSAS tabular Model project in SSDT by importing from Powerpivot. I started to create a SSAS Tabular Model project… Continue reading Recovering from cryptic errors thrown when importing from PowerPivot

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… Continue reading Identifying Top MDX Queries running in SSAS environment

Unable to connect to SQL Analysis Services?

Real Quick Post on one of the issue I faced today while connecting to SQL Analysis Services on my own laptop. Today, when I tried connecting to named instance of SQL Analysis Services on my laptop using SQL Management Studio, I received following error TITLE: Connect to Server —————————— Cannot connect to *********sqlr2. —————————— ADDITIONAL… Continue reading Unable to connect to SQL Analysis Services?

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… Continue reading Unable to use Calculated Measures in MDX inside Category Groups of Chart Report Item in Reporting Services