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

Can you define cognos decision stream?

992

---

What are the advantages of shortcuts?

968

---

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1078

---

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

2006

---

i was asked what are the caluclations done by you in your report? plz give reply

2193

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11744

---

What is set to be cardinality?

1174

---

What are the advantages of cognos?

979

---

How to do Performence Tunning in Cognos Reports?

2475

---

Define catalog in cognos and write its various types?

1183

---

What are the different types of important services used in cognos?

1019

---

When we save a report in report studio with what extn it save?

1066

---

What is the difference between low affinity and high affinity connections?

1019

---

Can you define framework manager?

1032

---

What is dtm?

1169

---