The OLAP Procedure

METASVR Statement

The METASVR statement identifies the SAS metadata repository in which existing cube metadata information exists or in which metadata about a new cube is stored.

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

The METASVR statement options can be used to override the metadata repository connection values that are specified through SAS start-up options.

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

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

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

Required Argument

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 32 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.
REPOSITORY='repos-name': is a string that specifies the name of a SAS metadata repository in which existing cube metadata information exists or in which metadata about a new cube is stored. The name can be a maximum of 60 characters. When using lowercase letters, embedded blanks, or special characters in the repository name, enclose the name 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.

Top of Page