Answer / naresh

To create 12 columns for months by single case statement :-

Step-1: Create one derived column and name it as 'months'.

Step-2:In Derived Expression use the below case statement and click on ok -

case
when extract(month,DATE_Column)=1 then 'JAN'
when extract(month,DATE_Column)=2 then 'FEB'
when extract(month,DATE_Column)=3 then 'MAR'
when extract(month,DATE_Column)=4 then 'APR'
when extract(month,DATE_Column)=5 then 'MAY'
when extract(month,DATE_Column)=6 then 'JUN'
when extract(month,DATE_Column)=7 then 'JUL'
when extract(month,DATE_Column)=8 then 'AUG'
when extract(month,DATE_Column)=9 then 'SEP'
when extract(month,DATE_Column)=10 then 'OCT'
when extract(month,DATE_Column)=11 then 'NOV'
when extract(month,DATE_Column)=12 then 'DEC'

end

Step-3: Click on derived Column 'Months' and go to 'Structure' tab in File Menu and then click and 'Pivot list to Cross tab '

Step-4: Run and check the report.
Thats it ..

advantages of cascade prompt ???

3 Answers   iFlex,

---

How to do Performence Tunning in Cognos Reports?

0 Answers  

---

What are the components of the report studio?

0 Answers  

---

what is the difference between count and running-count functions?

1 Answers  

---

how to create measures and dimensions?

0 Answers   IBM,

---

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers  

---

How to Improve the Performance of the Report? i need this urgently .

4 Answers   HSBC,

---

Can you define cognos powerplay?

0 Answers  

---

What is meant by grouped star schema

0 Answers   IBM,

---

----------0Diff b/w Report Functions and Database functions?

1 Answers   IBM,

---

What are links & Segments in Cognos Framework Manager?

1 Answers   Systime,

---

how to Explain a complex report at the time of interview ? please post the answer very urgent?

3 Answers   HSBC, IBM, TCS,

---