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.

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

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  

---

Define query studio?

0 Answers  

---

What are all the different types of prompt in cognos?

0 Answers  

---

Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  

---

How do we create row level security in cognos8?

3 Answers  

---

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

---

3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?

3 Answers   CTD, Wipro,

---

How do we run stored procedure?

1 Answers  

---

how many facts&dimensions tables in project? it's very urgent.........

2 Answers  

---

What is Tool Tip? and how to create in report studio?

1 Answers   Wipro,

---

7. What is performance tuning?

0 Answers  

---

Is it possible to create drill through access to other report from PDF report?

1 Answers   IBM,

---