we have a column of int/varchar datatype,but when we run
the report we should get the date format
i.e., suppose date key is a query item consists of data as
20040105,20030503,20060410.......
output should be 5 jan 2004,3 may2003,10 apr
2006..........respectively.Can i knnow the answer
Answer Posted / sa
use Extract Function
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a data mart and a data warehouse?
What is the use of Cognos scenario?
What is an olap designer?
Can you define framework manager?
what is model and say about process how to create model and how to test model?
What are the ways to import data into catalog?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What junk dimension contains?
What is the size of database for you project?
What DB View and Bus View?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Can you define drill across?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
How do we drill through from a powerplay cube to reportnet?\
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..