How to connect to cube databases in alteryx

[deepika_durvasula]

Hi 

I have to extract data from cube databases using Alteryx. I have searched some info and understood that Alteryx doesn't support the connectivity to cube databases directly. I tried few methods using MSOLAP Provider but no success. Is there any way to connect to cube kind of databases from Alteryx?

Thanks in advance,

Deepika

[caltang]

This thread may be of interest to you Deepika: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Connecting-to-Cubes/td-p/10956... 

[deepika_durvasula]

Hey thanks for the reply.

I have tried using that method. But couldn't find any success. Any other approaches other than using macro?

Thanks, in advance,

Deepika.

[caltang]

What abou this? With a macro: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/SSAS-Cube-Connection-and-MS-Po... 

@deepika_durvasula 

[deepika_durvasula]

Hi,

I have tried this method, but I am facing 2 errors:

1. Error: MDX (5): Tool #23: The entry point is invalid.

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

Could anyone please help me in solving this issue.

Thanks in advance.

Deepika