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
- 5697 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / venkapa naidu
I Dont the answer in congnos but in ORACLE
SELECT TO_CHAR(TO_DATE(Value,'J'),'DD-MON-YYYY') FROM DUAL;
is the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
where you can save the report net documentation in our local system?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
whats the difference between previous version of cognos and cognos 8 BI?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
what do u mean by bridge group? where we r using this one?
Explain what is the difference between native sql and cognos sql?
What do you understand by the term 'aggregate cache'?
how can I test reports in cagnos?
What is a Transformer?
How to create a cube in Transformer? What is the process? Please mention process thank u
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.
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
