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: