Create a package with the Self Service Package wizard - IBM Cognos

In Create reporting packages with IBM Cognos Framework Manager” we discussed metadata modeling and how to create a reporting package in IBM Cognos Framework Manager. For certain online analytical processing (OLAP) sources, you must create and publish a package from IBM Cognos Framework Manager. For SAP Business Information Warehouse (SAP BW) and IBM Cognos PowerPlay Studio PowerCube data sources, however, you can create packages in IBM Cognos Connection, and they will be listed in Public Folders or My Folders.

You must meet two prerequisites to perform this task:

  • The user must have execute permissions for the Self Service Package wizard capability. Select IBM Cognos Administration and navigate to the Security tab. Then, click Capabilities Capability Self Service Package Wizard.
  • You must enable the self-service package capability for a data source; it is a property of a data source in IBM Cognos Administration. On the Connection tab, you have to enable the option Allow personal packages
  • Enabling self-service package capability for a data source

    Enabling self-service package capability for a data source

Create a package for Cognos PowerCubes

If you have an IBM Cognos PowerPlay Studio PowerCube as a data source and if you want to use it in one of the IBM Cognos Studios for creating reports or analysis, you first must create a package. In our example, the data source is a Sales and Marketing Cube that is part of the IBM Cognos samples. The data source must have the self-service package capability enabled to be listed as a data source in the Self Service Package wizard.

To create a package for a PowerCube data source, follow these steps:

  1. Open the IBM Cognos Connection, and in the upper-right corner, click theNew Packageicon,
  2. Creating a new package from IBM Cognos Connection

    Creating a new package from IBM Cognos Connection

  3. Select the data source that you want to add from a list. For our example, click Sales and Marketing Cube and then click OK.
  4. Select a data source for a package

    Select a data source for a package

  5. Enter the name for the package (leave the default name, Sales and Marketing Cube). Select a location for a package. The default location for packages is My Folders, but you can change that here if you click Select another location. Click Next
  6. You can define null-suppression options here:
    • Allow null suppression: Enables suppression.
    • Allow multi-edge suppression: Allows the studio user to suppress values on more than one edge.
    • Allow access to suppression options: Allows the studio user to choose which types of values will be suppressed, such as zeros or missing values. By default, all options are checked, in
  7. Null suppression options for a Cognos PowerCube

    Null suppression options for a Cognos PowerCube

  8. Click Finish.
  9. A new package for a Cognos PowerCube is added to IBM Cognos Connection,Any of the IBM Cognos Studios can use this package for reporting.
  10. New package for a Cognos PowerCube

    New package for a Cognos PowerCube

Create a package for SAP BW

For SAP BW data sources, the prerequisites are the same, but creating a package has additional SAP BW-specific steps. To add an SAP BW data source in a package, follow these steps:

  1. In IBM Cognos Connection, click the New Package icon in the upper-right corner.
  2. Type the name for the package, and click Next.
  3. Select the objects that you want to include. The number of objects that you can select is limited. By default, you can select a maximum of two cubes and five info queries. You can change these settings, but be aware that the longer an SAP BW import takes, the more time the server spends processing the request, which might have an impact on its performance for other applications.
  4. To import SAP BW queries that contain dual structures and use the structures in IBM Cognos queries to control the amount and order of information that your users see, click Enable SAP BW Dual Structures support. Click Next.
  5. Select the languages to include in the package, and click Next.
  6. Specify the object display name.
  7. To have objects in the model organized in the same way that they are organized in Business Explorer Query Designer, click Enhance the packagefor SAP BW
    organization of objects
    .
  8. If you want to use Dynamic Query Mode with the data source, select Use Dynamic Query Mode.
  9. Click Finish.
  10. When the “Package successfully created” message appears, you can edit variable properties (click Edit the SAP BW variable properties for thepackage after closing this dialog) or click Close to finish creating the package.

A new package for an SAP BW will be added to IBM Cognos Connection.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

IBM Cognos Topics