To use Cognos product documentation, you must enable JavaScript in your browser.

Sets

Sets are the basic building block of Analysis Studio. A set identifies a group of items from a single hierarchy. In Analysis Studio, you can manipulate the individual sets in the crosstab.

Sets may be

The following are the different kinds of sets you can use.

Set Description
detail-based setA collection of data based on a selected item and all its immediate details. For example, you can have a set of data named years that includes quarters as details.
Selection-based setA collection of individual items that you have explicitly selected. The items or members may be selected from one or more levels from the same hierarchy.

If the target set is a selection-based set and the selected source tree items are from the same hierarchy, then the selected items are appended to the end of the list when dragged into the crosstab.

In the crosstab, you can create a new selection-based set from an existing set by selecting the members you want, then clicking Keep in the right-click menu. The new selection-based set replaces the set from which it originates.

level-based setA set based on a single level. For more information, see Insert All the Items of a Level.
stacked setAlso known as a union set. Two or more independent sets adjacent to each other in a crosstab. For rows, a new set is appended below or above the target set. For columns, the new set is appended left or right of the target set
measure setMeasure sets are comprised of one or more measures. In nested sets, measure sets may be placed on the inside of either the rows or the columns, but not both.
custom setA collection of data defined in Analysis Studio that can be saved and reused in the same analysis. For more information, see Create a Custom Set.
predefined setA set of members defined inside an OLAP data source as a list or by an expression. Cognos 8 can use predefined sets in analysis and report authoring. A predefined set is also known as a named set in Microsoft SQL Server Analysis Services.