Description:
Establish connection to multidimensional database.
Syntax:
olap_open(url, catalog, user, pwd)
Note:
External library function (See External Library Guide). Whether or not the username and password are required depends on how the privilege levels are set up for the given server.
Parameter:
|
url |
Address of the server on which a multidimensional database runs |
|
catalog |
The multidimensional database name |
|
user |
User name for accessing a multidimensional database |
|
pwd |
Password for accessing a multidimensional database |
Return value:
Return the connection object
Example:
|
|
A |
|
|
1 |
=olap_open("http://192.168.0.178:8088/msmdpump.dll","CubeTest","Administrator","admin") |
Connect to the multidimensional database named CubeTest. |
|
2 |
=olap_open("http://192.168.0.178:8088/msmdpump.dll","Analysis Services Tutorial") |
Connect to the multidimensional database named Analysis Services Tutorial. |
Related function: