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

What are the steps involved in migrating CRN enviroment to Cognos 8?

3 Answers   BMW, Goyal Group, Mersan,

---

---------------What is meant by Scheduling?

2 Answers   IBM,

---

what is the difference between filter and condition?

0 Answers   IBM,

---

How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.

4 Answers   TCS,

---

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,

---

Tell me about Dnamic and Static Dashboards?

0 Answers  

---

what is report view?

4 Answers   Cap Gemini,

---

What are all the advantages of Cognos?

0 Answers  

---

What is Portal Tab?

1 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,

---

In which types of reports does the page breaks applicable in Cognos...?

1 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,

---