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
- 5696 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 are the roles defined by cognos platform?
What is the difference between a cascading report and drill through report?
what is catalog and types of catalogs in cagnos and which is better?
How do you improve the performance of the Cognos Analytics report
Give me any example of semi and non additive measures?
What is the use of Cognos scenario?
What is the difference between static and dynamic conditions?
What do you mean by drill through report?
Can you explain the advantage of using shortcuts?
Can you define cube?
How to generate cubes in cognos?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
2. What functional area you worked on.
What do you understand by the term 'dynamic cube'?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate
