Reference a package item in a child query

When you create a child query in IBM® Cognos® Analytics - Reporting, you can reference items only from its parent or from other queries. For example, if you add a filter to a child query, the only items that you can insert into the expression are items that exist in other queries defined in the report. To add an item from the package, you must unlink the child query from its parent.

Procedure

  1. From the report navigation menu, click Report > Queries.
  2. Unlink the child query from its parent by selecting the parent query shortcut to the right of the child query and pressing the Delete key.
  3. Double-click the child query.

    Items are now available on the Source tab Data icon.

  4. Add items.

    For example, to create a detail filter that references a package item, click the Toolbox icon The toolbox icon drag the filter object to the Detail Filters pane, and then add the items in the Expression Definition box.

  5. Recreate the link between the child query and the parent query by dragging the parent query to the right of the child query.
  6. If necessary, double-click the child query to complete it.

    For example, if you created a filter, you may need to complete the filter expression.