Manage IBM Cognos BI cubes

Use this page to publish, export, or delete IBM® Cognos® BI cube packages. You can also see information about when the cubes were last published and when any fine-grained security rules were last updated.

To view this administrative console page, click Applications > Monitor Models > version_id > Manage Cognos cubes.

Publish or republish the Cognos cube packages

Publishes the IBM Cognos BI cube packages for the current model version (the default value) or for each model version.

Note that there is a cube package (and underlying schema) for each model version as well as a cube package for cross-versions. For example, suppose version 1 has the dimension State, and version 2 has dimensions State and Product.
  • The version 1 cube package is used for reporting against instances in version 1.
  • The version 2 cube package is used for reporting against instances in version 2.
  • The cross-version cube package is used for reporting against version 1 and version 2 instances and has the dimensions State and Product.

If you are currently working on version 2 and select For this model version, the version 2 cube package and the cross-version cube package are published. If you select For each model version, the version 1 cube package, version 2 cube package, and cross-version cube package are published.

Export cube package definition into a zip file

Exports the cube package XML files into a compressed file. Cube package XML files can then be opened in IBM Cognos BI Framework Manager tool, so that the cube definitions can be extended or altered.

Delete the cube package

Deletes the cube package.

Details

The Details section displays the following information:
  • External dispatcher URI

    The address that IBM Business Monitor uses to connect to IBM Cognos BI for managing IBM Cognos BI cube packages (for example, to publish, export, and delete the packages).

    If the external dispatcher URI fails validation, you can perform one of the following steps:
    • If you are using an existing remote IBM Cognos BI server, change the URI in the Configure Cognos Service panel.
    • For either a local or remote Cognos server, use the wbmSetCognosDispatcher command to reset the URI.

    You might need to restart the server after making this change.

  • Cognos Status

    The date and time that packages were last published.

  • Fine-grained security

    If fine-grained security has been configured for this model, the date and time that the rules were last updated.

Note that cube package permissions are based on the Monitor data security settings that exist at the time the package is published. Make sure any Monitor data security changes are valid before you publish the IBM Cognos BI package. If you need to update package permissions (so that they are synchronized with the latest Monitor data security settings), use the IBM Cognos BI Connection web client or wbmUpdatePackageSecurity.

If fine-grained security changes were made after the IBM Cognos BI cube packages were last published, you see a warning that you need to republish the cube to take advantage of the latest rule changes.