Answer Posted / prabhukumar
Level span is used to eliminate duplicates in data, in Cognos it is used repeat grouped item. Using level span 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.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is Metrics designer?
What are the themes in a data warehouse?
What is the use of powerhouse?
What is a Pivot?
What do you understand by the term 'aggregate advisor?'
2. What functional area you worked on.
What do you understand by user class in cognos?
What is the difference between set functions and filter function in dimensional data?
Can you define slice?
Can you explain a cognos controller?
Can you explain cognos planning?
Can you define cube?
What is cognos powerhouse?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is the difference between Open Connection command ang Open Session Command?
