Server name

Enter the name of the IBM Cognos Finance server.

Port number

Enter the port number of the IBM Cognos Finance server. Use the port number that is specified on the IBM Cognos Finance Server Configuration page. The default is 8800.

Signon

Select the namespace to use for authentication.

Server name

Enter the name of the server.

Enter 80 as the port number.

IBM Cognos Now! connection string:

Enter /cognos/now/RelXMLAProvider.jsp

External namespace

Select the external namespace.

Server name

Enter the name of the server.

Planning Administration Domain (PAD ID)

If the cube was created using IBM Cognos Planning - Contributor version 7.3, indicate the Planning Administration Domain (PAD ID).

Port number

Enter the port number. The default is 8800.

External namespace

Select the external namespace for authentication.

Read cache size

The default value for this parameter is 80 MB. You can set this parameter to a value between 1 MB and 1 GB, as required for optimal query performance.

The optimal read cache size may be higher or lower than the default value of 80 MB. This is to be expected, as PowerCubes in production vary widely in type and query characteristics.

Note that the read cache size has no effect on the initial time required to open a cube.

The typical profile for query performance, or processing time, follows a pattern whereby performance increases with the read cache size and then levels off beyond the optimal setting.

To determine the optimal setting, we recommend that you lower the default by 10 MB (or 5 MB, or 1 MB, depending on the level of fine tuning desired) and use the resulting query performance results as a guide for establishing whether further reductions, or increases, are required.

The optimal read cache size will change as the cube grows and changes in the production environment. As a result, you should review the optimal read cache size when changes to the user’s query performance pattern, or changes in the PowerCube characteristics, occur.

Location

If all your report servers are installed on Windows computers, specify the Windows location. If all report servers are installed on UNIX computers, specify the Unix or Linux location.

Type the full path and file name for the cube. For example, for a local cube type C:\cubes\Great Outdoors Company.mdc. For a network cube type \\servername\cubes\Great Outdoors Company.mdc

For cubes that reside on UNIX computers, specify the correct UNIX location and type any characters in the Windows location because the Windows location cannot be empty.

If the report servers are installed on Windows and UNIX computers, and you want the report server running a request to access the PowerCube in both environments, specify the Windows and UNIX locations. To ensure that the same data is returned regardless of the environment in which the report server accesses the cube, the same cube file must be saved in both locations.

Signon

If you are using IBM Cognos 8 security, click Restrict PowerCube authentication to a single namespace, and select a namespace from the list.

If you are connecting to a password-protected PowerCube, click Cube password, and type the password in the Password and Confirm password boxes.

Select All applicable namespaces (including unsecured PowerCubes) only if you are migrating Series 7 PowerCubes to IBM Cognos 8 in your development or test environment. This setting can also be used for unsecured PowerCubes in a production environment.

For more information, see Securing PowerCubes.

If a cube password is required, click Cube password, then enter the password in the Password and Confirm password boxes. To create a user ID and password that automatically connects to the data source, click Create a a signon that the Everyone group can use.

For more information, see Securing Data Sources.