I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.
- 2 Answers
- 5928 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagendra
create a filter in the report Query with date from and date
to parameters.
eg: date>=paramdatefrom and date<=paramdateto
When you run the report Select date prompt from jan 1 to jan
31 2012
| Is This Answer Correct ? | 8 Yes | 1 No |
For example if you are in Mar2012:-
_add_months(sysdate,-2) which takes you into Jan2012.
After this convert the _add_months(sysdate,-2) to t0_char or to_date as required.
| Is This Answer Correct ? | 0 Yes | 7 No |
how to get the all values from a prompt using 'ALL' use and display value in prompt
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the difference between static and dynamic conditions?
Explain how data modeling is useful to cognos in daily life?
What is conditional Formatting?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
what are the features in cognos8ui
-------------How you design DWH?
What is the difference between drill through, drill across?
What is the difference between low affinity and high affinity connections?
How can we change any header or footer for a group of reports
1 Answers Satyam, Tech Mahindra,
------------------What is Focalpoint?
Teradata 
