– `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. 192.168.17.35 ) 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=192.168.17.35;Location=192.168.17.35;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