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.
Enjoy!
Nick
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!