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 are slice and dice?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What is the information present in the cognos configuration file?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
how u create security to reports ????
Define the cognos reporting tool?
How to a create header dynamically in a crosstab report in cognos 8.1?
What is dtm?
2. What functional area you worked on.
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
what is the use of layout calculation?