Answer / chiru

hi, there are two ways to change date format in cognos....

1) In Query Studio right click on Date key and select the Data format ... Select Format type = "Date" In Right Side u will get different formats of date.. there u can select the Format type and click ok and then run the report


2) In Report Studio, right click on Date key and select Format type is "Date" and right side, display the properties... in Properties select the Date Ordering.. in drop down u will get date formats, select and click ok.. now run the report

Answer / nasa

Hello it is possible...

IN ORACLE:----

Datatype is int or varchar... so first convert into date by using date function


Eg: to_date('20040105','yyyymmdd');

By using to_char() use can extract which format you want or which particular thing you want.. ex: month, year, date, time...


Eg: select to_char(to_date('20030503','yyyymmdd'),'DD Mon Yyyy') from dual;


here answer: 03 May 2003


IF you want this feature in Cognos use extract().


Regards,
Nasa...

Answer / venkapa naidu

I Dont the answer in congnos but in ORACLE
SELECT TO_CHAR(TO_DATE(Value,'J'),'DD-MON-YYYY') FROM DUAL;
is the query

Answer / sa

use Extract Function

whis meant by Thumbnails on cagnos?

2 Answers  

---

What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?

1 Answers   Cognizant, Niteo, SacSoft,

---

Why we take so long time to display date prompt before displaying a report? How can we reduce the time?

2 Answers  

---

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

0 Answers  

---

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  

---

How many types of models are present in cognos.?

4 Answers  

---

-----------Diff b/w OLAP and RDBMS?

0 Answers   Bank Of America,

---

1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 Answers  

---

What is the complex report you faced in real time?

0 Answers  

---

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

0 Answers   IBM,

---

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

0 Answers  

---

what is stitched query???

2 Answers   IBM,

---