Interval Prompt's Usage? Example for usage in Project
Answer Posted / chiru
Interval prompt is used to find the interval between two dates.......
For example u r Having two dates Order Date and return date of a product... u would like to know the duration between Order Date and return date.......
1)First Drag Product name, Order date, return Date...
2) Drag a Query Caluclation and drop to the middle of Order date and Return Date Columns......
3) Give name as Duration...
4) Now goto prompt Page and Create a New Prompt Page..
After drag and Drop Interval prompt....
5) Give Paramater name as "Interval Prompt"
6) on next step apply filter on Interval column ....
7) Click finish.......
Now run the report and u will get interval prompt... in prompt enter the duration like 3 days or 5 days like that
Now u will get the product which returned for 3 days or 5 days.....
Thanks
Chiru
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
tell me two or three issues from client side and how to solve those issues?
Define olap designer?
Explain what is the difference between native sql and cognos sql?
How to do Performence Tunning in Cognos Reports?
how to merge 2 crosstabs thans
What are products of cognos?
What are the types of security?
how can I test reports in cagnos?
Explain is there any comparison available for cognos reportnet vs crystal reports?
What is zero-foot print?
is cognos 7 is better than cognos 8
what is power prompt in cognos ep7series?what is the use of this?
how u will design the report if the objects are available
When we save a report in report studio with what extn it save?
Define query studio?