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
- 7269 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sa
use Extract Function
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the services provided in cognos 8?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
------------- How to identify the Revenue Column in Report?
What are the advantages of cognos?
what is hints in cognos and where we use it.
Define query studio?
What is the importance of having monitor service in cognos?
--------------Diff b/w ODS and OLAP?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
what is online view?
What is called a slice?
What are all the components of Report Studio?
Can you define folder?
How do we convert from Numeric to be Words?
how u will determine the performence tune will occur either in report or system
