First, set OLAP, which can be accessed by machines in the LAN through the HTTP protocol. Then, use Excel to connect to OLAP through HTTP. The settings are as follows:
1. Create an OLAP site
1. Find the c: \ Program Files \ Microsoft SQL Server \ msas10.mssqlserver \ OLAP \ bin \ ISAPI Directory, which contains two files and one sub-directory.
2. Copy the above files to another place, such as c: \ Inetpub \ wwwroot \ ISAPI.
3. Create a web site. Name: OLAP, Port: 8888, path: C: \ Inetpub \ wwwroot \ ISAPI
4. CreateProgramPool: olappool
5. Set the program pool of the site OLAP to olappool.
6. Execution permission: scripts and executable files
7. Click "Configure" to add a DLL application extension. File Path: C: \ Inetpub \ wwwroot \ ISAPI \ msmdpump. dll
8. configure authentication, enable Anonymous Access, and specify the user name and password (note that this user and the following OLAP role are the same user)
9. Add a new Web Service extension. Extension: OLAP, required file: C: \ Inetpub \ wwwroot \ ISAPI \ msmdpump. dll
Ii. OLAP (Multidimensional Dataset) configuration roles
3. Use EXCEL to connect to the OLAP analysis service. Server Name: http: // 172.16.6.8/OLAP/msmdpump. dll
Iv. OK