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

Explain the difference between powerplay transformer and power play reports?

0 Answers  


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

0 Answers  


Explain about Parametermap?

1 Answers  


Which studio is used to create reports?

0 Answers  


how u provide security to reports??how u provide security to packages ?

5 Answers   Wipro,


what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,


What is main difference mapplets and mapping?

0 Answers  


How to give a securites in object level&datalevel&pakege lavel in frame work manager?

1 Answers  


Why cognos decision stream is used?

0 Answers  


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

0 Answers   DELL,


-------------How to create a PortalTab?

1 Answers   Cap Gemini,


What r the names of the reports that you prepared?

0 Answers  


Categories