Publishing a PowerCube Using the Wizard

Use this method to publish a single cube if no other data source with the same name as this PowerCube's data source exists in the location you are publishing to.

Procedure

  1. In the PowerCubes list, right-click the PowerCube, and click Publish PowerCube As Data Source and Package.
  2. In the Publish cube dialog box, select the Start publish wizard radio button and click OK.

    This option is available only if no other data source with the same name as this PowerCube's data source exists in the location you are publishing to.

  3. In the Welcome page of the IBM® Cognos® Publish PowerCube wizard, click Next.
  4. If prompted to log on, select the appropriate namespace, type your user ID and password and click OK.
  5. In the Name box, specify a name for the published data source.

    This is the data source name that appears in the Cognos Analytics portal.

    Tip: Optionally, you can add a description and screen tip for the published cube.
  6. Click Next.
  7. In the Publish PowerCube dialog box, do the following:
    • If you want to set a value that is different from the default of 80 MB, enter this value in the Read cache size box (Publishing PowerCubes).
    • In the appropriate location box (Windows or UNIX/Linux), enter the location of the cube.

      The location includes the full path and cube name.

      This location must be the location where the IBM Cognos server accesses and reads the cube. This may or may not be the same as the cube build location. If you build the cube locally, your administrator may have to set up a network share where you can ensure the cube is deployed, after it is built, for use in IBM Cognos reporting and analysis. In this situation, you cannot test the data source until it is in the network share location.

    • Under Signon, if the cube is secured, click the Restrict PowerCube authentication to a single namespace radio button, and select the appropriate namespace from the list.

      Secured PowerCubes published to production environments must use the Restrict PowerCube authentication to a single namespace option. When the cube includes security from more than one namespace, the All applicable namespaces (including unsecured PowerCubes) option is intended only for testing migration from a Series 7 namespace to an alternate security provider. If you are testing the migration of IBM Cognos Series 7 PowerCubes and you want to review the security view that reflects the union of the applicable namespaces, you must log on to all applicable namespaces in IBM Cognos prior to accessing the package. For more information, see Upgrade an IBM Cognos Series 7 Secured PowerCube.

      If the cube does not include security, select the All applicable namespaces (including unsecured PowerCubes) option.

    • If the cube is password-protected, select the Cube password check box and then, in the password boxes, type and confirm the cube password.
  8. If you want to test the cube connection, click Test the connection and do the following:
    • If you are testing a secured cube, select the appropriate namespace, and enter the User ID and Password.
    • Click Test.

      If the cube connection fails, review the connection status message and take appropriate steps to resolve the connection.

      Note: If the cube contains custom views and you are logged on as Anonymous, you will receive an error message. This is because IBM Cognos cannot validate the user 'Anonymous' against the Cognos namespace user credentials. To avoid this situation, log on to the namespace with a user ID and password, and test the connection.
    • Click Close.
  9. Click Finish.
  10. In the Finish page, the Create a package check box is enabled and greyed out so that you can publish the package; click OK.
  11. In the Name box, specify a name for the published package.

    This is the package name that appears in the Cognos Analytics portal.

    Tip: Optionally, you can add a description and screen tip for the published package.
  12. If you want to change the location where the package is published, click Select another location, and browse to select the appropriate IBM Cognos folder.
  13. Click Next.

    If a package with the same name has already been published to the Cognos Analytics portal, you are prompted to replace the existing entry or enter a new name for the published package. Click OK to continue.

  14. If you want to change default suppression settings (Publishing PowerCubes), select the appropriate options:
    • Allow null suppression. Select this option to make suppression options available to the studio users when working with this package.
    • Allow multi-edge suppression. When null suppression is selected, this option determines whether users can suppress rows only, columns only, or both rows and columns. If this option is not selected, users can suppress rows only or columns only.
    • Allow access to suppression options. When null suppression is selected, this option determines whether users can choose the types of empty values that will be suppressed, such as zero or missing values. The types available to users depend on the studio.

    For packages that contain more than one cube, the selected suppression options apply to all cubes in the package. As well, these options apply to all users of a package, and cannot be set on an individual user basis.

  15. Click Finish.
  16. Click OK.

    Tip: You can enter the publish information in the Data Source and Package tabs of the PowerCube property sheet in advance, and use the wizard to publish the cube. The properties you set on these tabs will be populated when you use the wizard. If required, you can change the pre-set properties when you use the wizard.

Results

A cube is locked for five minutes after you publish it using the wizard. You cannot recreate it during that time.