1

Closed

Unable to Format MDX Query

description

Hi Team,
There is one urgent requirement where I have to bring in data from the Cube and make some excel reports. This tool will be very handy for that purpose to customize MDX. I am using 32 - bit excel and the latest version of your add-in (OLAP_PivotTable_Extensions_Setup_for_32-bit_Excel_(v0.8.0))

I am getting an error when I am trying to format the MDX. The error says Mouse over to see error. But I didnt get any description when I did so. Request you to provide a solution for this

file attachments

Closed Jun 10, 2013 at 8:07 AM by furmangg
fixed and will appear in the 0.8.1 release soon

comments

furmangg wrote Dec 20, 2012 at 3:08 PM

That's odd it's failing. It's using the web service behind the following web page:
http://formatmdx.msftlabs.com/

You might try copying your MDX query into that webpage and having it format it.

Can you still reproduce the error in my add-in? Does it have to do with your networking setup (i.e. proxy servers or blocked websites)?

ruve1k wrote Apr 26, 2013 at 2:55 PM

Greg,
Nick Medveditskov moved the Format MDX & DAX website. It is no longer hosted at http://formatmdx.msftlabs.com/.
Instead, it is now hosted at http://formatmdx.azurewebsites.net

http://blogs.msdn.com/b/business_intelligence_labs/archive/2011/04/27/format-mdx-amp-dax.aspx#10407308

furmangg wrote Apr 26, 2013 at 4:39 PM

Yes, unfortunately I found out like the rest of us after the URL changed. The next release of my add-in will point to the new URL. Sorry about the inconvenience in the meantime. You can always manually copy the MDX into the new website and format it that way in the meantime.