The OLAP Procedure

METASVR Statement

Identifies the SAS metadata repository in which existing cube metadata information exists or in which metadata about a new cube is stored. The METASVR statement options can be used to override the metadata repository connection values that are specified through SAS start-up options.

Syntax

METASVR OLAP_SCHEMA='schema-name' <option(s)>;

Details

Requirements

OLAP_SCHEMA='schema-name': is a string that specifies the name of the schema that has been defined in a SAS metadata repository. The name can be a maximum of 60 characters. The OLAP schema specifies which group of cubes that a SAS OLAP Server can access. Each OLAP schema can be accessed by multiple SAS OLAP Servers. However, each SAS OLAP Server has access to only one OLAP schema. When using embedded blanks or special characters in the schema name, enclose the name in quotation marks.

Options

HOST='metadata-server-host-name': is a string that specifies the IP address of the metadata repository host. An example is 'misdept.us.mar.com'. The address can be a maximum of 256 characters. When using lowercase letters, embedded blanks, or special characters in the host name, enclose the name in quotation marks.

PORT=port-number: specifies the numeric value of the port on which the metadata repository resides.

PW='password': is a string that specifies the password for the user identified with the USERID= option. The password can be a maximum of 512 characters. When using lowercase letters, embedded blanks, or special characters in the password, enclose the password in quotation marks.

USERID='userid': is a string that specifies the user's identification for the specified metadata repository. The identification can be a maximum of 256 characters. When using lowercase letters, embedded blanks, or special characters in the user ID, enclose the user ID in quotation marks.

Note: During an interactive SAS session, if connection information is not available either through start-up settings or through a METASVR statement, then you are prompted for the missing information. For more information about SAS start-up options, see the SAS Language Reference: Dictionary.

Example

Here is an example of a METASVR statement with all of its options set:

metasvr olap_schema='Banking Schema'
host='misdept.us.mar.com'
port=9999
userid=jjones
pw=’my password’;