Alteryx designer Discussions

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

SSAS Cube Connection and MS Power Query

Highlighted
12 - Quasar

everything looks good except the path of EXE

can you provide the native path instead UNC path i.e "\\ay3nas01\SSAS\SSAS.exe" to "D:\folder\ssas.exe"

i suspect this could be an issue 

Highlighted
12 - Quasar

also, try to run the below command in command prompt window

 

"\\ay3nas01\SSAS\SSAS.exe" "sg3server" "AuBIx" "SELECT NON EMPTY { [Measures].[SLS] } ON COLUMNS, NON EMPTY { ([DIM TM].[YEAR].[YEAR].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [AuBIx]" "C:\Users\C094783\AppData\Local\Temp\Engine_5700_ba9a693949ee4cb5bb1a8f26b30ba493_\\"  

 

send me that error as well 

Highlighted
5 - Atom

@s_pichaipillai

Bingo!

Got it working. Running the command in the prompt window threw up an error regarding Microsoft.AnalysisServices.AdomdClient version 11

I checked and I only had version 10 (C:\Windows\assembly).

I was able to find version 11 through the MS SQL Server 2012 feature pack where I was able to download and install ADOMD.NET

Once I had upgraded this, the workflow executed without issue.

Thanks again for the troubleshooting and the tool, this will save a huge amount of time/effort.

This is my first experience in the Alteryx community and a very positive one. Cheers

 

 

 

 

Highlighted
12 - Quasar

@nilbot

 

Excellent, Glad to see its working :)

I was about to ask the version of SQL server you are using as I have developed this code using ADOMD 11 client

I will also create the version for both and document it

Highlighted
7 - Meteor

Hey, I'm getting an error code 

 

"Error: MDX (5): Tool #11: The external program "%temp%\mdxQuery.bat" returned an error code: -532462766"

 

Not sure if this an issue with the MDX i'm running or a  config issue

Highlighted
12 - Quasar

Dave

 

can you send me the workflow

also go to the tem folder and copy and paste the mdxquery batch command 

Highlighted
7 - Meteor

After line breaks in MDX this worked a treat :) thanks a lot for your support on this!

Highlighted
12 - Quasar

Excellent, Glad to see its working for both of you :)

 

Happy Data Blending!!!

 

Thanks

Saravanan

Highlighted
7 - Meteor

One challange i'm finding is where the output from MDX has comma in the text for example "Korea, North", which is causing columns to be split.

Is there away of adding text delimitor to output?

Highlighted
12 - Quasar

good to see there is an issue :)

i will take a look and send you the updated soon

Labels