Connect to a Cube Via Alteryx

Question

Hi,

I am trying to connect to a cube  (Microsoft Office Data Connection) via Alteryx. I have created the connection, and in the Visual Query Builder, I see the names of the various tables within the cube. I am using MDX to attempt to query the data, and when I test my query, it says successful. However, when I go to run the workflow, I get the following Error:

Error: Input Data (3): Error opening table "{MDX QUERY-}" Interface ISupportErrorInfo not available

How do I fix the ISupportErrorInfo Error?

apathetichell · Answer

@albert_alaluf-> https://learn.microsoft.com/en-us/analysis-services/multidimensional-tutorial/lesson-2-2-defining-a-cube?view=asallproducts-allversions

KGT · Answer

Just flagging that the issue could be in the connection type. You are using a Microsoft Office Data Connection and connecting to SSAS.

I did a job about 2016 that connected to SSAS from Alteryx. Even then, there was very little support or updates to connect from non MS services. I ended up having to use a CLI to download the data in XML format and parse it. I built a tool for it at the time, but there were definitely straws holding up walls (and significant data limits). From that point I said "no" to connecting to SSAS. I can't even find that CLI now.

I only say this, as the issue might be right at the start with the type of connection.

albert_alaluf · Answer

Hi @adam_rafael_18

When you say 'cube', is it essbase?