Interval Prompt's Usage? Example for usage in Project
Answers were Sorted based on User's Feedback
Answer / amar
Usage of interval prompt is,
If suppose we have difference between dates column
date diff
---------
3
5
9
15
20
In the above column we want display the
selected date in the interval prompt<10
Then go for Interval prompts.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
what r the filters in fwm and report studio
what is stitched query???
What are query items?
What are different events in Report studio?
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
How to generate cubes in cognos?
What is defined as Query studio?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
How do we drill through from a powerplay cube to reportnet?\
How is cognos model organization works?
----------------------What are the User Securities?
difference between imprompt and reportnwt1.1