Interested to Buy Any Domain ? << Click Here >> for more details...
Interval Prompt's Usage? Example for usage in Project
- 2 Answers
- 16146 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 is your project workflow and your role in the project?
What is a dashboard in Cognos Report Studio and how do we creae it
i would like enter some empty space after every 3 rows how is it possible....?
what is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,
what is conditional query subject and example
How to pass multiple values from picklist prompt to sub report filter?
----------------------What are the User Securities?
How to pass parameter value into html design page?
what is a query subjects item?
what is cube size?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Teradata 
