What is model filter and query filter?
Answers were Sorted based on User's Feedback
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 |
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 |
1. Differences between Merge and Union In Cognos?
What are all the types of report?
I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.
What is meant by junk dimension?
why u need to publish the package?
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
what is fact less fact give me proper example?
What is snapshot thumbnail
what is the difference between aggregation and roll up aggregation?
How to improve the performance of the report at the report level?
What is the function of cognos dispatcher?
What are cognos connection initial page components?