[ mssql ] query OLAP cube from the Excel


– `SQL Server Analysis Services (MSSQLSERVER)` running on server

1. In Excel, Data > From Other Sources


Connect from same machine, fill `localhost`.

If connect from different machine, fill the IP address w/o port w/o instance name ( i.e. ) and the username I used is w/o the workgroup. However, we have to enable firewall port 2383 on the server.

NOTE : just notice the connection string generated in the connection property

Provider=MSOLAP.5;Persist Security Info=True;User ID=Administrator;Initial Catalog=My Customers initial;Data Source=;Location=;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error

NOTE : `My Customers initial` is the default name of the Analysis Services database.

2. Select cube that is on the server


3. Add measure, select fact


4. slice and dice