olap_open()

Read(3492) Label: create, multidimensional database,

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:

olap_close()

olap_query()