Answer / suresh

Model Filter: need to create a filter inside the FM model
itself.
(Stand Alone or Embeded)
Query Filter: Need to create in RS query.

Answer / kumar

Hi Friends,

We have Filters @ FM Level, Reprt Level

1) FM Level:
a) Stand Alone Filters, We prefer these kind of
Filters whenever we want to use filter for entire Package.
b) Embedded Filters, We prefer these kind of Filters
whenever we want to use filter for Particular Query Subject.

2) Report Level:

a) Summarized Filters are used to filter the group of
records ( Like Having clause in Oracle).( After the
Aggregation)
b) Detail Filters are used to filter the indivisual
records ( Like Where clause in Oracle) (before the
Aggregation)

&

We have Static Filters , Dynamic Filters @ Report Level.

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  

---

What is the difference between filter & Condition?

3 Answers   MetLife, TCS,

---

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  

---

What is the use of Excel files in Cognos8?

1 Answers  

---

set scope level in transformer

2 Answers  

---

---

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

0 Answers   HCL,

---

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  

---

difference between stored procedure and function?

4 Answers   Syntel,

---

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 Answers  

---

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

---

Whrer u can save the Report net documentation in our local system?

1 Answers  

---

--------------How to do Report Testing in Reports?

1 Answers   IBM,

---