Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6872 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / chiru
hi, there are two ways to change date format in cognos....
1) In Query Studio right click on Date key and select the Data format ... Select Format type = "Date" In Right Side u will get different formats of date.. there u can select the Format type and click ok and then run the report
2) In Report Studio, right click on Date key and select Format type is "Date" and right side, display the properties... in Properties select the Date Ordering.. in drop down u will get date formats, select and click ok.. now run the report
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
What are the other methods working as deployment functionality?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What is model?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
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 folder?
What do you understand by the term 'model durability'?
What is a Transformer?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
Define olap designer?
How Metrics Studio is better than Report Studio?
