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
Why need staging area database for dwh?
----------------Describe DWH Architecture?
Please explain the different stages in creating a report in cognos report net?
What is the advantage of using shortcuts?
Explain what is the main advantage of impromptu over cognos reportnet?
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.
Can you define set to be cardinality?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What are all the types of report?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
difference between impromptu and cognos8
How to join multiple db in catalog?
What are the different kinds of panes included in cognos?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?