Interval Prompt's Usage? Example for usage in Project

Answers were Sorted based on User's Feedback



Interval Prompt's Usage? Example for usage in Project..

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

Interval Prompt's Usage? Example for usage in Project..

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

Post New Answer

More Cognos Interview Questions

WHAT ARE THE TYPES OF LIST REPORTS?

4 Answers   Patni,


If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com

1 Answers   EDS,


which type of project we r going to snowflake schema

0 Answers   IBM,


how you create security to cubes ?????

4 Answers   iFlex, iGate,


Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 Answers  


What is the use of Generated Prompt? Where is it used in realtime project?

3 Answers   HCL,


What you mean by drill across?

0 Answers  


What is Normalization?

3 Answers  


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

0 Answers  


in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day

2 Answers   IBM, iFlex, iGate,


How can I change reports to another package???

3 Answers   IBM,


what is the procedure for scheduling conditional rendering?

0 Answers   Syntel,


Categories