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

My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333

1 Answers  

---

What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?

1 Answers  

---

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  

---

What is the report studio?

0 Answers  

---

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

0 Answers   HCL,

---

Is cognos models are version compatible?

2 Answers  

---

How to generate cubes in cognos?

0 Answers  

---

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  

---

how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please

6 Answers   TCS,

---

how to do page breaks in cognos 8 Report studio pls give the navigation

4 Answers  

---

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

6 Answers   HCL,

---

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

---