When creating a connection to a Microsoft Analysis Services data source, you must specify a language. By default, the language is set to that of your computer’s regional setting. You can have only one language selection for a connection. For more information, search the Microsoft Web site (http://www.microsoft.com) or Microsoft Support Web site knowledge base (http://support.microsoft.com) for "locale identifier property".
If you want to publish a Framework Manager model that uses a different locale setting than a previously published model, you must first restart the Cognos 8 service.
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:
Cognos 8 Service must run as a domain account, and this domain account must be trusted for delegation and impersonation because it will present 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 Cognos 8 to use a Microsoft Active Directory namespace, where users are prompted for credentials as part of the Cognos 8 logon process. You can configure Cognos 8 to use these 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 Cognos 8 to use a Microsoft Active Directory namespace and to authenticate users for Cognos 8 using Kerberos authentication and delegation. You can configure Cognos 8 to automatically authenticate the user when accessing the Microsoft Analysis Services data source. The following configuration is required:
The 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 Cognos 8 Installation and Configuration Guide.