olap_open()

Description:

Establish connection to multidimensional database.

Syntax:

olap_open(url, catalog, user, pwd)

Note:

An external library function. Whether or not the username and password are required depends on how the privilege levels are set up for the given server.

Parameters:

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 functions:

olap_close()

olap_query()