Error connect Excel to OLAP cube -
09-14-2006
, 03:53 PM
Hi,
I am trying to connect Excel to OLAP Server Cube but I am getting the error
Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again.
If you see this message again, create a new datasource to connect to the
database.
This is how I am connecting. I am using Office 2003. From new database Query
I select the tab "OLAP CUBES". then "New Connection" and "OK". I gave it a
name, and select OLEDB PROVIDER FOR OLAP SERVICES 8.0, then "CONNECT". I
entered my server name "SERVER" and selected the database I want to work with
and click finish. I then select the cube I name I want and click "OK". When I
try to now connect to the cube I get the error above. Any ideas?
Thanks |