Answer Posted / 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 you mean by drill across and what is the difference between drill through, drill across?

1009

---

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2074

---

What is meant by junk dimension?

1153

---

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1989

---

What is difference between informatica power mart and power center?

983

---

What are the message flows?

960

---

Can you explain cognos planning?

1073

---

Is it possible to join multiple Databases in a Catalog?

1105

---

how to create measures and dimensions?

1061

---

Can we test the report other than manual testing?

2153

---

Write some methods to apply securities in framework manager model?

1091

---

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

14963

---

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1019

---

what are the errors faced while bursting the reports and how to solve those errors?

1995

---

Can you define framework manager?

1006

---