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.
If there could be the option to feed in a query via a file rather than an input box, that would be cool.
Also the SSAS.exe could have the option to override the Windows Authentication details.
For sure there were lots of errors until installing the ADO.NET part. A good technique to bug fix, we would browse to the MDXQuery.bat file in temp and edit a pause on the end. Running it would then give us a detailed explanation.
Would be great if the Alteryx teams could take pity on those of us who have to deal with Cubes, through no fault of our own. :)
I know this is an old thread, but wondering if anyone knows:
1. Is it possible to pass credentials with this approach?
2. Does this also work for Azure Analysis Services (AAS)?
I've tried to isolate the issue by constructing the mdxquery.bat file manually and entering details, but can't see anywhere to enter credentials, and not sure if this would work on AAS or just SSAS. Appreciate any insight you can offer! Otherwise, I may need to look into building a separate python script, but I'm quite rusty.
I am also using OLAP Cubes, specifically SSAS Multi-Dimensional Cubes. We have a lot of happy end users who do not have time to learn Alteryx or any other technical work like querying source data. They just want to drag and drop and pivot. Anyway, thanks for this work. Very helpful!