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
Can you define snapshot?
Why cognos decision stream is used?
Write types of folders present in cognos?
-----------------What is Determination Model?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is a dimension?
difference between impromptu and cognos8
what are the special features in cognos reportnet?
What is model filter?
Can you define drill across?
How create measures and dimensions?
How do you improve the performance of the Cognos Analytics report
what are the filters in framework manager and report studio?
Explain the difference between native sql and cognos sql?