Prerequisites
Microsoft SQL Server 2005+ with configured XMLA Analysis Services endpoint. To allow XML for Analysis :
configure the firewall http://technet.microsoft.com/en-us/library/ms174937
configure the IIS http://technet.microsoft.com/en-us/library/gg492140
Exploring OLAP cubes and creating MDX query
Connection string URL format:
jdbc:xmla:Server=http://bdmssql.cloudapp.net/OLAP/msmdpump.dll;
MDX query example:
Overview
Content Tools