MII 11.5 OLAP Connector

[Former Member]

I am trying to connect MII 11.5 to SQL Server 2005 Analysis Services via the Microsoft OLAP connector.

I have setup the HTTP pump for SSAS [as found on the MS TechNet|http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx] and I can connect to the resulting web service via http://SERVER/olap/msmdpump.dll in a web browser, so I presume that the HTTP setup is correct.

I have tried various combinations of settings in the OLAP connector in MII: Key differences (I think) from the default include setting DataSourceInfo = "Provider=MSOLAP.3;Data Source=http://" and Web Service="/olap/msmdpump.dll".

Each configuration that I try, though, results in a error: "Server is currently disabled (OLAPConnector)."

Does the OLAP connector support SSAS 2005? If so then are there unique connection parameters required? If not then is there a workaround?

[jcgood25 · Accepted solution]

The error you are getting is from doing a New...OLAP Query in the Template Editor (the default data server for this connector type is the one called 'OLAPConnector') when it tries to do a ModeList query call for the drop down. The same will happen for an SQLQuery except it will be for the 'IDBC' data server.

Assuming this is showing up in the Java Console as well, are you seeing other errors in the server logs?

Regards,

Jeremy

[Former Member]

Thanks Jeremy,

Through some trial and error I eventually got it. The key problem that I determined was that I was starting with the MSOLAP connector instead of the other OLAPConnector, which appears to yield different results despite very similar parameters.

In my case, I copied the OLAPConnector (not the MSOLAP) and modified the catalog, web service and server appropriately and it works OK.

I continue to have a minor issue: If the cube or dimension DESCRIPTION field is not set (i.e. null) in the data server then discovery calls (CubeList, DimensionList) from MII (which pull back the name and description) will fail since it apparently cannot display null values. Any help on this item would be appreciated.