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

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,

---

Which studio is used to create reports?

0 Answers  

---

What are the advantages of shortcuts?

0 Answers  

---

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  

---

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

---

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

2 Answers   IBM,

---

what are the dimensions that you have in your current project?list them?

0 Answers   IBM,

---

what is an outer join? difference between left outer join right outer join with an example?

1 Answers   HCL,

---

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

0 Answers  

---

-------What are the Adv of Star Schema and Snow Flake Schema?

4 Answers   Bank Of America,

---

What is Local Cache and how does it help in performance tuning

1 Answers  

---

What is the difference between regular dimension and derminant?

0 Answers   TCS,

---