OLAP View: XML/A with SSAS

[jellis]

I am trying to connect to a Cube made in SQL Service Analysis Services.  I have configured an XML/A connection in JasperServer, and when I choose 'Test Connection', the server indicates that the 'Connection passed'.  Everything looks good with the connection itself at this point.

However, when I actually try to create a new OLAP View using that connection, I run in to an error:

com.tonbeller.jpivot.olap.model.OlapException: Malformed data source given for determining XML/A provider

Digging around the source a bit, I suspect I am running afoul of this segment of code in XMLA_Soap.java:

String upperDSString = dataSourceString.toUpperCase();
    if (!upperDSString.startsWith("PROVIDER=")) {
        throw new OlapException("Malformed data source given for determining XML/A provider");
    }

However, attempting to specify the provider as SqlServer (e.g., putting "Provider=MS;DataSource=REDACTED;" or "Provider=MICROSOFT;DataSource=REDACTED;" in the Data Source field), just results in a new error:

org.olap4j.OlapException: No datasource could be found.

Any insights on what it is I'm missing here to make this work?

 

[gregbowers23]

Hello

To fix the issue, ensure that the data source string in the XML/A connection is correctly formatted with "Provider=MSOLAP;" or "Provider=MSOLAP.8;". Double-check server, database, and credentials details.

Thank you.