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

-------------How you design DWH?

0 Answers   Bank Of America,

---

----------------Diff b/w Dimensional modeling and Relational modeling?

2 Answers   Cap Gemini, L&T,

---

architecture of cognos8

1 Answers   IBM, Sonata,

---

Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  

---

Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar

2 Answers  

---

what is a prompt value in report studio and variables ?

0 Answers  

---

5. Which type of report you build more, list, crosstab or chart and why?

0 Answers   IBM,

---

Can you define folder?

0 Answers  

---

i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

1 Answers   TCS,

---

What is Additive function?

0 Answers   IBM,

---

Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,

---

What is the difference between Standard and Metrics folder?

0 Answers  

---