venu

• Sep 16th, 2007

 

Level Span is used to eliminate duplicates in a report which contains columns with one-one relationships. Usually we use grouping to eliminate duplicates when there is one to many relation. But if there is one-one relationship and still there are duplicates, then we have to level span.

mail2alert

 Profile Answers by mail2alert Questions by mail2alert

• Dec 13th, 2007

 

Level span is used to eliminate duplictes in data, in cognos it is used repeat grouped item.using levelspan we can see the grouped data group by group.

For example, when country and city are
both grouped, you can choose to show the country name each time

-- the country changes, by spanning Country by Country
-- the city changes, by spanning Country by City
-- there is a new record, by specifying no spanning

Spanning one grouped column by another column is helpful if the second
column contains many items.

Steps
Open the report that you want.
Click the column for which you want to set the group span.
In the Properties pane, click the Group Span property and click the
column you want to span.