Format MDX & DAX: web service for formatting is available

Hi. I created a simple web-service that formats MDX or DAX query into plain text, Rtf or Html. The address of the web-service is All the methods of the web-service are listed below.  There are 2 flavor of every method – without custom settings(=with default settings) or with custom settings. FormatAsHtml FormatAsHtmlWithSettings FormatAsPlainText FormatAsPlainTextWithSettings…

PivotViewer Extension for Microsoft SQL Server Reporting Services

Microsoft has released last year (2010) a new Silverlight control called PivotViewer. This new control helps us to make better use of the growing amounts of information around us by visualizing thousands of things at once in a way that reveals the relationships which connect them. At the heart of the PivotViewer control are “Collections”….

SQL Server Data Mining for the Cloud

Get powerful insights into your data with just a few clicks in your browser – no installation required –  with a set of web services that apply the Data Mining technology in SQL Server Analysis Services. If you have used the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins…


Fuzzy Lookup Add-In for Excel

Data cleaning is often a big challenge when working with textual data. The Fuzzy Lookup Add-In for Excel is a new tool from Microsoft Research and BI Labs that helps with the problem of identifying and matching textually similar string data in Excel. It is robust to spelling mistakes, synonyms, missing or added words and a number of…


Format MDX & DAX

Have a MDX query generated by Excel or any other client and want to understand what it does?  Try – a simple tool that formats MDX & DAX queries. There are few options that affect result of formatting. Feel free to drop a comment to this post with suggestions or bugs or anything else.

Reporting Services LogViewer

Reporting Services LogViewer Tool Sample is developed in Microsoft Windows Presentation Foundation (WPF) in Visual C# using Microsoft Visual Studio 2010. The sample demonstrates how to read and analyze the Reporting Services trace logs and the Report Server execution log data. The sample does the following: Trace logs record report execution activity and the environment variables that…