or modify
a data source connection . IBM Cognos 8 and PowerPlay Enterprise Server support connectivity to Microsoft Analysis Services only from a Windows platform, and both require the Microsoft Pivot Table client libraries. The following configuration is required:
IBM Cognos 8 Service must run as a domain account, and this domain account must be trusted for delegation and impersonation because it presents the user’s credentials to Microsoft Analysis Services.
The domain account should be added in local security settings in your Windows operating system administration tools.
Note: You must restart your server after changing this property.
The domain account should be a member of the OLAP Administrators group on the Microsoft Analysis Services computer.
The OLE database for OLAP (ODBO) client must be installed. This is included in the Microsoft Analysis Services installation files.
You can configure IBM Cognos 8 to use a Microsoft Active Directory namespace, where users are prompted for credentials as part of the IBM Cognos 8 logon process. You can configure IBM Cognos 8 to use the same credentials automatically when accessing the Microsoft Analysis Services data source. You must configure the data source connection for Microsoft Analysis Server for An external namespace and that namespace must be the Active Directory namespace.
You can configure IBM Cognos 8 to use a Microsoft Active Directory namespace and to authenticate users for IBM Cognos 8 using Kerberos authentication and delegation. You can configure IBM Cognos 8 to automatically authenticate the user when accessing the Microsoft Analysis Services data source. The following configuration is required:
The IBM Cognos 8 gateway must be installed on an IIS Web server that is configured for Windows Integrated Authentication.
Content Manager must be installed on a Windows 2003 or Windows XP server.
Content Manager, the report server (Application Tier Components), IIS Web server, and the data source server (Microsoft Analysis Server) must belong to the same Active Directory domain.
The data source connection for Microsoft SQL Server must be configured for An external namespace and that namespace must be the Active Directory namespace.
The report servers are trusted for delegation.
For more information about installation options for the gateway and Content Manager, as well as configuring the namespace and delegating trust, see the IBM Cognos 8 Installation and Configuration Guide.
You specify connection parameters when you create a data source or modify
a data source connection .
Parameter | Description |
Server Name | Enter the server name where the databases are located. |
Named instance | Enter the named instance if one was specified during installation. This parameter is used only by Microsoft Analysis Services 2005. |
Language | Select the language. This locale is used as a design locale by the report author and is used only for retrieving metadat from the cube to display in reports. Once the reports are created, they can be run in any locale. |
Signon | For more information on signon, see Securing Data Sources. Select IBM Cognos 8 service credentials to authenticate using a domain account. To use service credentials, ensure that IBM Cognos 8 is started as a service and that the service uses a valid domain account. The service account should be added to the local OLAP administrator group on the machine that runs Microsoft Analysis Services (MSAS). To use an external namespace, select An external namespace and select the Active Directory namespace. To create a user ID and password that automatically connects to the data source, select Create a a signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes. |
