What I can do for obtain the information of a cube OLAP in Analysis Services and obtain in Excel, they are in different machine, The Excel do not have Analysis Service.
Printable View
What I can do for obtain the information of a cube OLAP in Analysis Services and obtain in Excel, they are in different machine, The Excel do not have Analysis Service.
Install analysis manager on the workstation
In Excel 2003
on the menu click Data-import external data-import data-New Source- Microsoft SQL Server OLAP Services-type servername
YOu should consider using Reporting service. it is web based and not need to install analysis thick client on all the machines.