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
- 4 Answers
- 5670 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sa
use Extract Function
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What junk dimension contains?
What you mean by drill across and what is the difference between drill through, drill across?
What are the different kinds of panes included in cognos?
What is meant by alternate drill down with ex?
How to apply securities for reports in cognos connection?
Can you define drill across?
What is the difference between a data mart and a data warehouse?
What is model filter?
What are the different types of important services used in cognos?
How create measures and demensions?
What is a dimension?
tell me two or three issues from client side and how to solve those issues?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is the model filter?
What is dtm?
