Description:
Establish connection to multidimensional database.
Syntax:
olap_open(url, catalog, user, pwd)
Note:
Olap4jCli 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:
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: