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 condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
What is drill down and slicing and dicing whats the difference between them?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
-----------With out using DrillThrough how to do Reports?
2. What functional area you worked on.
What errors and types of errors you faced in Cognos ReportNet?
Give the advantages of cognos?
What DB View and Bus View?
What are the different uses of a repository manager?
How to do Performence Tunning in Cognos Reports?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What do you understand by the term 'dynamic cube'?
What is meant by Reportstudio shortcut?
Explain what is the difference between microstrategy and cognos reporting tool?