Alteryx designer Discussions

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

Connected to Database Now what?

Highlighted
Meteoroid

I connected to my Analysis Services database and I am trying to use the visual query editor to get any result but everything give me the following error 

Microsoft OLE DB Provider for SQL Server 2012 Analysis Services.: Query (1,17) The Syntax for "'$Related Incidents"'."IncidentId" As "Count_IncidentID", INcidents.$Incid"

 

I've tried counting the rows and a few other thigns but I just cant get even the most basic output.  Thanks for any help you may be able to provide. 

 

Example SQL:

Select Incident.$Incident.Status As Status From Incident.$Incident Group By Incident.$Incident.Status

Highlighted

@nathan_fredette

there is no native support for connecting SSAS

are you trying to connect Multi Dimensional Cube OR Tabuler Model

If you are trying to connect OLAP cubes, then check this POST . i created a utility to connect SSAS cube

 

Let me know if you are trying to connect Tabuler Model. i can try to build another Utility when i see free time 

 

Thanks

saravanan

Highlighted

I have a cube that I want to use as an input in Alteryx, how do I connect to it?

Labels