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
Overview
Content Tools