Creating and publishing packages based on OLAP data sources

You can use IBM® Cognos® Framework Manager to connect to an OLAP data source and create a package based on a cube. You can then publish the package directly to IBM Cognos Administration, making it available for use in the IBM Cognos studios.

By default, each package contains a connection to only one cube. If you want to create a package containing multiple cubes, run the metadata wizard and create a package for each cube. Then create a package that includes individual packages as required.

Before creating a package containing multiple cubes, consider the potential performance impacts. In IBM Cognos Administration, each time a package is used, a connection is made to each of the data sources defined in the package. Creating large packages with multiple cubes can have a negative impact on performance. To offset the potential performance impact of creating one large package containing many cubes, create one package per cube and then create smaller combinations of packages as required.

By default, packages based on an OLAP data source do not contain vendor function lists. If you want to include the vendor function list, specify the function sets to include and then republish the package.

Note: To publish a package that contains a single cube, use IBM Cognos Administration. For information on publishing a package from IBM Cognos Administration, see the Administration and Security Guide.

Procedure

In the Welcome page, click Create a new project.

Tip: If you are already in Framework Manager, click File, New Project.
In the New Project page, specify a name and location for the project, and click OK.

You may be prompted to provide authentication information.
In the Select Language page, click the design language for the project.

The language that you select cannot be changed after you click OK, but you can add other languages. For more information, see Adding a language to a project.
In the Metadata Wizard dialog box, click Data source, Next.
Select your data source from the list of available data source connections, and click Next.

If the data source connection is not available in the list, you can click New to create the data source connection.
Specify a name for the package, and click Next.

Optionally, you can specify a description and screen tip for the package.
Specify who has access to the package.

You can add users, groups, or roles. For more information, see Users, groups, and roles.
Click Finish to import the metadata and create the package.
When prompted, click Yes to publish the package, or click No to return to the Project Viewer.