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

What is Fullouterjoin?

1932

---

----------------Diff b/w Dimensional modeling and Relational modeling?

14878

---

Can you define set to be cardinality?

952

---

What do you understand by the cognos?

902

---

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

2505

---

what is log in cognos?

1140

---

Mention the difference between ‘macros’ and ‘prompt’?

1061

---

faq's on cognos

4000

---

hi my name is siraj i want to know cognos queriy language

2214

---

Explain the difference between native sql and cognos sql?

933

---

is cognos 7 is better than cognos 8

2116

---

what is the main advantage of impromptu over cognos reportnet?

984

---

------------------What is Inline Query?

2178

---

what is the difference between querystudio in reportnet and cognos8

2083

---

What is Additive function?

1971

---