DPM settings for publishing data

After server installation, the Cognos Server configuration settings, with the exception of DispatcherUrl, are stored in DPM as illustrated below. Further updates can be applied as necessary.

The above settings all related to publishing data. The DPM settings affect the default user interface behavior.

The SetDefaultForQuestions property is used to determine whether the default question type is set for each question when questions are loaded in the Metadata tab. For more information, see Metadata tab.

This properties collection includes information for each Cognos server:

The name as displayed in drop-down list. The first instance is used in cases where duplicate display names are used.

This property is used to define the root folder in the Cognos Content Store, based on which package is created.

This property indicates whether the package will be published to a location such as: /Public Folders/Household. When set to False, the package will be published to a location such as: /Public Folders/. The default value is True.

This property collection provides the login credentials for each Cognos Server (credentials are required in order to connect to the Cognos service). There are two credential options:

▪Specify the appropriate Cognos namespace UserID and password - The UserID, password and specific Cognos namespace are required. The namespace is defined via IBM Cognos Configuration > Security.

Note When using the Anonymous option, you must ensure that the Allow anonymous access property is set to True in IBM Cognos Configuration (Security > Cognos).

This property collection provides Cognos Data Source information for each Cognos Server in order to connect to the physical interview project-related SQL Server database.

When set to False, the Cognos data source is built based on the Microsoft SQL Server 2008 Native Client. When set to True, the Cognos data source is built based on ODBC with the RDB2 database name (which is not always the same as the project ID) and must be manually built in advance. The default setting isFalse.

When set to True, the Windows account currently used by the Cognos Service is used to connect to the Microsoft SQL Server. The default setting is True.

When using this setting, you must adhere to the following requirements:

▪In Cognos Server, the Cognos Content Store should be based on the Microsoft SQL Server Database (Windows Authentication).

▪In Cognos Server, the IBM Cognos Service must be changed from Local System account to This account, and This account needs to be set as a Windows account that is used to log into the RDB2 database. The setting is on the Log On tab of the IBM Cognos Service's Properties dialog box.

When WindowsAuthetication is set to False, the Miscrosoft SQL Server User and Password must be used to create the Cognos Data Source sign-on. The SQL Server account should have, at a minimum, read and write permission for the related database.

Used to support different Microsoft SQL Server Native Client versions when creating a Cognos Data Source, and when UseODBCDriver is set toFalse. The property supports the following values:

Note By default, the property does not appear in the DataSourceConnection property collection. If you want to change the property value, you must manually add the property.

The Cognos Dispatcher URL identifies the Cognos Business Intelligence server's External dispatcher URI, based on where the package will be published. Enter the appropriate Cognos Business Intelligence server URL (for example, http://<server_name>:<port>/p2pd/servlet/dispatch). The setting is required only when creating a Cognos package. The setting is defined in the IBM Cognos Configuration dialog: Environment > External Dispatcher URI.

Including the package name and location in the Cognos Content Store where the package is published, for example /Public Folders/HouseHold, means the package named Household is located in Public Folders, and is accessible for Cognos Reporting tools.