What is model filter and query filter?

Answers were Sorted based on User's Feedback



What is model filter and query filter?..

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.

Is This Answer Correct ?    6 Yes 0 No

What is model filter and query filter?..

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.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Cognos Interview Questions

what are diff b/w cognos and business objects

6 Answers   HCL,


These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com

4 Answers   IBM,


Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me

2 Answers  


How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..

2 Answers   IBM,


What is the diff between Drill through reports and Master detail reports?

2 Answers   CSC, TCS,






i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..

0 Answers  


----------------What is Scopr Relationship?

1 Answers  


..Architectural difference between cognos reportnet and cognos8?

3 Answers  


What is the difference between regular dimension and derminant?

0 Answers   TCS,


what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,


what is stitch query?

2 Answers   Syntel,


suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 Answers  


Categories