Answer Posted / 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...

4. How many dimensions did you use in your reports?

1897

---

---------------Describe OLAP Reporting and RDBMS Reporting?

2059

---

----------------------What are the User Securities?

1800

---

What is defined as Cognos Impromptu?

1032

---

What do you mean by drill through report?

926

---

2. What functional area you worked on.

2283

---

New coloums are added in database, then how you know in report level

1516

---

1. Explain your project.

1988

---

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

2169

---

Can you explain model durability?

1009

---

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2148

---

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2311

---

What you mean by drill across?

979

---

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3255

---

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

1058

---