Oh, how I’ve waited for this day. Finally, the days of handwriting MDX queries in Datazen server are over for me. Thanks to the latest server update, the server can now handle MDX generated from a tool like SQL Server Management Studio or SQL Server Report Builder. Not only that, I have additional control over the field names and field types when the query results are returned. Let me show you how it works using SSMS – Right-Click on your database and select browse – The handy Model browser comes up where I can drag and drop my fields from my model and build my query. I’ll bring in Country Region Name and State Province Name from Geography plus Internet Total Sales from my Measures. My results are returned like so – Now I want to get the query that generated by this to use with Datazen. I can simply toggle off Design mode by clicking this button in the toolbar – And my query text appears – I’m going to copy this text and switch over to my Datazen control panel and paste this query as a new data view under my SSAS data source – Before today’s update, when I hit next, this query wouldn’t work. It would just bring back a blank result set. But now, a couple things now happen. The first one is, a new screen appears in the wizard – I now have the ability to change the display name, the data types being returned from the data source, and exclude certain fields from the result set. This gives me a lot of flexibility I didn’t have previously. So I’ll change my display name to the following – I hit next and Whammo (that was for Mike Gannotti) – the query not only works, it is all cleaned up and ready for my Datazen dashboards – This is great news for folks who love Datazen, but don’t love handwriting their MDX queries. And the new abilities to change the display name, data type and field list is there for all datasets, not just SSAS. So SQL Server customers, grab the new server build of Datazen and take advantage of this great new functionality. Thanks for reading!