Answer / 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.

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

3 Answers   ComNet,

---

i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.

2 Answers   IBM,

---

What is snapshot ?

4 Answers   IBM, TCS,

---

what is power prompt in cognos ep7series?what is the use of this?

0 Answers   HCL,

---

what is the difference between querystudio in reportnet and cognos8

0 Answers   CTS,

---

what r the names of the reports that u prepared???

9 Answers   Covansys, IBM, Wipro,

---

What is model filter and query filter?

2 Answers   Wipro,

---

--------------How to do Report Testing in Reports?

1 Answers   IBM,

---

how to perform single sign in cognos by using url?

0 Answers   IBM,

---

Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)

7 Answers   AIG, IBM,

---

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

---

What are the ways to import data into catalog?

0 Answers  

---