Interested to Buy Any Domain ? << Click Here >> for more details...
I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.
- 2 Answers
- 6802 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 |
Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !
Write some methods to apply securities in framework manager model?
What is metric studio?what is score cards and how to implement score cards what is the use of score card?
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
what is the security module used in cognos?
What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?
1 Answers Cognizant, Niteo, SacSoft,
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
what is a query subjects item?
How to hide/unhide the prompts which are not used by unauthorized users?
what is the use of layout calculation?
what are the errors faced while bursting the reports and how to solve those errors?
How to create model and how to test model?
Teradata 
