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
- 6807 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 |
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
------------ Diff b/w MemberCaption and MemberDescription?
How can we find out cardinality between two tables?
Give the advantages of cognos?
what is the difference between list sequel and cross tab sequel?
can any one say the which is the best performance in framework manager
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?
What are the different uses of a repository manager?
Is there any comparison available for Cognos Reportnet Vs Crystal reports?
difference between imprompt and reportnwt1.1
How is possible this scenario using in type-in prompt.?
Explain is there any comparison available for cognos reportnet vs crystal reports?
Teradata 
