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
- 5714 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
What are shortcuts? Where it can be used? What are the advantages?
What is set to be cardinality?
What is an olap designer?
What is the difference between ‘macro’ and ‘prompt?
Explain is there any comparison available for cognos reportnet vs crystal reports?
is there any difference between operational database and data base?if yes what r they?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you define cube?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What are the batches and it’s details?
How create measures and dimensions?
How do you improve the performance of the Cognos Analytics report
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
