Follow the steps below to connect to a Microsoft Analysis Services (OLAP) Cube:
Bring up the Data Source Creation Wizard, by navigating to Data->New Connection. Connect to Analysis Services 2000 by clicking on MS Analysis Services (OLAP) 2000 or connect to Analysis Services 2005 or higher, by clicking on MS Analysis Services (OLAP) 2005.
Set required connectivity information, including the server address, the username and password as well as the name of the database you wish to connect to. Then click OK.
Finally, select the desired cube from the list and click OK.
|
To connect to an offline cube file (with the CUB extension), specify the file name instead of a server name.
|
See Also