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
Name the types of report?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What is metric store database?
What are the components of report net?
What is a Folder?
------------- How to identify the Revenue Column in Report?
7. What is performance tuning?
What is main advantage datawarehousing over oracle?
What is the enterprise class platform architecture of cognos 8?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
what is the difference between native sql and cognos sql?
what is the difference between querystudio in reportnet and cognos8
What is the difference between static and dynamic conditions?