Creating a signon

The data source connection signon must be defined so that the query service can automatically access the data required for loading dynamic cubes.

About this task

A data source connection must have at least one signon that the query service can use to connect to the data source. If the data source connection has two or more signons, one of the signons must be named Dynamic Cubes. This signon will be used by the query service to connect to the data source.

Procedure

  1. In IBM Cognos Administration, on the Configuration tab, click Data Source Connections.
  2. Click the data source, and then click the connection to which you want to add a new signon.
  3. Click the new signon button New sign on icon.
  4. In the name and description page, type a unique name for the data source signon and, if you want, a description and screen tip, and then click Next.
  5. Type the User ID and Password to connect to the database, and click Next.

    The Select the users page appears.

  6. To add users and groups that can use the signon, and click Add.
    • To choose from listed entries, click the appropriate namespace, and then select the check boxes next to the users, groups, or roles.
    • To search for entries, click Search and in the Search string box, type the phrase you want to search for. For search options, click Edit. Find and click the entry you want.
    • To type the name of entries you want to add, click Type and type the names of groups, roles, or users using the following format, where a semicolon (;) separates each entry:

      namespace/group_name;namespace/role_name;namespace/user_name;

      Here is an example:

      Cognos/Authors;LDAP/scarter;

  7. Click the right-arrow button and when the entries you want appear in the Selected entries box, click OK.
    Tip: To remove entries from the Selected entries list, select them and click Remove. To select all entries in a list, in the title bar for the Name list, select the check box. To make the user entries visible, click Show users in the list.
  8. Click Finish.

    The new data source signon appears under the connection.