This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 🙂
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?
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
Thanks a lot for keeping going with this, the output now looks good. 🙂
Excellent!!!
Happy Data Blending!!! 🙂
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!
did you configure all the steps i mentioned in the 4th Reply ?
I selected the "Run Command", but I dont have the options that you show in the picture.