Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

SSAS Cube Connection and MS Power Query

Highlighted
12 - Quasar

Dave,

 

Please replace the MDX macro (attached) wtih the old one

and let me know if this gives a fix 

Highlighted
7 - Meteor

Getting an error that MDXResult.csv has too many fields, when i check this file it looks ok but still no text delimiter.

I've been trying to debug and believe change is required to Program.cs add text delimiter as part of output and/or make it a pipe delimiter.

 

Unfortunately my C coding is basic at best, so would appreciate your support :)

Highlighted
12 - Quasar

we can fix it in Alterx. updated the macro

i think attached should work

Highlighted
7 - Meteor

Morning,

This now runs but the output is now removing the rows where value had issue e.g "North, Korea", was this what you are seeing also?

Highlighted
12 - Quasar

Hi Dave  , @nilbot

 

i fixed this issue . this is caused by the data comes with comma which i did not think :)

Download the updated SSAS.exe and replace with the OLD one

 

https://www.dropbox.com/s/rgfk4ffmhdoy0i8/SSAS.zip?dl=0 

 

 

Highlighted
7 - Meteor

 Thanks a lot for keeping going with this, the output now looks good. :)

Highlighted
12 - Quasar

Excellent!!!

 

Happy Data Blending!!! :)

6 - Meteoroid

So I get the "255 Stopped Working error" as well after upgrading to Analysis Services 11 per post.  When I open the macro shows File not found error for MDXResult.csv.  I went the temp folder and I dont see the .bat or .csv file from macro. 

 

Thanks for any and all help!

Highlighted
12 - Quasar

did you configure all the steps i mentioned in the 4th Reply ?

Highlighted
6 - Meteoroid

I selected the "Run Command", but I dont have the options that you show in the picture. 

Capture.JPG

Labels