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

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

0 Answers  

---

what is the diffence between render variable & style variable with egs? Plz reply ASAP

4 Answers   TCS,

---

Where do you edit cognos sql in report studio?

3 Answers   HCL,

---

What is defined as catalog and types of catalogs in Cognos?

0 Answers  

---

plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?

2 Answers  

---

Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...

1 Answers  

---

Whrer u can save the Report net documentation in our local system?

1 Answers  

---

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

---

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?

0 Answers  

---

What is stitched Query?

5 Answers  

---

I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name

37 Answers   Cisco, L&T,

---

Types of Performance Tuning?

2 Answers   CGI,

---