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
What do you understand by ‘ibm predictive maintenance and quality’?
What do you mean by drill across?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
i have one file i saved in csv how can i take these file into framework manager
What is called Cognos powerplay?
------------- How to identify the Revenue Column in Report?
When we save a report in report studio with what extn it save?
Which lifecycle we will use for reporting?
What is the report studio?
what are slowly changing dimensions? Why we are used scd?
what is the difference between native sql and cognos sql?
What is difference between informatica power mart and power center?
please please give me some banking calculations in framework manager.
Can you define cube?
What are the batches and it’s details?