Troubleshooting OLAP/XMLA Connectivity
PLEASE NOTE: As soon as we update the Component with new features every new week the information might be outdated, please check our latest news.
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.
Please check back on the Catalog and Cube fields as one of them may be leading to the non-existing resource.
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://184.108.40.206:8080/mondrian/xmla
- For Microsoft SQL Analysis Services – http://220.127.116.11/olap/msmdpump.dll
Please note that your bindings may vary so check carefully. If the URL try gives a fail, you might need to configure server to accept XMLA connections. The following links might be useful:
- MS OLAP – http://technet.microsoft.com/uk-ua/library/cc917711(en-us).aspx
- Pentaho Mondrian – http://business-intelligence.phi-integration.com/2008/04/testing-mondrian-as-xmla-provider.html
If you run the Pivot table component from your local drive we advise copying it to any web server where it will be accessible via http://-like URL. Running Flash applications locally often requires additional permissions.
Ideally, put crossdomain.xml file into the root of your web server when XMLA is configured. This will allow Flash applications to access and read OLAP data cube data. We advise copying the sample content of such file from here – http://www.flexmonster.com/crossdomain.xml
The best way is to ensure your data source has “For everyone” permissions. In case of Microsoft OLAP – go to Management Studio, and connect to your Analysis Services. Open the Database you want to connect, then go to Roles and create a new Role with “full control” and add “Everyone” to members of this role.