Replace Sets

You can replace one set with another for comparison.

When you replace a filtered set, such as top 5 products, or a selection-based set, such as a set containing New York, France, and Asia Pacific, in the crosstab, IBM® Cognos® Analysis Studio retains the context of the data to support your train of thought.

For example, you view your top 5 products. You drag Customers from the source tree to the crosstab to replace Products to see which customers purchased these products. The Products set is automatically moved to the Context section of the overview area, and Customers is shown in the crosstab. The values for Customers refer to the filtered Products set.

For information about replacing data in selection-based sets, see Insert Sets of Items in Complex Layouts.

Procedure

In the source tree, drag an item to the set that you want to replace.
Tip: Alternatively, you can right-click the item that you want to insert in the source tree and select a replacement option from the Replace menu.
Parent topic: Working With Items in the Crosstab