Establishing a connection to the Cognos BI Server
Deprecated in v2.0.8 After the components have been installed and configured, follow these instructions to establish the connection.
Procedure
- Run TM1®.
- In the left pane of the TM1 Server Explorer,
right-click the Processes group and select Create New
Process. The TurboIntegrator window opens.
- Select the IBM Cognos Package option in the Data Source Type
dialog box. Package is selected by default.
- Package and Dimension: The Package and Dimension option provides a
simplified way to import data from dimensionally modeled sources and is not easily customized.
You can instead select Dimension if you only want to import hierarchies from a single dimension in a package.
- Custom Query: The Custom Query option works with DMR or non-DMR sources and provides more flexibility in selecting the items to query and provides more open access to the standard TurboIntegrator programming capabilities. See Connecting to Published Packages for more details.
- Package and Dimension: The Package and Dimension option provides a
simplified way to import data from dimensionally modeled sources and is not easily customized.
- Enter your connection details. If your IBM® Cognos® BI server permits anonymous logon, you can click Log on. Otherwise, enter the following credentials:
- Authentication Namespace
- The pull-down list shows all available authentication namespaces.
- User ID and Password
- Supply a user ID and password for a user in the selected authentication namespace.
- Sign-ons
- Allows you to manage sign-on information associated with the TurboIntegrator process. The button is enabled once you have successfully logged into the BI Server.
- A sign-on called "BI Server Logon" is automatically created for you the first time you authenticate to the BI Server. If you update the credentials in the Connection tab after the initial login, those changes do not update this sign-on. You must use the Manage Sign-ons dialog box to make changes to the sign-on. You can Add, Modify, and Remove sign-ons. Also, if you enter credentials on the Connection tab, then click on logon and modify the sign-on in the sign-on window, the credentials on the Connection tab are not updated.
- Removing a sign-on can make the TurboIntegrator process unable to run when anonymous logon is turned off.
- As you work with dimensions and measures, data source sign-ons may be created. These can also be managed through the Sign-ons window.
- Log on/Log off
- Click Log on to log in to the BI server. Once you are logged in, Log off becomes available to let you log out of the BI server.