CONNECTION subcommand (GETTM1 command)

The required CONNECTION subcommand specifies the IBM® Cognos® TM1® Performance Management system and associated TM1 server and any credentials that are required to access data on the TM1 server.

PMSYSURL

Specifies the URL for the Performance Management system where the TM1 server you want to connect to is installed. The Performance Management system is defined as a single URL for all TM1 servers. From this URL, all TM1 servers that are installed and running on your environment can be discovered and accessed. The keyword is followed by an equals sign (=) and a URL enclosed in quotation marks.

SERVER

Specifies the TM1 server. The keyword is followed by an equals sign (=) and the name of the server enclosed in quotation marks.

MODE=SETCREDENTIALS

Specifies that credentials are explicitly specified. This setting is the default. For SETCREDENTIALS, you must specify values for USERNAME and PASSWORD.

USERNAME

The TM1 user name with which to log on to the server. The keyword is followed by an equals sign (=) and a value that is enclosed in quotation marks.

PASSWORD

The password that is associated with the specified user name. The keyword is followed by an equals sign (=) and a value that is enclosed in quotation marks. By default, the password is assumed to be encrypted. If you do not want the password to be treated as encrypted, then specify ENCRYPTED=NO.

NAMESPACE

The IBM Cognos Business Intelligence security authentication provider that is used to log on to the server. This setting is only required when the server uses authentication mode 5 (IBM Cognos security). The keyword is followed by an equals sign (=) and a value that is enclosed in quotation marks. The keyword is ignored if the authentication mode is anything other than mode 5.

MODE=STOREDCREDENTIAL

Specifies to use the login information from a stored credential. To use a stored credential, you must be connected to the IBM SPSS® Collaboration and Deployment Services Repository that contains the credential. For STOREDCREDENTIAL, you must specify the CREDENTIAL keyword, followed by an equals sign (=) and the name of the credential in quotation marks.