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 |
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
---------------Tell me about DWH Concepts?
Can you define drill down and drill up?
What is a Datastore in Cognos?
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
What is slowely changing dimensions?why we are used SCD?
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
Difference betwween cognos report net architecture and cognos8 architecture
what is a Galaxy Schema?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
What are the different type of securities can we apply in framework manager?