[ windows server ] configure remote desktop

รูปภาพ

Advertisements

[ mssql ] query OLAP cube from the Excel

Prerequisites

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

1. In Excel, Data > From Other Sources

Image

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

Image

3. Add measure, select fact

Image

4. slice and dice

Image