Hi,

I was able to connect to Olap Server from Excel using Microsoft OLE DB
Provider for OLAP Services 8.0. I am using Excel 200 SP3.
Then I install SQL Server Analysis Services in my box.
Now when I Open excel and try to connect to Olap server it doesn't connect.
a) I give data source name
b) select from drop down Microsoft OLE DB Provider for OLAP Services 8.0.
c) Ckick "Connect..." - Nothing happen it does not pop up window to select
Olap Server.

when I use Microsoft OLE DB Provider for OLAP Services in data source
window's I am able to give server name and then select database name but then
I don't see any cubes in Cubes selection drop down even cubes are processed.

Thank you for your help,
-Ashok

Never mind. It's fixed now.
Look for Artical ID: 282037

Thanks to MS

"Ashok" wrote: