When you create a child query in IBM®
Cognos® Analytics - Reporting, you can only reference items 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
-
Click the Queries icon , and click Queries.
-
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.
- Double-click the child query.
Items are now available on the Source tab .
-
Add items.
For example, to create a detail filter that references a package item, click the
Toolbox icon drag the filter object to the Detail Filters pane, and then add the
items in the Expression Definition box.
- Recreate the link between the child query and the parent
query by dragging the parent query to the right of the child query.
- 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.