}ConnectionProperties

The }ConnectionProperties dimension is used only in the }ConnectionProperties control cube.

This dimension contains the following string elements that correspond to the properties that can be defined for replication connections on the Planning Analytics database.

Element

Description

INTEGRATEDSECURITY

Determines if the replication connection uses Integrated Login. If the connection uses Integrated Login, the value of this property is YES, otherwise the value is NO.

LASTSYNC

Time (GMT) at which the data was last synchronized on the planet server, from which the replication connection was established. The time format is yyyymmddhhss.

LASTSYNCSTAR

Time (GMT) at which the data was last synchronized on the star server for the replication connection. The time format is yyyymmddhhss.

LASTSYNCSTARRECORD

Time (GMT) at which the most recent synchronization resulted in data moving from the star server to the planet. The time format is yyyymmddhhss.

This element differs from LASTSYNCSTAR in that LASTSYNCSTAR reports the time of the most recent synchronization, even if the synchronization did not result in any data moving between star server to the planet.

NAMESPACE

The namespace ID of the Cognos® namespace when establishing a replication connection to a server that uses IBM® Cognos 8 security. Note that this property stores the ID of the Cognos namespace, not the descriptive name of the namespace.

PASSWORD

Stores and displays the password in an encrypted format for establishing a replication connection.

SYNCPLANET

Determines if the data on the planet server is updated during the synchronization process. If the data on the planet server is updated, the value of this property is YES, otherwise the value is NO.

SYNCSTAR

Determines if the data on the star server is updated during the synchronization process. If the data on the star server is updated, the value of this property is YES, otherwise the value is NO.

USER

For a given replication connection, stores the name of the user who established the connection.