Blog

Troubleshooting OLAP/XMLA Connectivity

Today we will talk about common troubles when you try to connect to OLAP cube with Pivot Table & Charts component. Feel free also to use our SQL Analysis Services Diagnostics Tool to verify the connectivity.

I get a "Invalid datasource or catalog." error.

Please check back on the Catalog and Cube fields as one of them may be leading to the non-existing resource.

I get a "Error #2032" error.

You have to verify your XMLA-enabled OLAP cube server is up and responds fine. The easiest way is to first verify the server is available by http, so you may open the direct URL up in the browser:

  • For Pentaho Analysis Services (Mondrian) - http://54.196.223.158:8080/mondrian/xmla
  • For Microsoft SQL Analysis Services - http://54.196.223.158/olap/msmdpump.dll

(more…)

Showcase: Connect Pivot Table and Chart Components to XMLA based OLAP Cube

With the Flexmonster pivot table component you can connect to Microsoft SQL Server Analysis Services (2005, 2008) or Pentaho Analysis Services (Mondrian) as well as any other business intelligence software that supports XMLA standard.
Follow these simple steps to get your Pivot connected to XMLA-based OLAP cube: (more…)