Format MDX & DAX: web service for formatting is available

Format MDX & DAX: web service for formatting is available

  • Comments 4

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 http://formatmdx.azurewebsites.net/formatter.asmx.

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
  • FormatAsRtf
  • FormatAsRtfWithSettings

Enjoy!

Nick

 

 

Leave a Comment
  • Please add 6 and 7 and type the answer here:
  • Post
  • I`d used tool olappivottableextend.codeplex.com, there is MDX formatting using this service. I have a bug: Dimensions named by russian, incorrect returns. For example:  Original name = ({[Дата документа].[Календарь ГМД].[All], after formatting = [Äàòà äîêóìåíòà].[Êàëåíäàðü ÃÌÄ].[All]. There is incorrect encoding. I think better using Unicode codepage

  • Sorry, i`ve test now FormatAsPlainText - All correct. I think is another problem

  • This is not an encoding problem.  This is a problem of the font - it does not know how to draw cyrilic symbols.  Try setting Russian as dispay language.

  • I find your tool very useful for debugging mdx queries.

    Could you please add a Copy to clipboard button in the web form?

    I usually run the formatted query in Sql Management Studio.

    Manually copying the formatted query each time is a bit error prone, at least for me.

    Thanks a lot!

Page 1 of 1 (4 items)